Description |
Steps:
Note: As a whole, the GL entries for Inventory Category and Inventory Valuation should balance by 360.68 (difference in our beginning balance to GL as of 7/31/2019).
However, when you look at the individual products compared to GL totals, they do not balance.
Ex:
Look at Item code 4101B for location 276. The Inventory Valuation as of 8/31/2019 shows running balance of $0.
Issue:
However, when you look at the GL Account 1401-0276 which is the GL account used for 4101B, it is showing negative $286K.
This has to do with blends and costing of auto blend, $0 receipt etc.
Acceptance:
We need to fix the balance so that GL entries match the inventory valuation per product/category. You may need to rebuild again.
!pastedImage_d124876_0.png|height=449,width=681!
!pastedImage_d124876_1.png|height=533,width=731!
Example 4101B location 276
!pastedImage_d124876_2.png|height=292,width=733!
GL balance for this product shows ($288,639.32), should be $0
!pastedImage_d124876_3.png|height=596,width=1029!
|