The invoice sync error'd as it is a potential duplicate invoice. The invoice number and vendor coding already exists in Sage 100 and is posted.

Error in tool


You should confirm that the invoice is in fact a duplicate invoice. If you find the invoice in Sage 100 is the same invoice, you can simply Mark the Invoice as Exported in Beanworks. Since the data is already in Sage 100, you don't need to export it again.

It's possible that the invoice is actually a different invoice, this sometimes happens with vendors that are poor at using unique invoice numbers.
In this scenario you should Reset the invoice in Beanworks and amend the invoice number to something unique. Once you export and sync the invoice again the invoice will populate in Sage 100 as it no longer views it as a duplicate.

A little advise:
If you have a few worst offender vendors when it comes to unique invoice numbering or a vendor that doesn't provide an invoice number at all. Make a practice of changing the invoice number in the coding phase.
For example: I've a vendor that doesn't send me an invoice number but rather a customer number which is the same on every invoice I receive from them. I could use the customer number plus the date when coding the invoice number to make it unique i.e. customer number: 200392 becomes invoice number: 200392-MMYY. This way you'll cut down on the amount of possible sync errors you'll receive.

It's important if you introduce this policy that you're entire coding team are following the same process. If not strictly followed a real duplicate could slip through.

Did this answer your question?