Other additional settings

  1. Access the Budget Distribution (tffbs0101m000) session and define Distribution code, Distribution Method and Number of Distribution Periods.
    1. Select a distribution code and on the Specific menu, click Generate Distribution Data by Period or Budget Distribution Data by Period. The Generate Budget Distribution Data per Period (tffbs0202m000) session is displayed.
    2. Define Generation Method, Multiplier and Step Size in this session.
    3. Click Generate. The percentages/factors and multipliers are now created in the Budget Distribution Data by Period (tffbs0102m000) session.
  2. Access the Budgets (tffbs0503m000) session, specify this information:
    • Budget
    • Budgeting Method
    • Link with Ledger Account
    • Number of Budget Periods
    • Dimension Type 1 - 12 Applicable
    • Quantity 1 - 2
    1. Go to the Budgets per Year (tffbs0505m000) session, specify this information:
      • Distribution
      • Budget Currency
      • Parent Budget
      • Comparison Budget
      Note:  For each fiscal year, you must define which budget codes are applicable.
  3. Go to the Budget Defaults by Ledger Accounts/Dimensions (tffbs0504m000) session, specify this information::
    • Ledger Account
    • Dimension 1 - 12
    • Distribution
    • Variability %
    • Base Rate
    1. Access the Flexible Budget by Year (tffbs1510m000) session.
    2. Click Copy from Ledger Account Structure.... on the specific menu
    3. Go to the Ledger Account Structure by Dimension (tffbs0120m000) session, if you want to insert a new ledger account in this structure, Infor ERP LN assigns a number which may not be in sequence with existing ledger accounts number..
    4. Click Renumber Ledger Accounts, on the specific menu, to prevent automatic sequence numbering. The Accept Step Value (tffbs1220m000) session is displayed.
    5. Define the steps in which the sequence numbers must increase in the Accept Step Value (tffbs1220m000) session.
    6. Click Continue to insert the steps. Now you can add a ledger account in the Ledger Account Structure by Dimension (tffbs0120m000) session.
  4. Define and use new parent/child (hierarchies) relations in the Financial Budget System and Cost Accounting functionality of the Infor ERP LN Financials.
    1. Access the Hierarchies (tffbs0510m000) session and define which dimension types are applicable for this hierarchy.
    2. Go to the Hierarchy for Ledger Accounts (tffbs0111m000) session and link ledger accounts and dimensions to the specific hierarchy.
    3. Go to the Hierarchy for Dimensions (tffbs0112m000) session and link the hierarchy and parent dimension of the General Ledger.
    4. Go to the Copy Hierarchy (tffbs0213m000) session and you can copy hierarchies defined in the financial budget system into other hierarchies.
  5. Access the Financial Statements (tffst1500m000) session to create a statement code.
    1. Select the statement code and on the Specific menu, click Statement Accounts by Fin.Statement.
    2. Export financial values from the General Ledger to the Financial Statements.
    3. Click Process Values to combine the financial values with the statement structure.
    4. Go to the Export Financial Values (tffst1204m000) session, specify the Data-source and Period Type.
    5. Click Export.
    6. Go to the Process Financial Statement Values (tffst1205m000) session, specify the Financial Statement, Data-source, Period Type and Export Financial Statement Account Structure.
    7. Click Process.
  6. Allocate costs between dimension types using the Generate Allocation Relations with Allocation Key (tfcat4202s000) session . This functionality is used to calculate a rate/surcharge for each product and to calculate deviations for each product.
  7. Define activity-based costing: The product-costing assumes that the costs of the Warehouse department can fairly be allocated between the products based on the number of items sold. In reality, however, this is highly doubtful. For example, product A is sold and packed in a very simple box that contains four pieces by a machine, but product B is exclusively packed one by one manually. The time/costs to pack product B is, therefore, in reality higher. For this reason, allocating additional warehouse costs to product B is more realistic.
  8. Set up the external integrations.
    1. Go to the Export Flexible Budget and Cost Analysis Data for OLAP Systems (tfcat3200m000) session, specify this information:
      • Export Currency
      • Hierarchy
      • Budget
      • Fiscal Period
    2. Click Export. The data is processed in the background in the Exchange (XCH) functionality to export all data. This session also uses predefined exchange schemes to export the selected data. You can import this data in the Hyperion OLAP.