Period End is not the answer because the problem is happening in OrderEntry, not Receivables.

As for the suggestion about using new customer numbers each month, it would require a programming change to the export utility from the website. Also, it would make it much harder to look up historical invoices.

The problem with trying to assign each customer a unique code is that this website is a retail website and it doesn't validate the customer information. So you would end up with repeat customers appearing multiple times in the database if you tried to match on email addresses or phone numbers. Or if you tried to match on the address, you would end up with multiple customers in the same apartment building being lumped together as one. You would be amazed at how "creative" web customers are in filling out the email/phone and even name fields (think "Superman")!

In addition to taking orders on their website, this client also has a separate entity that sells via Amazon, and since Amazon handles all of their order processing, they import those orders as invoices into Adagio Invoices. For that entity, they do set up a separate customer in the format "WByymm" for each two-week payment period, so that the amount Amazon remits exactly matches the balance due to my client (and the customers are set up as Balance Forward to make it easy to apply payments).

Getting Adagio to work for companies that do business via Amazon, including tracking inventory quantities, is a challenge I've taken on. If anyone wants to learn how this client does it, email me at steve@sschwartzcpa.com.

Steve