Forum Discussion

AlexT's avatar
AlexT
Contributing User
4 years ago

-25 Invalid Amount When import Purchasing

I'm so over this program....    I have been trying to import a Purchase order and I keep on getting the -25 error amount.... I have rounded all the decimals to max 4., no empty cells. Even created ...
import
  • Mike_James's avatar
    Mike_James
    4 years ago

    Hi AlexT , the total column contains several amounts that have 3 decimal places, but only 2 are permitted in that field. You can have more decimals in the unit price column, 6 I think, which should help.

Tracey_H's avatar
Tracey_H
Former Staff

Hi AlexT 

 

Thanks for your post. That error is generally caused when the text file has been saved from Excel as Excel adds quotation marks to the import file. You can resolve this by changing the column format in Excel, saving the file and importing again.

 

To do this:

 

  1. identify the column with the quotation marks, in Excel select the entire column>>right click the column header>>select Format Cells
  2. in the Format Cells window>>Number tab>>select Number and click OK
  3. save the file. If you get a prompt that some features might be lost if you save it as Text select Yes
  4. if you open the import file in Notepad the quotation marks should have been removed

Please let me know if you need further help.

 

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

AlexT's avatar
AlexT
Contributing User
4 years ago

Hi Tracey

 

Thanks for your reply.

 

I couldn't find any quotation marks. I have attached the files; maybe you can see it ...but to me, the problem seems to be in the calculation that MYOB is trying to do... at least that is what the -25 error seems to say Invalid Amount...

 

Thanks again

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    4 years ago

    Hi AlexT , the total column contains several amounts that have 3 decimal places, but only 2 are permitted in that field. You can have more decimals in the unit price column, 6 I think, which should help.

    • AlexT's avatar
      AlexT
      Contributing User
      4 years ago

      Thanks so much Mike_James  that fixed the issue

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.