Hi Adminteam
This error points out that there is no account number in the import file, however, as we can see the account number in the error log, it appears that the formatting of the file is in error. Therefore, could you please try opening your import file in Excel and ensure that the account number field is in the relevant field?
If the formatting is correct in Excel, please attach the import file here so we can investigate what's causing this error.
Hi Komal_S ,
We checked the import logs in Excel and it did appear to be consistent with the accounts. However we did just notice that only the first entry is failing to import - and this is consistent across all our imports.
I've attached another import log from today. For this one only the first entry 10992 failed to import while the rest of the 40 suceeded. The attached doc shows the first couple of entries and the names have been deleted. So normally it is [name of client] external journal from MMS.
Thanks for your help,
Hi Adminteam
I have attached a sample template for this import to work successfully. Basically, if you remove the blank line between the header line and first import line, the import works successfully.
Please let me know if you still get any errors.
Thank you! This resolved the issue with the imports.
