Hi Dylan2,
Thank you for your post. Please allow me to extend a warm welcome to the Community Forum. I hope you find plenty of information in this forum.
We appreciate you expressing your concern to us and for the file you have attached. The 25: invalid amount issue occurs when Microsoft Excel adds extra characters to the import file. When you save Microsoft Excel as a text file, it automatically adds double quotes before and after each data item. If the numerical number includes a comma. This will force AccountRight Live to skip the fields and provide an import error. It expects normal characters in these fields. this field.
To fix this, try to remove the $symbol from all the amount columns. If you still get the same error, reduce the import file to a smaller batch, as that would help identify which transaction is causing this error.
With regards to the discount field you mentioned, the error message changes to 28: item is not sold when removed. You will get an error if you try to use an item with a negative selling or buying price in an invoice. You can create a new bill save it, then delete the old bill.
Let me know how you go with this. Feel free to contact us again if you need further assistance. We are happy to help.
Kind Regards,
Cel
