Interfacing data into General Ledger

You can interface a variety of non-Lawson data into General Ledger including a chart of accounts, accounting units, accounting unit attributes, valid attribute value ranges, budgets, balances and transactions. Interfacing existing data from a previous system can save setup time during your Lawson implementation. You might also interface balances and transactions on a regular basis if you have non-Lawson subsystems or, if you do, your General Ledger processing on multiple application servers. Use this generic procedure along with the specific tables that follow it to interface data into General Ledger. The tables after the procedure designate the programs and files that you use to interface based on the type of data you are interfacing.

If the balances or transactions you are converting are located on another application server, then you must transfer them to the target application server first. See Transferring balances and transactions from other application servers.

Note: For more information on interfacing balances, see:

Enterprise Financial Management Conversion Guide
Standard List of Reports-Supply Chain and Financial Management
General Ledger File Layouts in KB2218730 in Infor Customer Portal

Prepare the interface file. The file must be in an importable format such as a comma-separated value (CSV) file and the file fields must match the order and data type of the fields in the appropriate interface file. The Financial Management File Layouts are available in KB2218730 in Infor Customer Portal.
Transfer the interface file to the application server that contains your Lawson environment. You can use a standard transfer utility, such as ftp.
Use the Import (importdb) command to load the data into the appropriate interface file.
To edit records in the interface file, use the appropriate online program.
To check records in the interface file for errors, run the appropriate report program or the appropriate batch program with No selected in the Update field. The batch program creates a list of records that contain errors and a description of each error.
If you need to correct identified errors, then use the online program to make the required corrections.
Run the appropriate batch program with All selected in the Update field. The batch program interfaces the conversion file and updates other appropriate files.