Error -25: Invalid amount Spend Money

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

I am experiencing the same issue with the export file fields not matching the compulsory import fields. There is no guidance in the help for the errors that have come up.

MYOB, I can see several help requests on this very issue -- please assist!!!

BRigden 

Hi Bryony 

Sorry to see that no one has replied to you yet. I've had a look at the import file you attached and error code 25.

The description of the error code is "Invalid Amount When Importing".

The requirement for the amount field is: 15 characters (including 2 decimal places). In your document, you have entered 1920.1 in that field. I recommend changing that to 1920.10 and attempting to import again.

Bryony; If you're still not able to import and HelenBell; I see you are also seeking guidance on resolving Matching Fields, check our Help Article - Import and export fields and it will tell you what each field you will need to match (the required fields will have a * or ^ next to it). It also explains the correct format for the field as well.

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

Hi Samara,

What I was pointing out, 

**the export file fields not matching the compulsory import fields. There is no guidance in the help for the errors that have come up.**

The link you provided I had already found and read, and the issue remains that the export file and the import screen don't match each other or the help page -- these are all now attached.

For example, the import requires "ex-tax amount" but that is nowhere on the export options or the help page.

Something needs revising so that the export, import and help actually correspond with each other. Please advise better instructions than the help page has in the meantime?

Thanks

Helen

HelenBell 

Hi Helen

Sorry for the delay in response. I'm a little unsure of the question, as 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. I've compared the spend money export fields with the import fields transactions from my sample file and the fields are all the same.

Could you provide some more context as to which product you are using and the exact steps you are taking to get the different import fields so I can reproduce the error on my end?

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

Hi Samara

Thank you for reaching out and helping me.  I have attempted another import following your instructions below and it has returned the same error.  I have attached my import file and error log for reference.  Please let me know if there is anything else I can try to resolve this. 

With regards to the matching fields, when I export spend monies they have different headings to what is available on the import.  I would like to use the 'allocation memo' function but this is not available on the import as a heading but it can be exported and there is a field to fill in on the spend money screen.  Please can you advise how I can use this field in my import. 

It would be good to also undertsand which headings on the import page correspond with the spend money fields, as they change so differently from the export.  This is not detailed anywhere on the help pages.

Many thanks

Bryony

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.