Import Error 25 Invalid Amount

Highlighted
Experienced Cover User
19 Posts
Experienced Cover User
Australia
Experienced Cover User

19Posts

4Kudos

0Solutions

Import Error 25 Invalid Amount

Import of Purchases failed with error message 25 Invalid Amount.

What does this mean.

Thank you

Sue

15 REPLIES 15
Highlighted
MYOB Moderator
2,334 Posts
MYOB Moderator
MYOB Moderator

2,334Posts

253Kudos

365Solutions

Re: Import Error 25 Invalid Amount

Hi @met 

 

This error normally occurs if there are special characters in the amount field of the import file. If yes, you will have to remove any such characters and then attempt to import again.

If it still fails, next step would be entering one purchase in the software and just exporting that to compare it to your import file. Also, try importing the exported sale back into to the software because if it get's imported fine, you can just adjust the import file according to that.

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

Highlighted
Ultimate Partner
4,622 Posts
Ultimate Partner
New Zealand
Ultimate Partner

4,622Posts

2,078Kudos

592Solutions

Re: Import Error 25 Invalid Amount

Hi @met , are you able to attach the import log and the source text file? I have exactly that problem just now, although another set of similar data imported perfectly last week.


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)

Highlighted
Ultimate Partner
4,622 Posts
Ultimate Partner
New Zealand
Ultimate Partner

4,622Posts

2,078Kudos

592Solutions

Re: Import Error 25 Invalid Amount

Hi @Komal_S , excuse me adding to this thread. I attach the source file for an item purchase import, and the log. 

 

The source file shows 8400 items at 1.16023 = 9745.93

But the log shows 8400 items at 1.1602, and the total amount does not appear. The transaction was rejected.

 

It looks like the import routine has created a rounding error by not recognising the unit cost to 5 decimal places, whereas 6 decimal places are available on manual input.

 

Can you explain that?


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)

Highlighted
Ultimate Partner
4,622 Posts
Ultimate Partner
New Zealand
Ultimate Partner

4,622Posts

2,078Kudos

592Solutions

Re: Import Error 25 Invalid Amount

PS.  If I change the total amount in Excel manually to 9745.68 (= 8400 * 1.1602) the transaction is accepted.


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)

Highlighted
2 Posts
User

2Posts

1Kudos

0Solutions

Re: Import Error 25 Invalid Amount

Hi Komal,

 

You mentioned testing via import of an exported file.

I've done just that with a test sample of 2x sales items.

One sale was imported successfully, the other was rejected for error -25.

I didn't touch the exported file after it was created - I immediately imported it straight back in.

 

Using AccountRight Plus AU 2020.2.2, Build 2020.2.23.9038

Both the export file and the import log attached.

 

Any light you could shed on why the second item failed would be very much appreciated!

Thanks for your help, either way!

Highlighted
Ultimate Partner
4,622 Posts
Ultimate Partner
New Zealand
Ultimate Partner

4,622Posts

2,078Kudos

592Solutions

Re: Import Error 25 Invalid Amount

Hi @dannybrix , the  second line doesn't round to exactly $900, it calculates as $900.01. ($990 * (100 - 9.09)/100)


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)

Highlighted
Experienced Cover User
19 Posts
Experienced Cover User
Australia
Experienced Cover User

19Posts

4Kudos

0Solutions

Re: Import Error 25 Invalid Amount

Copy of the file herewith

Highlighted
Ultimate Partner
4,622 Posts
Ultimate Partner
New Zealand
Ultimate Partner

4,622Posts

2,078Kudos

592Solutions

Re: Import Error 25 Invalid Amount

Hi @Komal_S , I understand from product management that this (rounding/truncation of unit prices) is now an accepted issue which is being investigated. 


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)

Highlighted
MYOB Moderator
2,334 Posts
MYOB Moderator
MYOB Moderator

2,334Posts

253Kudos

365Solutions

Re: Import Error 25 Invalid Amount

Hi @Mike_James 

 

You are correct in mentioning that the numbers with more than 4 decimal places are automatically getting rounded to 4 places during the import process, resulting in the total amount being incorrect. I  have checked with the product development and confirmed that the importer only works correctly with 4 decimal places and therefore discards any digits in the unit price if they are more than that. They are working on it to make it more flexible in the future updates, but at this stage, the import file would have to be corrected to only include prices upto 4 decimal places to avoid this error.


@dannybrix  The issue with your file is incorrect amount as explained by @Mike_James . Please correct the total, import the file again and let us know how you go on. 

 

@met  Please attach the sample import file instead of the error log so we can figure out if there is something wrong in the file itself. 

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

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post