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 doesn't exist, the application will automatically create the record(s). You can also use this process to edit or delete account category structures or account categories. For additional help, Project Accounting File Layouts (ACFL) is available in KB2218730 in Infor Customer Portal and the Enterprise Financial Management Conversion Guide is available in docs.infor.com.

  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. The file layout is available in KB2218730 in Infor Customer Portal.
  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. For instructions on using the Import command, 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).