We previously maintain our sales price manually. Although we can leverage the sales price worksheet. But it is mainly manually.
Currently , we are short of staff. So we are seeking a way to see if this is possible. Like: After Purchase receipt/bill be released, the receipt item’s avg cost are changed. so accordingly, the sales price changed consequently as the cost changed.
Is this function out of box? Please advise.
Best answer by ray20
@markusray17 Thanks to Mark’s idea. Yes, I used business event to fulfill my need.
Although I am not triggerred at the exact time of the document releasing. The schedule is running on daily basis. It also does not require the exactly real-time.
My steps below: 1, using a GI to monitor the “INitemcost”, and the INitemcost.lastcostdate>= Today 2, Using the GI as a BE’s datasource 3, Subscribing a import scenario
4, Also can subscribe a email to notify the user price has been updated.
Hello, There is no ‘out of the box’ feature to update Prices on inventory items.
You might take advantage of Minimum Markup fields in stock items screen, Price/cost tab, to warn users when they sell an item, if the minimum markup % was not achieved by default price on an item.
You could use a customization to update price by certain % when cost increases.
Sales Price Worksheets don’t need to be manual. Look for the features to copy in groups of items to worksheet, and increase their pricing automatically by %, for example:
Worksheets can also be imported from Excel or using Import Scenarios for mass update.
You could potentially do it using business events and an import scenario if you wanted to avoid customization. The business event would trigger when a bill/receipt is released and trigger an import scenario that would update the prices.
@markusray17 That is strange. People don’t care about the price and cost relationship? Maybe, a lot of users determine the price only according to the Market price, not according to the actually cost😂
@markusray17 Thanks to Mark’s idea. Yes, I used business event to fulfill my need.
Although I am not triggerred at the exact time of the document releasing. The schedule is running on daily basis. It also does not require the exactly real-time.
My steps below: 1, using a GI to monitor the “INitemcost”, and the INitemcost.lastcostdate>= Today 2, Using the GI as a BE’s datasource 3, Subscribing a import scenario
4, Also can subscribe a email to notify the user price has been updated.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.