Hi there,
Help please.
I need to adjust Inventory Balance.
we realized this problem too late. the problem came when moving data to another database. this policy (moving data) happen because changing of internal company's policy. they want to split of something.
anyway, here the case:
when we move the data, we didn't notice from old database. there were batches from IV transfer that have status "in transit".
those batches related to another batch on IV issue (batch is auto generated by OM module while made sales order). since the batch of IV transfer still on status "in transit", batch of IV issue not released (and worse, status is S).
I have found the records from batch of IV issue which not release.
those all affected beginning balance for new database.
now there are new transactions on new database. How to adjust the inventory balance so the balance can be matched between old database and new database, ending balance of old database match with beginning balance of new database?
thanks in advance
*This post is locked for comments