Interfacing data into General Ledger

Note: For detailed information about interfacing data, see the Lawson Enterprise Financial Management Conversion Guide, General Ledger File Layouts, Data File Text, and User Text.

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.

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. File layouts are available on the Documentation page on Infor Support 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.