Importing sales item data error -90

Question

Hi there, I have followed your instructions to export data (Sales - Items) to a .txt template and have then edited the date only, saved as .txt and attempted to import and get the following error message:

0 records imported without errors.
1 records skipped.
0 records imported with warnings.

Error -90: Ex-Tax Amount and Inc-Tax Amount are invalid or blank.

Any suggestions?

mike_james · Accepted Answer

Hi&nbsp;JessArmstrong&nbsp;, welcome to the forum. Are you able to attach the file you are importing (provided the content is not sensitive), and the log file?&nbsp;Does the text file being imported have {} on line 1, no blank line between the header line and the first invoice, and no blank lines at the end?

mike_james · Answer

Hi&nbsp;JessArmstrong&nbsp;, the first two lines of your text file need to be prepared as follows:&nbsp;{}Co./Last Name First Name Invoice # Date Customer PO Item Number Quantity Description Inc-Tax Price&nbsp;Then your invoice lines as they are, but I think you'll need to add columns for :ex-tax pricenet line totalinc tax line totaltax codetax amount

mike_james · Answer

Hi JessArmstrong&nbsp;, looks like an import into v19. Please remove the braces (delete the line), and try again.&nbsp;Braces tell MYOB the import file is formatted for Accountright Live.&nbsp;

jessarmstrong · Answer

Success, thank you!&nbsp; Had to also remove invoice number as this duplicated.&nbsp;&nbsp;

jessarmstrong · Answer

Hi, that advice seems to have fixed my first error but now I have an error message saying it cannot find the customer. Files are attached. I have altered the customer name for senstitivity purposes but had imported this file having only changed the date, deleting additional rows and inserting the {} as recommended. I would have expected this to create a draft invoice as I have only exported a sample of fields from the Sales - Item template to modify. Is this the correct process?

Thanks,

Jessica.

MYOB Sales Test Template v6.TXT1 KB

MYOBPLOG.TXT1 KB

jessarmstrong · Answer

Tried a few other attempts, importing&nbsp;the following fields having first exported, changing the date only, then reimporting, (note net line total and incl tax line total not available).&nbsp; Got the same error code 190 - customer not found.&nbsp; Any other ideas?&nbsp;Co./Last Name,First Name,Invoice #,Date,Customer PO,Item Number,Quantity,Description,Price,Inc-Tax Price,Total,Inc-Tax Total,Tax Code,Non-GST Amount,GST Amount,Card ID{}

Forum Discussion

Importing sales item data error -90

8 Replies

Related content

Importing sales error -25

Importing Error 4077

Import timesheet error

AccountRight Import Error

Error 4077 - Import / Export

Import Item Error

Importing Sales

Importing data error 4077