How we can handle the difference between Costing inventory valuation and GL balance?
Is there any reconciliation procedure for user to handle the difference between Costing inventory valuation and GL balance?
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?