Import General Journal
Hi, I'm trying to import a general journal, I've exported the template and updated with new data. However I keep getting an error -15 account not found. When I view the log the account numbers h...
Forum Discussion
Hi BelindaParker , the account numbers appearing in the import log are internal numbers only, but they do indicate that an account number has been found. You should confirm that the account numbers are postable, but this error can be reported for other non-related reasons.
For example, your template does not include a column for the tax amount, which is a required field (see Import and export fields for details). This field is required even if zero.
I enclose an example journal which is based on exporting a GJ transaction from my file. I recommend including all the columns, in the order displayed. (Category can probably be omitted unless you are using them). Even a change in column sequence has been known to cause import errors.
Thanks Mike,
I've updated my journal to bring through all of my columns, I've triple checked my GST. Still giving me the same error.
I'm copying the data from an excel file into the text file via excel, ie I open the text file in excel and copy the data over as text into the excel and close. It is then saved which updates the text file.
I'll have to enter my 80 lines manually as I cannot waste any more time on this for month end.
I'll come back and revisit next week as it is driving me nuts. I've also logged it with the support team.
Thank you for your help.
Belinda
Hi BelindaParker , if you wish, email me the text file you are attempting to import , and the log file created, and I'll see if I can spot any other issues. Email: mike (at) datawise dot co dot nz
%20import%20format.jpg){kind=link}