1. Localizations for Taiwan Implementation Guide
  2. Understanding the Import Process

Understanding the Import Process

You can import POS data from an external system using a variety of methods, such as importing from a spreadsheet, using a custom table conversion program, using Microsoft Access, and so on. This guide describes how to import the data from a Microsoft Excel spreadsheet.

The JD Edwards EnterpriseOne system enables you to import header data for POS transactions, such as the declaration site, transaction type, format code, and so on. You must provide the transaction header information. You can enter the transaction header information by importing the data or by manually entering the data for each transaction. You can also import POS transaction detail data. The detail data includes information such as the item number, quantity sold, unit of measure, and so on. Providing the detail data is an optional task. However, Oracle recommends that you import the detail data to maintain data integrity between the F75T004 and F75T005 tables.

The system does not validate imported POS header or detail data. Therefore, after you import POS data from an external system, you must check the imported data to verify that it is correct and make changes, if necessary.

To enter or import POS data:

  1. Use the GUI/VAT POS Review program to enter or import POS data and specify the general ledger account for the transactions.

    1. Import POS data from a spreadsheet to the GUI/VAT Transaction Header POS (F75T004P) and GUI/VAT Transaction Detail POS (F75T005P) tables.

      Alternatively, you can enter the data manually.

      You can import transaction header data and transaction detail data.

      Note: You can also use the GUI/VAT POS Review program to import a value in the Transaction Number From field.

    2. Review the imported data and make changes.

      The system does not validate the data that you import, so you must review it and makes changes or additions as necessary.

    3. Select the general ledger entry to associate with the transactions.

  2. Run the GUI/VAT POS Interface Inbound program (R75T101) to remove records from the F75T004P and F75T005P tables and write the records to the F75T004 and F75T005 tables.