Importing Budget - Warning 567: Invalid budget amount
Hi Team,
I'm having issues importing FY20 budget with error code comes out : 'warning 567: Invalid budget amount;'
I've tried a couple of times and found that any amount bigger than 1,000.00 can not been imported which is troublesome, as manual entering is very time cosuming and most of our budget figures are bigger than 1,000.00.
Appreciate if someone can help me with this issue.
Hi Jinan
You would get this warning message if there are invalid characters around the amount field. Therefore, it is recommended to format the amount fields in excel to remove any currency symbols or other formatting.
I would also suggest to check if the import file itself is correct. A good way of doing that would be entering a budget with amount more than 1000 in AccountRight and then exporting it. You can then compare the exported file with the import file and check if there are any differences. If you cannot find any differences, try importing the exported file back into the software and check if you then get the error message. However, do take a backup of your file before doing this to avoid any unexpected results.
Please let me know how you go with that.
