Skip to main content
Solved

Inventory Costing for mark-for-po demand

  • 4 September 2024
  • 3 replies
  • 48 views

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

Best answer by nhatnghetinh

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

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

3 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+7
  • Captain II
  • 340 replies
  • Answer
  • September 5, 2024

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


Dana Moffat
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Moderator
  • 549 replies
  • September 9, 2024

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.


Forum|alt.badge.img+7
  • Captain II
  • 288 replies
  • September 10, 2024

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


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