Creating import report definitions for line items

Report definitions for line items 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 report definition for a line item, you identify the data that you can import. You can create multiple import report definitions within a given budget.

  1. From Budget Architect (EB10.1), select the budget name.
  2. Select Define Rpt to show Line Item Reports (EB30.1).
  3. On Line Item Reports (EB30.1), specify Import Report to show Budget Line Item Import (EB30.2).
  4. Specify or select the budget name.
  5. Specify the name for your report and provide a short description.
    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 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 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. This table shows the source application and the data mapping that you can use:
    Source application Data mapping
    General Ledger Requires you to map your budget's Accounts Dimension to the Accounts dimension source and to map the Cost Centers and Revenue Centers dimensions to the Accounting Units dimension source.
    Project Accounting Requires you to map your budget's Accounts Dimension to the Account Categories dimension source, and map the Cost Centers and Revenue Centers dimensions to the Activities dimension source.
    Lawson Human Resources Requires you to map your budget's Accounts, Cost Centers, and Revenue Centers dimensions as described for 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. In the Fiscal Year field, specify the fiscal year for your budget.
    Note: If the Report Column Template includes fixed periods such as Month 1 or Quarter 1 and the Source field is GL or AC, specify the fiscal year that contains the data. If the Source field is HR, then you do not have to specify a fiscal year since salary and wage data is populated from current employee files.
  9. Provide a line item description in the Line Item field to populate in the import file's Line Item column. This description is displayed in every row.
  10. Specify or select the template name in the Template field to identify the columns for the report definition. The template determines the order in which the data is 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 show in separate rows. You can also 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 the total 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. Select line items based on the import report source.
    See these topics: