[miah28]

MOM 5.4 seems to have duplicated an invoice letter and screwed up our accounting departments reports. Has anyone had any experience with this kind of problem?

The facts as I understand are this...
* An order was created and processed.
* The order had some items added to it after the initial process and possibly were shipped ahead due to a back order status.
* A transaction ID was correctly assigned to each process on each step.
* Instead of adding a NEW invoice for the sub transactions MOM duplicated invoices C and instead of creating a new invoice D and later created a an invoice D for another transaction. so the report shows this

Transaction ID Invoice Amount
111**** "A" $15189.78
111**** "B" $28290.50
112**** "C" $3674.85
112**** "C" $256.75
112**** "D" $1497.98

* The first assignment of invoice C is NOT showing up on the sales listing reports or the accounts receivable aging report and the financials are NOT showing that this customer doesn’t owe the $3674.85.

So the question is 2 fold. 1. Has anyone ever seen MOM duplicate invoice numbers and if is there any way to fix this? and 2. If no one has seen the duplicates before does anyone have any ideas on how to correct this for this order itself?

Here is what I have done so far.
I have re-indexed all files.
I have deleted the .cdx files and let MOM rebuild them.

Thanks for any help in this matter.


Jeremiah Davis

[planetdj]

miah28, on Oct 15 2008, 07:59 AM, said:

MOM 5.4 seems to have duplicated an invoice letter and screwed up our accounting departments reports. Has anyone had any experience with this kind of problem?

The facts as I understand are this...
* An order was created and processed.
* The order had some items added to it after the initial process and possibly were shipped ahead due to a back order status.
* A transaction ID was correctly assigned to each process on each step.
* Instead of adding a NEW invoice for the sub transactions MOM duplicated invoices C and instead of creating a new invoice D and later created a an invoice D for another transaction. so the report shows this

Transaction ID Invoice Amount
111**** "A" $15189.78
111**** "B" $28290.50
112**** "C" $3674.85
112**** "C" $256.75
112**** "D" $1497.98

* The first assignment of invoice C is NOT showing up on the sales listing reports or the accounts receivable aging report and the financials are NOT showing that this customer doesn’t owe the $3674.85.

So the question is 2 fold. 1. Has anyone ever seen MOM duplicate invoice numbers and if is there any way to fix this? and 2. If no one has seen the duplicates before does anyone have any ideas on how to correct this for this order itself?

Here is what I have done so far.
I have re-indexed all files.
I have deleted the .cdx files and let MOM rebuild them.

Thanks for any help in this matter.


Jeremiah Davis

Well, I would try this on a backup copy of MOM to see what results you get: Using DBUWIN, change A,B,C,C,D to A,B,C,D,E

Be careful!