Import Journal template - MYOB premier
Hi all, Im a new MYOB user trying to transition a general ledger from an existing accounting system. I require assistance for a general ledger transaction import. I have pulled together the attac...
Forum Discussion
Hi Gavin,
I am trying to create a GJ import template using the export of similar journal already recorded as per your advice. Looks like the GJ number field is a system controlled, should i leave this field blank as this is a new GJ?
Hi sc_spl
Yes if you want MYOB to use the next number in the order, leave this blank. If you want MYOB to use a specific reference as the ID you can eneter your own ID.
Regards
Gavin
Hi gavin12345 ,
Is there limit on journal line entries in the GJ import? We tried to import around 550 lines.
How do we know which line we have format error? i have attached screenshot of error log.
Appreciate your help on this.
Hi gavin12345 , I am having the same issue with journal import. Could you please advise? Thanks.
Importing 550 lines as one journal makes it difficult to pinpoint the line that is causing the error. Perhaps try breaking it down to smaller Journals (Part 1 of 10 for example).
A few basics:
Export 2 existing General Journals and use this export as a guide
Save a tab delimited rather than CSV
Open in Notepad and add {} to first line
Use Notepad to edit and replace " with nothing (quotes with nothing) this will remove any quotes added by Excel in the saving process
Break into smaller chunks
Ensure your column Order matches the order of the template
Regards
Gavin
