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)

TableDescriptionSystem
ADDRDATAAddress CodeIF
CKPOINTNo description in the Lawson data dictionary
FBADJCODAUBudget Adjustment Code AuditGL
FBCNTRLAUBudget Journal Control AuditGL
FBDETAILBudget DetailGL
FBDETAILAUBudget Detail AuditGL
FBFNDHDRAUBudget Edit Group AuditGL
FBFUNDAMTBudget Fund BalanceGL
FBHEADERBudget HeaderGL
FBHEADERAUBudget Header AuditGL
FBHSTHDRAUBudget Version AuditGL
FBINTBUAUBudget Interbudget Rel AuditGL
FBSPREADAUBudget Spread Code AuditGL
FBTRANSAUBudget Transactions AuditGL
FBUDGETRELBudgeting RelationshipsGL
GLCONSOLGeneral Ledger ConsolidationGL

Referenced files (21)

TableDescriptionSystem
FBADJCODENo description in the Lawson data dictionaryGL
FBCONTROLBudget Journal ControlGL
FBFACTORBudget Global FactorsIF
FBFUNDDTLBudget Fund DetailGL
FBFUNDHDRBudget Fund HeaderGL
FBHISTHDRBudget History HeaderGL
FBINTBUInterbudget RelationshipGL
FBSPREADBudgeting Spread CodeGL
FBTRANSBudget TransactionsGL
FBUDGETRELBudgeting RelationshipsGL
GLACCTRELGL Account RelationshipsIF
GLADDRESSGeneral Ledger Company AddressIF
GLAMOUNTSGeneral Ledger AmountsGL
GLCHARTGeneral Ledger ChartIF
GLCHARTDTLGeneral Ledger Chart DetailIF
GLCOMPRELGL Organization RelationshipsIF
GLSYSTEMGeneral Ledger CompanyIF
GLTRANSGeneral Ledger TransactionsGL
INSTCTRYCDIntrastat Country CodesTX
SYSTEMCODESystem CodeIF
WFSETUPNo description in the Lawson data dictionaryWF

Program calls

Invoked programs (12)

ACAC, ACTA, API4, IFAC, IFAU, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU