Budget Interface (FB165)

Run Budget Interface (FB165) to import non-Lawson budget data and create budget header and detail records. You can create up to 999 budgets for each company for each fiscal year. You can define a currency code for this budget that is different than the base currency code. If the currency code is not defined, the base currency is used.

Use this program after you review your interface options on Budget Interface Maintenance (FB65.1).

Note: If you run FB165 with a space and no other characters in the Run Group field, you may not get any records returned. To do a search that does not include any specific Run Group value, be sure that there are no spaces or characters in the field.

Processing effect

When you convert data, the system searches the organization relationship table to find a relationship between the old company field in the table and the old company field in the FBUDGETREL (UNIX/Windows) or DBGLFBR (IBM i) file. If a relationship exists, the old company field is translated to the Lawson company and accounting unit.

If a relationship does not exist:

  • If you select the Accounting Unit conversion method, the old company field in the FBUDGETREL (UNIX/Windows) or DBGLFBR (IBM i) file is formatted so the first 4 characters are numeric and represent the company number and the next 15 characters are alphanumeric.
  • If you select the Level conversion method, the first 4 characters represent the company number and the next 30 are used to locate the variable level that is converted to its corresponding accounting unit.

More information

Run Budget Interface Listing (FB265) to list data in the budgeting interface file before running FB165.

Use Budget Entry (FB20) to display and maintain converted information after you run this program.