Importing General Ledger journal entries

To speed up our GL journal data entries, ADempiere provides an import GL journal feature. Here, we will practice how to perform GL journal import activities.

Creating the GL journal Import Loader Format

In the Import Loader Format window, we'll add and save the following information on the Import Format tab:

  1. Set the Organization field to *.
  2. Set the Name field to Import GL Journal.
  3. Set the Table field to I_GLJournal (shown as I_GLJournal_Import GL Journal in the option).
  4. Set the Format field to Comma Separated.

Next, we go to the Format Field tab. The I_GLJournal table contains 66 columns that can be used to set up our information.

In our case, we'll use the 13 most commonly-used columns for importing GL journal ...

Get ADempiere 3.4 ERP Solutions now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.