Interfacing activities

Use this procedure to import activity information from an external source to Project Accounting. For additional help, the 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 activity information you want to interface. The file fields must match the order and data type of the fields in the Activity Import ACIFACTV (Unix/Windows) or DBACAIV (IBMi) file. This 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 activity data from the CSV file into the Activity Import file. For instructions on using the Import command, see Lawson Administration: Server Setup and Maintenance.
    Note: Because of the difficulties of verifying levels, you cannot import activities in a non-update mode.
  4. To review or edit records in the activity interface file, use Activity Interface Adjustment (AC50.1).
  5. Update the imported activities using Activity Interface (AC500).