Interfacing data into Multi-Book Ledger

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

You can interface balances and transactions from non-Lawson files to Multi-Book Ledger. Interfacing existing data from a previous system can save setup time during your Lawson implementation. Use this generic procedure along with the specific tables that follow it to interface data into Multi-Book Ledger. The tables following the procedure designate the programs and files you use to interface based on the type of data you are interfacing.

Interface data

  1. 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 internet support site.
  2. Transfer the interface file to the Lawson server that contains your Lawson environment.

    You can use a standard transfer utility such as ftp or the Lawson program winptxfr.

  3. Load the data into the appropriate interface file. You can use the Import (importdb) command to load the data. For instructions on using the Import command, see the Lawson Administration: Server Setup and Maintenance.
    • To import balances into the Multi-Book Ledger balance interface file (MLMASTREL, DBMLMMR), use this syntax:

      importdb productline MLMASTREL balancefilename

      where balancefilename is the name of the non-Lawson balance file transferred to your Lawson server in step 2.

    • To import transactions into the Lawson Multi-Book Ledger transaction interface file (MLTRANSREL, DBMLMTR), use this syntax:

      importdb productline MLTRANSREL transactionfilename

      where transactionfilename is the name of the non-Lawson transaction file transferred to your Lawson server in step 2.

  4. To edit records in the interface file, use the appropriate online program.
    • To edit the balance interface file (MLMASTREL, DBMLMMR), use Ledger Balance Interface Maintenance (ML67.1).

    • To edit the transaction interface file (MLTRANSREL, DBMLMTR), use Ledger Transaction Interface Maintenance (ML65.1).

  5. To check records in the interface file for errors, run 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.
    • To check for balance interface errors, run Ledger Balance Interface (ML167).

    • To check for transaction interface errors, run Ledger Transaction Interface (ML165).

  6. If you need to correct identified errors use the online program to make the required corrections.
  7. Run the appropriate batch program with All selected in the Update field. The batch program interfaces the interface file and updates other appropriate files.