7.6.400.a Confirm Ship Amounts not balanced in IM Distributions

[NJAnalyst]

7.6.400a MSSQL

We are testing 7.6.400a and one of the issues we are testing is how Macola handles confirm shipping and rollbacks. We have found a situation where an order is processed, the items do not have enough qty in the bin, a rollback is forced, received qty into bin to allow for oe issue, reprocessed confirm ship, selected for billing, printed invoice, posted invoice.

The IM Trx History report with distributions shows
for Item 1
Debit Credit
Confirm Ship Inventory .00 126.60
Materials 126.60 .00
Confirm Ship Inventory 427.21 .00
Inventory-Finished Goods .00 427.21


Item 2
Debit Credit
Confirm Ship Inventory .00 427.21
Materials 427.21 .00


The distribution to GL shows a journal source code of OE9999 for item 1 and IP6781 for item 2.

It appears as if the distribution or the item trx history is mixing the two line items but it is causing an out of balance in the confirm ship account.

If anyone has seen this before, please let me know if you identified a root cause. Thank you.


Jonathan Nelson

 

[MacolaHelp]

Jonathan,

Did you find out if this is a bug? The source OE9999 is the confirm ship source. Because receipts, if returned to inventory, are done at the time of CM processing in OE, it apparently is doing this on confirm ship rollback because of how all the relevant files must be updated "simultaneously", but in fact occurs sequentially. It sounds like they changed something in the code where the distributions are not created during the confirm process if insufficient QOH, but the rollback/return distributions ARE created.