Importing sales error -25

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Camelkathy
Contributing Cover User
5 Posts
Contributing Cover User
Australia
Contributing Cover User

5Posts

2Kudos

0Solutions

Solved: Go to Solution

Importing sales error -25

Hi there

 

I've been doing the following over the last couple of years and it always worked. Now it doesn't, can anyone help me?

 

Sales, Service item, Matching fields and importing.  error -25 is now happening.  I've attached a sample of what I'm uploading, creating a txt doc and I've attached the error.

 

cheers

 

 

7 REPLIES 7
gavin12345
Ultimate User
4,991 Posts
Ultimate User
Australia
Ultimate User

4,991Posts

1,002Kudos

633Solutions

Re: Importing sales error -25

Hi @Camelkathy 

 

I can't see how this would have worked in the past - what version of MYOB were you using in the past, and what version are you using now? If you have recently upgraded from v19 to AR2022 you should be aware that the import process is in most cases different, you will need to modify the imports to suit AR2022.

 

The 5th column of your import file is headed Inc-Tax Amount and yet the value is N-T. N-T is a tax code. Try showing the Inc-Tax Amount same as the Amount if there is no tax. I would also suggest you remove the lines where there is no amount.

 

Regards

Gavin

(gavinw222@gmail.com)
Camelkathy
Contributing Cover User
5 Posts
Contributing Cover User
Australia
Contributing Cover User

5Posts

2Kudos

0Solutions

Re: Importing sales error -25

Thanks, I've checked and I'm using AR2022.

 

I can't find any updated information.  I think the 5th column still needs to be N-T as it is required as no GST is on these amounts.

 

I've gone to chat bot and have had no success.

 

Still trying different things.

 

 

Camelkathy
Contributing Cover User
5 Posts
Contributing Cover User
Australia
Contributing Cover User

5Posts

2Kudos

0Solutions

Re: Importing sales error -25

I'm using AR2022.11  

 

When I search on latest information on importing, it says up to AR19.  

 

Is there any later information available for importing sales data.

 

cheers

 

 

error.JPG
Camelkathy
Contributing Cover User
5 Posts
Contributing Cover User
Australia
Contributing Cover User

5Posts

2Kudos

0Solutions

Re: Importing sales error -25

Can someone from MYOB please come back to me as I still can't upload.

 

cheers

Mike_James
Ultimate Partner
5,850 Posts
Ultimate Partner
New Zealand
Ultimate Partner

5,850Posts

1,079Kudos

756Solutions

Re: Importing sales error -25

Hi @Camelkathy , in addition to Gavin's comments, I wonder if the lines with "-" for the amount are causing this problem? Can you replace with 0.00 or remove the lines?

 

 


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

CloverQ
9,085 Posts
Former Staff
Australia
Former Staff

9,085Posts

0Kudos

1,386Solutions

Accepted Solution Solved

Re: Importing sales error -25

Hi @Camelkathy 

 

Thank you for providing the sample import file, it's very helpful.

 

I'm glad to see our very knowledgeable experts @gavin12345 and @Mike_James has offered to help, they've offered very valid points:

 

- v20xx use different import format compare to v19.x. An import file for v20xx should start with {} in the first line, which looks like this:

image.png

 

- The column with header 'Inc-Tax Amount' is expecting tax inclusive amount, not the tax codes. Tax codes should be entered in a different column.

- In the 'Amount' column the software is expect numeric value, please replace - with 0.00 instead. 

 

The Invalid Amount error can also refer to the software is finding the numbers in the transaction doesn't add up, e.g. the Tax-exclusive amount + tax amount doesn't equal to the Inc-Tax amount. AccountRight v20xx does more checks during import than v19.x to prevent unbalanced transactions to be imported.

 

I'd suggest recording one of the transactions in AccountRight manually, then export it with all available fields ticked. Open the export file in Excel to view the format and how data are presented, then use it as a template. For more details please follow this Help page: Using an import template.

Kind regards,
Clover

MYOB Community Support

Online Help| Forum Search|Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Camelkathy
Contributing Cover User
5 Posts
Contributing Cover User
Australia
Contributing Cover User

5Posts

2Kudos

0Solutions

Re: Importing sales error -25

Thanks so much.  It now worked.

 

{ }   was the final thing that I needed.

 

cheers

 

Kathy

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