Question

Price maintenance on FIFO negotiated item.

  • 14 April 2022
  • 5 replies
  • 47 views

Userlevel 5
Badge +4

Hello,

       We are having some negotiated items with customer, which we markup fixed amount based on cost.
Like Item A,  FIFO, fixed markup amount $ 5 per case

       First Purchase,   $20 per case, then we sell $25 per case
       second purchase, $30 per case , then we sell $35 per case.

Supposing we are having 100 cases $20 item A and 400 cases $30 cases item A.

The perfect solution we are seeking for:  is it possible that,  after the 100 cases of $20 be sold out, then the sales price automatically jump up to $35.

If this is not possible right now. Is there a way that can automatically reminder the human that the 100 cases of old inventory be sold out, you have to update the price.

Please advise. Thank you.


5 replies

Userlevel 6
Badge +4

Yes, try Minimum Markup % on the Stock Items screen, Price/Cost tab, to remind the humans. 😉

 

 

Userlevel 5
Badge +4

Yes, try Minimum Markup % on the Stock Items screen, Price/Cost tab, to remind the humans. 😉

 

 

Thank you for your reply, however
1, this minimum markup is by percentage not by amount
2, MOST OF ALL,  minimum check on SOLine is based on AVG cost, not based on cost layer.

Userlevel 7
Badge +8

Hi @ray20 

I don't seen an out of the box option that enables setting the price per purchase or per quantity. To remind the user probably one can setup a business event based notification to the user. Set a business event to trigger based on a GI. You need to create a GI to pull the sales quantity for required item and date range. 

You may post feature request with the pricing requirement mentioned as well (https://community.acumatica.com/ideas)

Regards,

Userlevel 5
Badge +4

@vkumar 
Hello, Thank you for your confrimation from the official aspect.
I was thinking of GI before, however,
Please refer to below

 

1, Business events do not support generic inquiries that have grouping specified on the Grouping tab. I did like to group to sales qty, but it is not working.
2, I also tried INItemsaleshis_FinYtdQTYSales , it is not working.

I did not try “dirty hacks” method suggested by Irina.  I prefer the less codes, the better. I prefer just use what Acumatica existed tools (GI, BE) can provide, with no customization codes.

Userlevel 5
Badge +4

Any new ideas?

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved