Forum Discussion

hes_bruce's avatar
hes_bruce
Contributing Cover User
6 years ago

Sales import Help with Error-25 please

Hi there,   Can someone have a look at why I am getting this error? We have just migrated over to Accountright 2019.2.22.5066 from Premier. Any help would be appreciated.
  • CloverQ's avatar
    CloverQ
    6 years ago

    Hi hes_bruce 

     

    Thank you for import file, log and the additional information.

     

    -25 Invalid Amount error generally means somewhere within the transaction the figures don't add up. From your import file, I can see that this sales transaction is Tax Exclusive. So as calculation goes:

     

    - Total column should equal to Quantity x Price

    - GST column should equal to 10% of Total

    - The sum of the GST column should equal 10% of sum of the Total column.

     

    You can open this file in Excel, add a temporary column A, set formula to quantity x price, then create another column to be 10% of column A. Then compare the figures in the temporary columns to the existing columns 'Total' and 'GST'. E.g. line 44 in the import file has quantity 100, unit price 0.11, but the Total is 10.54 instead of 11. You can also run the sum of these columns and see if they match. 

     

    Please do go through the figures in the import file, fix any mis-calculation then try importing it again.

hes_bruce's avatar
hes_bruce
Contributing Cover User

Hi Maxine_BC,

 

In this instance, I am exporting 5 seperate invoices from MYOB, "Tidying them up" & then importing as one consolidated order as per our customers wishes. It used to work well with Premier.

By tidying up I generally:

  • remove gaps between invoices
  • make the date the same
  • remove comma's from quantities
  • create new order number

I appreciate you help.

CloverQ's avatar
CloverQ
Former Staff
6 years ago

Hi hes_bruce 

 

Thank you for import file, log and the additional information.

 

-25 Invalid Amount error generally means somewhere within the transaction the figures don't add up. From your import file, I can see that this sales transaction is Tax Exclusive. So as calculation goes:

 

- Total column should equal to Quantity x Price

- GST column should equal to 10% of Total

- The sum of the GST column should equal 10% of sum of the Total column.

 

You can open this file in Excel, add a temporary column A, set formula to quantity x price, then create another column to be 10% of column A. Then compare the figures in the temporary columns to the existing columns 'Total' and 'GST'. E.g. line 44 in the import file has quantity 100, unit price 0.11, but the Total is 10.54 instead of 11. You can also run the sum of these columns and see if they match. 

 

Please do go through the figures in the import file, fix any mis-calculation then try importing it again.

  • hes_bruce's avatar
    hes_bruce
    Contributing Cover User
    6 years ago

    Thanks CloverQ,

     

    MYOB exports to excel to 2 decimal places which threw the figures out as some of our pricing goes to 4 decimals.

     

    A quick tidy up as per your advice & I was able to import without errors.

     

    I wish MYOB had some kind of Order Merge so I didn't have to mess around with import/export.

     

    Thanks again for your help.

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.

 

Related content