Interfacing account category structures and account categories

Use this procedure to import account category structure information from an external source to Project Accounting. This information can include an account category structure and the account categories included in the structure. If an account category structure or account category does not exist, the records are created automatically in the application. You can also use this process to edit or delete account category structures or account categories.

See KB2218730 in Infor Customer Portal and the Infor Lawson Enterprise Applications User and Administration Library - (On-premises) and select User > Enterprise Financial Management > Enterprise Financial Management Conversion Guide.

  1. Prepare a comma-separated value (CSV) file containing the account category structures and account categories you want to interface.
    Note: The file fields must match the order and data type of the fields in the Structure Summary Category Interface ACIFCAT (Unix/Windows) or DBACCIF (IBMi) file and the Structure Account Category Interface ACIFCATX (UNIX/Windows) or DBACCIX (IBMi) file.
  2. Transfer the CSV file to the server where your environment resides.
  3. Use the Import command to load the resource assignment data from the CSV files into the Structure Summary Category and Structure Account Category files.

    See Lawson Administration: Server Setup and Maintenance.

  4. To review or check for errors, run Structure Interface (AC558) in non-update mode. To review and edit summary account category records from the ACIFCAT interface file, use Summary Account Category Interface Adjustment (AC58.1). To review and edit the detail account categories for a summary account category, use Detail Account Category Interface Adjustment (AC58.2).
  5. Update the imported resources using Structure Interface (AC558).