Importing Invoices

Both, the Invoice (Vendor) and Invoice (Customer) can be imported. Again, the Is Sales Trx will indicate the type of document. Here, we should practice creating both invoices, based on prior import order data activities.

Creating the Invoices 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 Invoices.
  3. Set the Table field to I_Invoice (shown I_Invoice_Import Invoice in the option).
  4. Set the Format field to Comma Separated.

Next, we jump to the Format Field tab. The I_Invoice table contains 58 columns that can be used during construction of the Invoice Import Loader Format.

In this example, we'll use ...

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.