Dave Winn
|
We have the same problem. We correct the problem (per Lynn's assistance) with Maintain Database and resetting the next invoice # in SD-M. We have had it for over 2 years. It has happened much more frequently in the past month. I have a copy of the entire company files as zip files for each occurance for Lynn if it will help analyze the problem. I also have photocopies of the invoices which were duplicated. The symtoms are always the same for us. Sales orders with multiple duplicate lines inconsistently generate duplicate invoice #'s It picks up the invoice # of the last release of a similar line item on the same sales order. For example, if we are going to make 5 shipments of 15,000 'widgits', there are 5 lines (and associated comment lines below each) of 15,000. We release the 1st line, invoice, and post. Next week we do the same against the 2nd line. The point being that we don't do multiple releases against a line item, we release an entire line which is identical (on the sales order) to the others. Lynn, let me know if you would like the zip files to analyze to help everyone with this VERY annoying problem.
|