Skip to main content

We received some special pricing for an inventory item that we also carry some stock on hand.  The special pricing is for a certain project and it’s a onetime deal at a much lower cost level.  I had assumed that by using mark-for-po functionality on the Sales Order line, it would carry the cost layer to the PO receipt and ultimately through the Sales Order and not affect Avg Cost once inventory is shipped/invoiced.  After testing, I was wrong.  It looks like the Acumatica is using FIFO for managing cost layers, regardless if some of it was mark-for-po and linked.  This is now impacting our current inventory on-hand by updating its cost even though the lot of inventory that was received has been physically sold already. Does anyone know of a way overcome this without changing it to drop-ship?  I’m trying to protect the current costs on the inventory that is on-hand since this is a special situation for lower pricing.  Thanks

Hi @skuhnert 

Please try using the valuation method "Specific". This method requires a Lot/Serial number for each purchase or sale of inventory.

 

Best Regards,

NNT


If you’re using average costing, the inventory cost will be blended in.  FIFO valuation method uses cost layers and many have adopted this method when they need to segregate inventory costs for particular inventory items.


Hi @skuhnert 

 

I agree with @nhatnghetinh 

We had an issue similar, and i can confirm going to a specific cost, tracks the Inventory Cost from PO to invoice.

Although, be careful if this product is in a BOM, this could consume the stock.

 

Aleks


Reply