Inventory and GL are different after closing inventory

hungt

Hi AX Experts,

Please tell me why Inventory value and GL value are different after running
inventory closing. I use the "Inventory value by item dimension" report
(Inventory Management/Reports/Status/Inventory value) and COA form to verify
figures before and after the closing.

The settings are below:
•Inventory model: Weighted average date
•Minimum average quantity on Inventory parameter form: 0.1
•Close inventory form parameters:
oUpdate productions: Yes
oUpdate ledger: Yes
oMax throughputs: 1000
oMin throughput adjustment: 500
oMin settle quantity percent: 10
oMin settle amount: 500
oRun recalculation after closing: No

I specified “Minimum throughput adjustment” and “Minimum settle amount” to
500 because the currency is VND. The exchange rate is US $1 = 16,000 VND. So
500 is the most relevant value, I think.

Below is the detailed difference between inventory and general ledger
•Before closing
Inventory value for item group SF: 32,442,460
Account 154 accompanying SF: 32,442,460
•After closing
Inventory value for item group SF: 32,576,549
Account 154 accompanying SF: 31,972,532
==> 604,017 VND difference after closing

I found out the inventory adjustments for item group "SF" which do not have
accompanying GL adjustments. The sum of adjustment amount does match the
difference amount of both ledgers. I realized those adjustments have settled
quantity "0". Also they are all come from Production module. That's all about
my findings! I cannot explain this situation to client and it is also an
unacceptable situation.

Please guide me how to avoid the differences causes by inventory closing.
All your opinions on this problem are welcome and highly appreciated.

Best regards,

Hung Phan