Forum Discussion

Contributing User

2 years ago

Error -25: Invalid Amount - trying to import sales into item bill so as not to double up on work load

Hello,

I need help in understanding what the import issues are. I managed to import one but it jumbled all the line items around so they were not in the date order as per the sale or bill. Now I can't remember how I had the original import file to copy to other sales invoices/supplier bills.

I'm constantly getting this same error but cannot understand why!? I came to MYOB thinking it would be more efficient but it's been a major pain. I'll attach the file when an expert responds however, this is sensitive information so would appreciate the files being redacted after. Cheers.

12 Replies

Replies have been turned off for this discussion

Mazzii1
Contributing User
2 years ago
Hi Earl_HD

Thank you for that. The last four digits of the serial number is 6183 and the Company File ID is 1 (from the Desktop app, I select Help > About MYOB AccountRight).

Cheers,

Mazzi
Mike_James
Ultimate Cover User
2 years ago
Hi Mazzii1 , when you import an item purchase, there is only one field named Quantity, so you only need that column in your import file. After import, the bill transaction will show both columns completed.

If you use the names of the available fields per the import wizard in your file, then you can auto-match your file to the AccountRight fields.

Your fields should be in order - Quantity, Price and Total (your file needs a Total column as well). Your file also has no date column, which you may wish to add.