Hello Experts
Until now (2025R2) or before, is there a way to set the sales Price for FIFO item based on its layer cost. Like for item A, we are having 3 cost layers on hand. Like $10,$11, $9. Can we set fixed markup like $3. When the $10 stocks are sold out, the system will change the price from (10+3) to (9+3)?
Best answer by jhalling52
Hi
You could potentially build a Business Event to update the Sales Price. The GI would be built off the INCostStatus table and filter only results with cost greater than zero and only show the oldest cost layer.
When the oldest cost layer moves to zero, the next oldest Cost Layer will populate on the GI, triggering the import to update the Sales Price based on the fixed margin.
Hi
Acumatica Sales price is controlled by below attributes:
Price Classes
Customer Price Classes
Sales Price Worksheets
Base Price / Promotional Price
Cost-based pricing (but only from a single cost field, not FIFO layer)
For your exact requirement, you need customization.
Hi
You could potentially build a Business Event to update the Sales Price. The GI would be built off the INCostStatus table and filter only results with cost greater than zero and only show the oldest cost layer.
When the oldest cost layer moves to zero, the next oldest Cost Layer will populate on the GI, triggering the import to update the Sales Price based on the fixed margin.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
