Handling mutiple selling prices for one product

@mithray80 , FIFO will automatically allocate stock based on when it was received. The COGS will be recognized accordingly: first 5 books at $100 and 3 more books at $120.

With Average costing method, you don’t have specific cost layers ($100 vs. $120) - rather, Acumatica calculates the average based on the cost and quantity.

With Standard costing method, you tell Acumatica what is the cost of your goods, regardless of what you pay for them.

Finally, Specific costing will allow you to assign specific item numbers or lot numbers to an order, and thus will dictate the cost, so with Specific you have an option to choose if you want to allocate 5 X 100 and 3 X 120 or 4 X100 and 4 X120, or any other available combination.

Hope this helps.