Forum Discussion
Hi Mazzii1,
Thank you so much for your post and welcome to the Community Forum! I am sorry to hear that you were having problems in importing your sales. I really appreciate your patience and understanding about this issue and thanks for the information. When importing into AccountRight Live, a Tab Delimited or Comma Separated CSV file, that has been saved from Microsoft Excel, can cause the import to skip the records, with the message: Error -25: Invalid amount.
To fix this, The quotation marks need to be removed before importing again. There are multiple ways to achieve this, ideally just change the column format in Microsoft Excel, and save the file and import again. Identify the column causing the issue, then in Excel select the entire column, then right click the column header, and select Format Cells.
You can also visit this post for more information: Importing sales error -25.
Please do let me know how you go on this.
Regards
Earl
- Mazzii12 years agoContributing User
Hi Earl_HD ,
Thank you and I have read through your previous suggestions and tried to apply your solution, even though I cannot see any quotation marks on the text file or the text file logs. But it still hasn't helped.
I'm exporting time billing sales, reconfiguring the csv to look like an Item Bill, saving as a text file and importing from there. I had one successful file but coulnd't do it again after that. I'm not sure why and I'm not understanding the issue from the import error log.
Thank you again.
Regards,
Mazzii
- Mazzii12 years agoContributing User
Hi again,
Finally uploaded an Item bill without errors however, none of the billed or received quantities uploaded. Why is this? The columns were named and matched to the item bill fields and the import log had no errors.
I don't know why this is so complicated. In Xero, we can copy a sale to a bill, but it wouldn't bring over the added information on each transaction line like date and docket number. Only the genric item desciption. But still, way less complicated than this. I came to MYOB thinking it was going to be easier, more efficient... it's been anything but that unfortunately.
I look forward to your reply.
Mazzii
- Earl_HD2 years agoMYOB Moderator
Hi Mazzii1,
Thank you for providing detailed information. Your patience and understanding regarding this issue are greatly appreciated, and I apologize for the delayed response. To resolve this, please edit the import file in a text editor program such as Notepad and remove the extra blank lines. Keep in mind that each transaction should still be separated by a single blank line in the import file.
If you encounter any difficulties during this process or have further questions, please feel free to reach out for assistance.
Best regards,
Earl- Mazzii12 years agoContributing User
Hi Earl_HD
Thanks for your response. I don't understand what you mean by extra blank lines? There are no blank lines between each transaction. But then in the next sentence, you say that each transaction line has to be seperated by a single blank line!? Very confusing.
I tried adding a single blank lines between each transaction and re-imported the file. What a mistake that was. Not only did it still not import the Billed or Received amounts, each line was imported into a seperate bill instead of the one bill!!
Why does everything else import except for the quantities entered in the Billed or Received columns?
Cheers,
Looking for something else?
Search the Community Forum for answers or find your topic and get the conversation started!
Find technical support and help for all MYOB products in our online help centre
Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.