Hello all,
We encountered the issue with Project Management & Accounting , where both parameters : Create Item requirement & Item consumption are turned on.
When creating PO from Project , system automatically creates SO (type Item requirement). And usual scenario is that they are both synchronized. Whatever you do on PO, it's automatically updated on SO.
And inventory transactions were always zeroed out (+1, -1).
While checking Inventory, we noticed a lot of minus quantities on available balances. Than when analyzing how that happened, we found out 2 cases :
> 1st case :
There are a lot of SO item requirement lines on Inventory transactions, status On order, for which is not possible to determine how were they created ( for Example PO would have one line with qty 10 , second line with qty 20, but SO automatically created from that PO would have one line with qty 10 , second line with qty 20 and than 2 additional lines with again qty 10 and 20; those additional lines have Lot ID which is greyed out, and has no link to PO number like first 2 lines)
> 2nd case :
There are a lot of SO item requirement lines on Inventory transactions, status On Order , for which is possible to determine how were they created ( you can easily link them to corresponding PO), but the case is that PO lines transactions are missing on Inventory transactions, and that's why balance is not correct. (Also by checking that PO, Lot ID is there, but greyed out)
Did anyone ever experienced that while using Item requirements & Item consumption, that Purchase order & Sales order (automatically created from that PO) lines and quantities are not synchronized, causing huge discrepancies on Inventory transaction balances ?
And if yes, do you maybe know the cause?
Thank you in advance, I really appreciate it.
