Hi,
We have noticed that some of our invoices numbers are being duplicated.
Most of our invoicing is done at the start of the month for the previous month, with a CSV file being imported into Solar. During the month adhoc invoices are created with solar giving the invoice number. We have noticed on several occassions that invoice numbers are being duplicated, but are unsure as to why.
We imported our invoice file at the start of the month for October invoicing, with all invoice numbers being issued. In the middle of the month we have created some adhoc invoices amd we have noticed that one of the invoices has been given an invoice number already issued.
Can you shed some light as to why this might be happening?
Regards
Rebecca Brown
Hi Rebecca,
I think the most likely explanation is that the invoice numbers you imported did not form a complete sequence starting from the 'next invoice number' in Solar Accounts. For example, say the next invoice number in Solar Accounts is 'INV6' and you import invoices with number INV6, INV7, INV9 and INV10. After the import the 'next invoice number' would be INV8, and so the default sequence for new invoices you create manually will be INV8, INV9, INV10...etc. which would result in duplicate INV9 and INV10.
To prevent this problem: After you import your invoices, click menu Setup > Generated IDs, and set the Next Number for the invoice row to be after the range of invoices you just imported.
Regards,
