AX 4.0 Geeral Ledger General Journal Import Function

I have a user wo wants to explore the General Ledger General Journal Import function using Excel as a source for the import data. Unfortunately we do not know how or where to define the Excel format or what preliminary setup we need to make. Has anyone been through this?

What feature in AX are you using to import the Excel ?

There isn’t a standard function in AX 4.0 for General journal import.

You can use the Data export/import periodic function in the Administration module, but there are some significant challenges when attempting to import a General journal.

If you were to import this with the data export/import function, be aware of the following:

  1. You need to import into two tables - LedgerJournalTable & LedgerJournalTrans.

  2. Your import should “Import”. Don’t set it to “Delete & Import” in the Table setup of the Definition group.

  3. You need to specify the Journal number in your spreadsheet. The data import doesn’t have visibility to the number sequences unless you add some Conversion code. After the import, you will need to increment the Journal number sequence.

  4. You need to specify the Voucher number in your spreadsheet. After the import, you will need to increment the voucher number sequence.

  5. If you need to import a Fixed assets journal, there is a related table (LedgerJournalTrans_Asset) which needs data as well. But, this table needs a reference to the related record in LedgerJournalTrans. This can get tricky.

  6. If you need to import a Project journal, there is a related table (LedgerJournalTrans_Project) which needs data as well. But, this table also needs a reference to the related record in LedgerJournalTrans.

With all of these challenges, we have usually had our developers create a custom general journal function.

Brent