Updating to the business management system

Use this procedure to update General Ledger or Project Accounting budgets with data in the files that you exported from the Pillar application.

  1. On EB10.1, select a budget and click Submit Rpt. to display Budget Report Updates (EB19.4).
  2. Click the Business Management System Update to display Business Management System Update (EB130).
  3. On EB130, select or specify a job name in the Job Name field.
  4. Specify a description for the job in the Job Description field. Completion of this field is optional.
  5. Select or specify a user name in the User Name field.
    Note: Usually this is your system user name.
  6. In the Parameters group on the EB130 form, select the budget name in the Budget Name field.

    If you are updating General Ledger, then you must map the budget's Account dimension to General Ledger accounts and the Cost Center or Revenue Center dimensions must be mapped to accounting units.

    If you are updating Project Accounting, then you must map the budget's Accounts dimensions to account categories and the Cost Center or Revenue Center dimensions must be mapped to activities.

  7. Select the system (GL or AC) to use as the destination for the transferred data.
  8. (Optional) The fiscal year specified in the Export Report definition is used. If you override the year, then ensure that it is valid for the General Ledger or Project Accounting budget.
  9. Specify the number of the General Ledger or Project Accounting budget to which you want to update the exported budgets.
  10. Specify the run group name in the Run Group field.
    Note: The Run Group Name groups together budget records in the intermediate budget files. For General Ledger: FBUDGETREL (UNIX/Windows) and DBGLFBR (IBM i).

    For Project Accounting: ACBUDREL (UNIX/Windows) and DBACACB(IBM i).

  11. Select how you want to update the budgets in General Ledger or Project Accounting. You can select to merge the data with existing budget values or replace the existing budget values with the exported data.
  12. Specify a name in the Error File Name to have any errors in the Budget Line Items written to this file. If there is a problem with processing budget data, then an error file with this name is created in the Lawson server directory that you specified for budget export reports on Budget Report Repositories (EB10.5).
  13. Specify the name of the export reports in the Budget Reports fields. You can specify up to four budget reports.
  14. Click Add on the tool bar to Add the job.
  15. Click Submit on EB130 to process the budgets exported from the Pillar application.
    Note: Budget records will be created for the run group that you indicated in the General Ledger (FBUDGETREL for UNIX/Windows, DBGLFBR for IBM i) or Project Accounting (ACBUDRELfor UNIX/Windows, DBACACB for IBM i) files. Use Print Manager to review job results.