Skip to main content
Solved

Automatically update Sales Price after receipt or bill releasing


Forum|alt.badge.img+5
  • Captain II
  • 398 replies

Hello,

        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.
 

 

View original
Did this topic help you find an answer to your question?

8 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • April 14, 2022

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.

 

 


Forum|alt.badge.img+5
  • Author
  • Captain II
  • 398 replies
  • April 14, 2022

Thank you, we are using worksheet, but it still require human interaction.

What the management want most is to system automatically update prices.  NO Human involved.


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • April 14, 2022

It seems to me  like you will need a customization. Maybe someone else will come along and post more ideas for you.  Good luck.


Forum|alt.badge.img+5
  • Jr Varsity II
  • 237 replies
  • April 14, 2022

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. 


Forum|alt.badge.img+5
  • Author
  • Captain II
  • 398 replies
  • April 15, 2022

@markusray17 @laura01 
Thank you both.  so as far as you know, even the latest Acumatica version does NOT provide this feature out of box?


Forum|alt.badge.img+5
  • Jr Varsity II
  • 237 replies
  • April 15, 2022

It is not unfortunately, there are a few cost+ suggestions in the ideas forum but I don't think any of them really gained enough traction.


Forum|alt.badge.img+5
  • Author
  • Captain II
  • 398 replies
  • April 15, 2022

@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😂


Forum|alt.badge.img+5
  • Author
  • Captain II
  • 398 replies
  • Answer
  • April 15, 2022

@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.
 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings