How we can handle the difference between Costing inventory valuation and GL balance?
Summary:
Is there any reconciliation procedure for user to handle the difference between Costing inventory valuation and GL balance?
Content (required):
When we create foreign PO to source the materials, it order by one consolidate PO, like below accounting entry.
Then, the Inventory Valuation Dr total 345035.59+ 44010.4 = 389045.99
After that, we create sales order for the item with 2 different shipment, the shipment accounting entry like below:
Then, the Inventory Valuation Cr total 172517.8+22005.2+172517.8+22005.2 = 389046.00
Of course, the Inventory Valuation will become 0 in subledger costing but how we can handle the (389045.99 vs 389046.00) 0.01 different in GL balance? Is there any reconciliation procedure? Any adjustment can be done by system automatically?