Error Message when Importing Sales and Purchases

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

9Posts

0Kudos

1Solutions

Solved: Go to Solution

Error Message when Importing Sales and Purchases

At the suggestion of MYOB Support, i have started a new company file, imported everything in order until I get to Sales and Purchases. Errors to no end.

I tried opening in Excel but this becomes worse. I had four errors

Summary of errors
Error -11: Transactions dated before the beginning of your financial year may not be imported.
Error -25: Invalid amount.
Error -224: Billed quantity cannot exceed the Received quantity.
Error -225: Insufficient quantity at Location specified.
Error -241: Supplier not found. Purchase order not imported.

I think i fixed these, by finding the errors and changing.

The Cards are in there, I do not use Card Id so this is default *None.

I downloaded Notepad ++ on another suggestion, but came up with this error.

 

Summary of errors
Error 0: Unexpected import error - Item is null or not purchased item!

 

Our current file is way to big and we have been running on one machine for 4 days. I need to import these.

Not sure I should add my logs as they have company lists on them.

4 REPLIES 4
Highlighted
MYOB Moderator Neil_M
2,000 Posts
MYOB Moderator
Neil_M
MYOB Moderator

11642Posts

1357Kudos

1634Solutions

Re: Error Message when Importing Sales and Purchases

HI @CBS001

 

In terms of that error 0, that is a catchall error which can mean a whole number of different things. In this instance I would be looking at the item list within your file and ensuring that any items identified within the import log are indeed set to I Buy this item.

Regards,
Neil

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

Ultimate User gavin12345
2,000 Posts
Ultimate User
Australia
gavin12345
Ultimate User

2717Posts

2072Kudos

387Solutions

Re: Error Message when Importing Sales and Purchases

Hi @CBS001

 

The suggestion to start a new file is simple for MYOB staff to say - I really wish all their support staff would set aside a few days, get a real live client file (such as yours - not a sample clearwater file) and physically go through the exercise they suggest. Export and import - easy to say - as you have found very hard to do. Perhaps the support staff will then tell the developers to fix AR2018 to handle larger files rather than telling clients to start a new file.

 

And just to make things even harder, sometimes the error message incorrectly identifies the problem.

 

While it may be too late for you, thought I'd mention there is a service provider who can take you very large company file and purge all closed prior year transactions and return a much smaller and more manageable file. There is a fee (and it can be hundreds of dollars) but as you can see the alternative is not always easy. Send me a private message if interested in contact information.

 

Regards

Gavin

 

Contributing Cover User CBS001
7 Posts
Contributing Cover User
Australia
CBS001
Contributing Cover User

9Posts

0Kudos

1Solutions

Re: Error Message when Importing Sales and Purchases

Tech support have suggested to start again. There was a bunch of information they didn’t tell me I needed to do before importing. Will msg you gavin12345.
Contributing Cover User CBS001
7 Posts
Contributing Cover User
Australia
CBS001
Contributing Cover User

9Posts

0Kudos

1Solutions

Accepted Solution Solved

Re: Error Message when Importing Sales and Purchases

BIG THANKYOU to gavin12345

Your solution helped in a big way.

I didn't have to restart from scratch, s**bleep**ped the idea of importing exporting and with the help of your contact we resolved the issue.

MYOB found the extra fault in the file afterwards and corrected.

Anyone having same issues with slowness, large file, as I did, happy to pass on contact details.

Thanks

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