Interfacing budgets

You must interface non-Lawson data into the Budgeting application before you can define your conversion options. Use this procedure to import your non-Lawson data, review your interface records, and define conversion options.

  1. Prepare the interface file.
    Note: The file must be 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 Budget Conversion (FBUDGETREL for UNIX and Windows or DBGLFBR for IBM i) file. This file layout is available in KB2218730 in Infor Customer Portal.
  2. Transfer the CSV file to your Lawson server. You can use a standard transfer utility such as ftp.
  3. Use the Import (importdb) command to load the data into the Budget Conversion file.
  4. Access Budget Interface Maintenance (FB65.1) to define budget conversion information.

    Use these guidelines to specify the field values:

    Run Group

    Select the run group name that you assigned when you transferred data from a non-Lawson application.

    Note: The run group name is stored in the Budget Interface file.
    Sequence

    You can specify the transaction sequence number. The sequence number is a user-defined value to identify the order of transactions.

    Organization Code

    Select an organization code that identifies the GL company and accounting unit where the converted balances are stored.

    Note: The organization code is defined on Organization Relationships (GL08.1).
    Account Code

    Select an account code that identifies the GL account and subaccount where the converted balance information is stored.

    Note: The account code is defined on Account Relationships (GL09.1).
    Year

    Specify the fiscal year for the budget conversion.

    Budget

    Specify the budget number where you will convert the data.

    Currency

    This field determines displays the currency code that is attached to the budget.

    Note: Leave this field blank to set the base currency as the default value.
    Type

    This field determines whether the values in the Amount field are period balances or year-to-date balances.

    Units

    This is the units by period converted from your non-Lawson application data. If the values are incorrect, then you can make the necessary changes.

    Factor

    You can select a global factor that you defined on Global Factors (FB00.1) to calculate the budget amount.

    Note: If you select a global factor, then leave the Rate field blank.
    Rate

    You can select the rate that affects the period budget amount. For example, you can use the inflation rate or an employee's hourly contract salary.

    Note: If you define the rate, then leave the Factor field blank.
    Amount

    This is the amount by period converted from your non-Lawson application data. If the values are incorrect, then you can make the necessary changes.

  5. Select the Add special action.
Related topics