Pricing Updates for Inventory Items

We are having trouble updating pricing.

We are updating in the Item Maintenance module, the Purchase Cost and Retail cost. These updated costs are not pulling into Purchase Orders and Sales Orders.

Any ideas?

  • 0

    That would be correct because neither process use those fields. In Sales Orders they really don't pull a cost until invoicing. If you have Lot, Serial or FIFO there is no way for the system to know what Lot number, Serial Number or FIFO tier you will use until invoicing. In Sales Order entry it does use the cost from the Inventory Master file but that might not match the cost uses.  In purchase order it uses the last cost from the vendor. All this is detailed in the Help files under hierarchy of cost.

    Note also that you should NOT be changing the cost of an item because it will through off inventory to the GL.  Just because the vendor may increase the cost of the item does not change the cost you paid for an item already in the system.

  • 0 in reply to BigLouie

    Thank you so much!