Importing sales, invoice numbers not importing

Question

Our invoices, including the invoice numbers, are generated by an external program and we then import them at the end of each day. Occasionally we need to manually enter the odd invoice with a completely different invoice number, and we are having an issue where MYOB is creating its own sequential invoice numbers for the imported invoices, based on the invoice number of that manually entered invoice, rather than importing the invoice numbers on the import file. How can we address this? We need the invoice numbers that are on the import file to come through rather than MYOB creating its own.&nbsp;

mike_james · Answer

Hi&nbsp;Kirra27&nbsp;, do you manually import a text file of invoices generated from another system, or does the other system post them for you via the API?&nbsp;If you are manually importing them, are you including the invoice number in the list of matched fields, or not. If not, then MYOB would assign numbers based on the last manual invoice entry.&nbsp;

kirra27 · Answer

Hi Mike,&nbsp;Thank you for the reply. We are manually importing, and we auto-match the fields. I've double checked that the invoice number is matching correctly.&nbsp;&nbsp;ThanksKirra

mike_james · Answer

Hi&nbsp;Kirra27&nbsp;, so if you open the text file on a day where the invoice numbers were incorrect, do the numbers in that file match what was imported?&nbsp;If they do, then it seems likely to me that the external system picks up the last used invoice number from MYOB before creating the file. So if an invoice is added manually during the day, that is the number picked up, and is used to number the invoices being sent to the txt file.&nbsp;If all my suppositions are correct, then there's probably nothing you can do about it. Unless you manually provide the last used invoice number to the external system?

kirra27 · Answer

Hi Mike,&nbsp;No the invoice numbers on the text file are different to what was imported.&nbsp;The external system operates completely independently of MYOB except for the text file that we import.&nbsp;&nbsp;ThanksKirra

mike_james · Answer

Hi&nbsp;Kirra27&nbsp;, are the invoice numbers in the text file valid numbers to MYOB, ie 8 characters alpha-numeric? (I know you can input longer numbers manually, but the import is limited to 8 characters.

Forum Discussion

Importing sales, invoice numbers not importing

Looking for something else?

Related content

Importing Invoices

Importing invoices - urgent

4077 Import Error

Importing sales Invoices

Importing failing

Importing bank statements

Import

Importing initial stock take