Inventory Variance and Discrepancy between Balance sheet GL account and Summary

Hi all, I have a question regarding inventory variance that appeared after correcting inventory location in a purchase invoice. Instead to take out an inventory item from one location and put in to other the system created a huge inventory variance entries. I tried to cancel transaction putting the inventory back to the previous location but it did not help. As a result, we have an item code with positive quantity and negative value. There is a discrepancy between balance sheet GL account and sub ledger (inventory summary) numbers because of this. COGS also affected. Balance sheet GL account was increased and logically to fix it we should reduce inventory, but from other hand my inventory item is negative and I should add value... This does not make any sense. Did somebody had this problem and can advise how to fix it?

  • 0

    Article 72053 and 10473

    If you allow inventory sell below zero, and the buy back cost is different than original selling cost, that create the variance.

    you can try use 10276 to increase item value, but I would try to avoid use that item record as cost is gone wrong already and just a new record .

  • 0 in reply to Jason.

    Thank you for your reply! We never allow inventory to go below zero and before this transaction all quantities and values were real and positive. We have this item in 2 locations but the average cost is different in these locations. Changing the location gave me this difference. May be it is because the adjustment was made in the invoice dated November, but there were no new purchases of this item, only transfers between locations. Cannot imagine why this happened...

  • 0 in reply to Lana19

    You can check Reports>inventory & services > transactions report, pick detail and enable everything, start from earliest date to finish on latest date; this report should get you some idea

    Pay attention to "Date" ,Qty In and Qty Out Balance, location, Journal number columns