Creating Line Item Import Report Definitions

Line Item Report Definitions provide the framework for populating Lawson data in a file that you can import from the Pillar application's budget report. When you create a Line Item Report Definition, you identify the data that you want to import. You can create multiple import report definitions within a given budget. Use this procedure to create a budget line item import report definition:

  1. From Budget Architect (EB10.1), select the budget name.
  2. Select Define Rpt to display Line Item Reports (EB30.1).
  3. On Line Item Reports (EB30.1), specify Import Report to display Budget Line Item Import (EB30.2).
  4. Specify or select the budget name.
  5. Specify the name for your report and a short description in the Report Name and description fields.
    Note: The report name becomes the import file name, and must not contain any special characters or spaces.

    See Renaming line item report files.

  6. Specify a report information type in the Type field. Select one of these types to identify the Pillar application report in which you intend to import data:

    • Assets

    • Liabilities & Equity

    • Revenues

    • Expenses

      Note: In the Pillar application, you can create budget reports in one of the above modules. For example, if you want to import data to a report you created using the Pillar application's Expense module, then select Expense.
  7. Specify the Lawson application that contains the import data in the Source field. These are the available options:

    • General Ledger. This requires your budget's Accounts Dimension to be mapped to the Accounts dimension source and the Cost Centers and Revenue Centers dimensions to be mapped to the Accounting Units dimension source.

    • Project Accounting. This requires your budget's Accounts Dimension to be mapped to the Account Categories dimension source, and the Cost Centers and Revenue Centers dimensions to be mapped to the Activities dimension source.

    • Lawson Human Resources. Your budget's Accounts, Cost Centers, and Revenue Centers dimensions can be mapped as described for either General Ledger or Project Accounting. Data is collected from the employee file and summarized based on the default Accounting Unit and Account or Activity and Account Category specified on Employee (HR11.1).

  8. Specify the fiscal year for your budget in the Fiscal Year field.
    Note: If the Report Column Template includes fixed periods (such as Month 1 or Quarter 1) and the Source field is GL or AC, then specify the fiscal year that contains the data you want. If the Source field is HR, then you do not need to specify a fiscal year since salary and wage data is populated from current employee files.
  9. Specify a line item description in the Line Item field to indicate the line item to be populated in the import file's Line Item column. This description will appear in every row.
  10. Specify or select the template name in the Template field to identify the columns that you want for the report definition. The template determines the order in which the data will be populated in the import file.
    Note: To successfully import the file in the Pillar application's report, the template columns should match the Pillar application's report columns exactly.
  11. Specify or select Y in the Header field to include column headers in the import file.
    Note: In the Pillar application's reports, a line item's amounts, units and rates can appear in separate rows. Also, you can include header rows in your import file.
  12. Select Y in the Amount Lines field to populate line item data in the Pillar application report.
  13. Select Y in the Unit Lines field to populate line item data in the Units row in the Pillar application's report. You cannot set this field to Y if the Amounts Lines field is set to Y. The Pillar application does not accept both unit and amount lines in the import file.
    Note: If your import report source is HR, then a unit is equal to headcount.
  14. Select Y to populate line item data in the Rates row in the Pillar application's report. If the import report source is HR, then the rate is equal to salary. If the source is GL or AC, then the rates are extrapolated by dividing Amounts by Units.
  15. Add the report definition.
  16. Continue with Selecting Line Items.