Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
January 2021
January 2021
Import Error message 25 Invalid amount and 27 A non-zero amount requires an account.
Could someone please assist to explain how to fix these. We have been getting these error messages when importing Purchases. The amounts appear to be correct with 2 decimal places and all line items have an account.
Thanks
Solved! Go to Solution.
January 2021
January 2021
Hi @met , does the field layout in your text file match the order of columns in a file of exported purchases? The order of fields can affect the result.
If you wish, post a sample import file and the log file here. (Note this is a public forum).
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...)
January 2021
January 2021
Hi Mike,
Not sure Mike, would it not then reject all the transactions. But in any case, attached is an extract from the last batch which had error code 25 and 27 listed.
Thanks
January 2021
January 2021
Hi @met , error -27 occurs where transaction lines have dollar values but no GL account. There are several examples in the extract. All lines that have dollar values require a GL account number.
The only error -25 I can see appears to be a blank line, possibly at the top of the text file. Maybe remove that, so that the first 3 lines of the file are:
{}
Header row
First transaction line
etc...
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...)
January 2021
January 2021
Thanks Mike, will check the GL Codes for -27
Just tried another batch and shows the error code 25 on this as well, see attached.
January 2021
January 2021
And yet another one with the same error cade - see attached.
February 2021
February 2021
Hi @met
Import Error -25 can be caused due to a variety of reasons, the most common being invalid characters like $ or " " around the amount field in the import file. Another reason could be the total amount calculation with respect to discount and GST amounts. If the amounts are not correct mathematically in the import file, you may get this error.
That said, if you could attach a sample of the actual import file here, we would be able to advise specifically on how the error can be resolved.
Kind regards,
Komal
MYOB Community Support
Online Help| Forum Search| my.MYOB| Download Page
Did my answer help?
Mark it as a SolutionHelpful? Leave a to tell others
February 2021
February 2021
Hi Komal,
Attached is one the those that have 25 listed.
Thanks
February 2021
February 2021
Hi @met , I recommend removing the blank line below the heading row.
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...)
February 2021
February 2021
Thanks Mike,
That worked. Were would the blank line come from so we can fix for all batches.