|
|
FB165 - Budget Interface
**Form Purpose
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 in FB65.1 (Budget
Interface Maintenance).
Important 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 (iSeries)
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 (iSeries) 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 FB265 (Budget Interface Listing) to list data in the budgeting interface
file before running FB165.
Use FB20 (Budget Entry) to display and maintain converted information after
you run this program.
Updated Files
ADDRDATA -
CKPOINT - Used for restart capability.
FBDETAIL - This file stores the posting account budget balances converted
by this program.
FBFUNDAMT -
FBHEADER - This file is updated with the budget's last maintained date
and time.
FBUDGETREL - This file is accessed to create posting account budget balance
records. These records are deleted as they are processed.
GLCONSOL - This file is updated with consolidated account budget balances.
Referenced Files
FBFACTOR - Used to validate the existence of a global factor.
FBFUNDDTL -
FBUDGETREL - This file is accessed to create posting account budget balance
records. These records are deleted as they are processed.
GLACCTREL - Used to validate the existence of account relationships.
GLADDRESS -
GLAMOUNTS -
GLCHART - This file is accessed by a common routine used by this
program. This file is not used by this program.
GLCHARTDTL - Used to validate the existence of a detail account.
GLCOMPREL - Used to validate the existence of organization relationships.
GLSYSTEM - Used to validate the existence of a company.
GLTRANS -
INSTCTRYCD -
SYSTEMCODE -
WFSETUP -
INVOKED Programs
IFAC
ACAC
ACCL
ACTA
API4
IFCU
IFOB
IFSG
IFLU
IFAU
SLSE
SLSU
|
