How do I adjust inventory valuation for a certain item?

SOLVED

We have the module Bill of materials, we typically receive an order from a customer for an item (Program) that has to be built.  We create an invoice for that item (Program) and in a few days when we have enough orders to build the item (Program) it will create a BR and that is sent to our vendor.  Once we receive the built product then they are received into inventory.  This is what it has created.  We over distributed the Program by creating an Sales Order at an incorrect COG so on the GL it will understate the COG and overstate the Inventory asset.  I know how to correct the GL but not the inventory valuation because I am not adjusting quantity just the COG.  Any help would be greatly appreciated.

Parents
  • 0
    verified answer
    Are you saying that the inventory account in the GL does not match the inventory trial balance?
  • 0 in reply to BigLouie
    No the Trial Balance and the inventory account in the GL Balance, however I found the mistakes and they add up to over $5,000.00. We had several Program's that a sales order was created which carried forward the previous COG which was more expensive and it over distributed us. Then the BR was created at the correct COG, but is too late for the Sales order. The sales order Recorded the higher COG instead of the Correct COG.
Reply
  • 0 in reply to BigLouie
    No the Trial Balance and the inventory account in the GL Balance, however I found the mistakes and they add up to over $5,000.00. We had several Program's that a sales order was created which carried forward the previous COG which was more expensive and it over distributed us. Then the BR was created at the correct COG, but is too late for the Sales order. The sales order Recorded the higher COG instead of the Correct COG.
Children