Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
May 2021
May 2021
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?
Solved! Go to Solution.
May 2021
May 2021
Hi @JessArmstrong , welcome to the forum. Are you able to attach the file you are importing (provided the content is not sensitive), and the log file?
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?
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
May 2021
May 2021
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.
May 2021
May 2021
Hi @JessArmstrong , the first two lines of your text file need to be prepared as follows:
{}
Co./Last Name First Name Invoice # Date Customer PO Item Number Quantity Description Inc-Tax Price
Then your invoice lines as they are, but I think you'll need to add columns for :
ex-tax price
net line total
inc tax line total
tax code
tax amount
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
May 2021
May 2021
Tried a few other attempts, importing the following fields having first exported, changing the date only, then reimporting, (note net line total and incl tax line total not available). Got the same error code 190 - customer not found. Any other ideas?
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
{}
May 2021
May 2021
Hi @JessArmstrong , the Braces should be on line 1, above the column headings.
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
May 2021
May 2021
I tried that after re-reading your response. MYOB then doesn't recognising the column headings to match, refer enclosed. Note, I have altered the customer name for privacy purposes. I think the {} have to come between the header and first line of data - is that correct?
May 2021
May 2021
Hi @JessArmstrong , looks like an import into v19. Please remove the braces (delete the line), and try again.
Braces tell MYOB the import file is formatted for Accountright Live.
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
May 2021
May 2021
Success, thank you! Had to also remove invoice number as this duplicated.