Forum Discussion

Jinan's avatar
Jinan
Experienced Cover User
5 years ago
Solved

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 no...
  • Komal_S's avatar
    Komal_S
    5 years ago

    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. 

Komal_S's avatar
Komal_S
MYOB Moderator
5 years ago

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. 

  • Jinan's avatar
    Jinan
    Experienced Cover User
    5 years ago

    Hi Komal,

     

    Thanks very much for your advice.

    I've noticed those amounts have quotation marks when opened in notepad. After remove all those qutation marks, budget importing is completed with no error.