FB165 – Budget Interface
- System
- General Ledger (GL)
- Type
- Batch program
- Updates
- 16 tables
- References
- 21 tables
FB165 (Budget Interface) is a Lawson General Ledger batch program. It updates ADDRDATA, CKPOINT, FBADJCODAU, FBCNTRLAU, FBDETAIL, FBDETAILAU, FBFNDHDRAU, FBFUNDAMT and 8 more and references FBADJCODE, FBCONTROL, FBFACTOR, FBFUNDDTL, FBFUNDHDR, FBHISTHDR, FBINTBU, FBSPREAD and 13 more.
About 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). 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 (System 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 (System 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.
Updated files (16)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
| FBADJCODAU | Budget Adjustment Code Audit | GL |
| FBCNTRLAU | Budget Journal Control Audit | GL |
| FBDETAIL | Budget Detail | GL |
| FBDETAILAU | Budget Detail Audit | GL |
| FBFNDHDRAU | Budget Edit Group Audit | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| FBHEADER | Budget Header | GL |
| FBHEADERAU | Budget Header Audit | GL |
| FBHSTHDRAU | Budget Version Audit | GL |
| FBINTBUAU | Budget Interbudget Rel Audit | GL |
| FBSPREADAU | Budget Spread Code Audit | GL |
| FBTRANSAU | Budget Transactions Audit | GL |
| FBUDGETREL | Budgeting Relationships | GL |
| GLCONSOL | General Ledger Consolidation | GL |
Referenced files (21)
| Table | Description | System |
|---|---|---|
| FBADJCODE | No description in the Lawson data dictionary | GL |
| FBCONTROL | Budget Journal Control | GL |
| FBFACTOR | Budget Global Factors | IF |
| FBFUNDDTL | Budget Fund Detail | GL |
| FBFUNDHDR | Budget Fund Header | GL |
| FBHISTHDR | Budget History Header | GL |
| FBINTBU | Interbudget Relationship | GL |
| FBSPREAD | Budgeting Spread Code | GL |
| FBTRANS | Budget Transactions | GL |
| FBUDGETREL | Budgeting Relationships | GL |
| GLACCTREL | GL Account Relationships | IF |
| GLADDRESS | General Ledger Company Address | IF |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCOMPREL | GL Organization Relationships | IF |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| INSTCTRYCD | Intrastat Country Codes | TX |
| SYSTEMCODE | System Code | IF |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (12)
ACAC, ACTA, API4, IFAC, IFAU, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU