VI import to SO Invoice Entry problem version 4.50.5. Corrupts imported invoice if that invoice number exists in Invoice History.
The customer does route deliveries with handheld devices that assign the invoice number.
Then these invoices are imported to SO Invoice Entry with the invoice numbers from the handhelds.
Some of the invoice numbers are repeats for the customer, and exist in invoice history.
VI says it imports the invoice, but the invoice shows up as zero dollars on the total screen.
On the Header screen, the invoice date is the date from the invoice history record, not the import file, even though the job log shows the import files date.
On the Address Screen, the Bill To and Ship To data is all blank, even though the import says file assign by customer ID.
On the lines screen, the items show from the import file, with correct extensions. But the total screen says zero, so out of balance.
When you open the job log and drill down on one of the problem records, get message ""This invoice exists for this customer. Do you want to delete?""
I have not found a way to auto prompt ""No"" on the VI job.
Sage support says there is no perform logic they can find to address this problem.
They stated that on 4.3x there was an issue where even if you manually enter an invoice with same invoice number in history,
that MAS added the lines to the existing record in Invoice History. They weren't sure what the status was on 4.50
I manually added an invoice number to SO Invoice Entry that already existed for that customer in history, and it created a separate record.
Any ideas how to get VI to do what I want?
I already have ideas to work around it, but first I want it to find a way to get it to work as it did before they upgraded (V3.23 to V4.50).
Has anyone else encountered this issue with duplicate invoice numbers on VI?
Clark