Dear IFC Experts
You kind help is appreciate, I have a request from business where they want to add unit price as “ Current Cost + 10% margin” in customer order line for specific customers. Our costing method is weighted average so cost is changing frequently. As at now, we user price list and the problem is user needs to change it each time.
Have you got this kind of request from business and what would be the best approach to achieve this ?
If you have a known set of catalog numbers as sales parts you can search for, you could download the WA cost on a nightly basis via scheduled migration job and then upload using a different migration job to the sales price list lines. We do something similar on a nightly basis to prevent users from changing prices. But if your business can manage the price fluctuations, then this method would be the simplest I can think of.
Hi Tj12,
You can use from Sales Part Base Prices when the “Origin from Costing” should be checked. in that way your Baseline Price should be retrieved from the Costing component.
Regards,
Hi
Thanks for your feedbacks and appreciate it. This is a very good solution. But scheduling daily will be a problem since cost can be changed within the day due to multiple orders.
Do you know a way to schedule these ?
I see, yes, if you need to run this more often than daily, then agree it could be too slow, just depends on how you want to control this.
If you want to continue with the current solution, you can schedule the Update base prices as a database task like this. We have this one running for a couple of years.
I see, yes, if you need to run this more often than daily, then agree it could be too slow, just depends on how you want to control this.
If you want to continue with the current solution, you can schedule the Update base prices as a database task like this. We have this one running for a couple of years.
Hi Shawn
Will you be able to guide me how to create this task since I have not done this before. I am new to IFS
Go to Scheduled Database Tasks, Create New
On the new window, give the task a Schedule Name
Set the Task Name as shown - Start Add Prt to Price Lists
Then set your frequency and time, you should try to avoid your peak times of the day for other transactions.
The Parameters set as shown would just perform the update on all parts - that is the % setting
Calculate the date to make sure the next execution is scheduled, then save the Task Schedule and make sure it is Active
Go to Scheduled Database Tasks, Create New
On the new window, give the task a Schedule Name
Set the Task Name as shown - Start Add Prt to Price Lists
Then set your frequency and time, you should try to avoid your peak times of the day for other transactions.
The Parameters set as shown would just perform the update on all parts - that is the % setting
Calculate the date to make sure the next execution is scheduled, then save the Task Schedule and make sure it is Active
Hi Shawn
That task is not available.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.