Forum Discussion

BRigden's avatar
BRigden
User
3 years ago
Solved

Error -25: Invalid amount Spend Money

Hi    I hope you are able to assist me.  I am in the process of setting up a template for my team so they can import spend money transactions into MYOB.   I keep getting error messages.  Used to ...
  • SamaraM's avatar
    SamaraM
    2 years ago

    Hi BRigden and HelenBell 

     

    Thanks for providing the additional context, I have been able to reproduce the error, and I think my advice will work for both of you.

     

    When I go to the import/export assistant, I was seeing the fields mentioned in the article I sent earlier, not what fields - Helen- you sent through on your screenshot, but when I test it with the import file - Bryony- you sent I can see why you are both not getting all of the available fields.

     

    So if you have a look at the file test Spend money - 13.09.22.txt, and compare that with the example from the sample file below: 

     

     

    You can see that there is a " {} " missing in the first line. 

     

    If that code is not in the first line of the import file, then the software thinks it is an import file from an earlier version that didn't have the full list of fields, so it doesn't give the option for some of the available fields.

     

    If you go ahead and add that line to both your import files, then try again, I am confident it will give you the full set of available fields.

     

    Please give that a go and let me know how you both get on.


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

HelenBell's avatar
HelenBell
User

Hi Samara,

 

the fields you have in the import image, do not match the fields in the export image, or the help article in the third image. 

 

This is EXACTLY my point and why I took the time to include screenshots. This is why we need help.

 

The product is currently AccountRight Plus AU 2022.7.0 build 2022.7.24.7058.

 

The first screen shot on my previous message, as you can see, shows the options we get when importing Spend Money transactions (file>import/export assistant>import>spend money...)

 

The second screen shot is the options we get when trying to extract Spend Money (file>import/export assistant>export>spend money...) from the same file.

 

The process I was attempting was to export a few transactions to get the format, update the data and import back in. Echoing the import template creation instructions here, I originally didn't have a clearwater file to access, and the same client file would be preferable as it would contain the same account numbers etc in the example, but I just downloaded Clearwater and went through the process to give the benefit of the doubt and it still has the same issues.

 

The fields available to export do not include some of the compulsory import fields; namely ex-tax amount and inc-tax amount, the export only shows "amount". The help article also only shows "amount", so can you advise what needs to go in the Ex-Tax and Inc-Tax fields when importing please?? Even the Clearwater file import fails at this point. See attached.

SamaraM's avatar
SamaraM
Former Staff
2 years ago

Hi BRigden and HelenBell 

 

Thanks for providing the additional context, I have been able to reproduce the error, and I think my advice will work for both of you.

 

When I go to the import/export assistant, I was seeing the fields mentioned in the article I sent earlier, not what fields - Helen- you sent through on your screenshot, but when I test it with the import file - Bryony- you sent I can see why you are both not getting all of the available fields.

 

So if you have a look at the file test Spend money - 13.09.22.txt, and compare that with the example from the sample file below: 

 

 

You can see that there is a " {} " missing in the first line. 

 

If that code is not in the first line of the import file, then the software thinks it is an import file from an earlier version that didn't have the full list of fields, so it doesn't give the option for some of the available fields.

 

If you go ahead and add that line to both your import files, then try again, I am confident it will give you the full set of available fields.

 

Please give that a go and let me know how you both get on.


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

  • BRigden's avatar
    BRigden
    User
    2 years ago

    This works!!! Thank you so much for resolving this