MYOB Import Errors

[met]

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

[Mike_James]

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).

[met]

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

[Mike_James]

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...

[met]

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.

[met]

And yet another one with the same error cade - see attached.

[Komal_S]

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.

[met]

Hi Komal,

Attached is one the those that have 25 listed. 

Thanks

[Mike_James · Accepted solution]

Hi @met , I recommend removing the blank line below the heading row.

[met]

Thanks Mike,

That worked. Were would the blank line come from so we can fix for all batches.