Sage 100

v5.1 Premium. User has three invoices from 11/3 and three credit memos from 11/11 and the three credit memos have the same invoice number as the three invoices. The credit memos do not relate/applied to the invoices. The credit memos are applied to different invoices. Other than someone randomly choosing an invoice number to re-use, how can this happen? Secondly, where is the setting to not allow the re-use of SO invoice numbers? Don't laugh, it is Friday.

Maybe using the ""Match Credits to open Invoices"" in period end? I think you can uyse that to apply credits to invoices based on dates or invoice numbers.

The credit memos are already applied to invoices. There are 3 invoices: invoices 0295898, 0295877 and 0295901? In both cases there are two invoices under the same number - an invoice posted 11/3 and a credit posted 11/11 (actually 6 invoices: 3 standard invoices and 3 credit memos). Three standard invoices numbered 0295898, 0295877 and 0295901, and three credit memo invoices numbered invoices 0295898, 0295877 and 0295901. The credit memos don't even relate to the first set of 3 standard invoices. The credit memo are applied to other invoices. The issue is: How can these credit memos get the same invoice number when the invoice number was already used?

if I can find the option to not allow the re-use of SO invoice numbers that would prevent having the same invoice number in history more than once.

In SO, you can use the same invoice number for a customer as long as the invoice 'type' is different (IN, CM, DM). Other than that, you should not be able to use the same invoice number for the same customer. In AR you can, but it will show as an Adjustment.

That's the issue Bill. There should be an option to prevent using the same invoice number twice no matter what the type. Sales Order has this option. It seems to me it would be much more important to have this in SO Invoice instead of SO Entry if you had to pick one or the other.

As long as I am complaining, once the SO Invoice is updated you can't determine who created the original invoice. You can see who updated the sales journal but once the sales journal is updated the creator of the invoice seems to be lost (unless I am missing something).

Found this in Evernote..search - how to add a linked table to ALE lookup - might help you for who created invoice