Inventory valuation does not match to GL

Issue No: IC-7901
Created 10/1/2019 1:35:06 PM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 19.1
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!