Interfacing activities

Use this procedure to import activity information from an external source to Project Accounting. For additional help, Project Accounting conversion file layouts and a conversion manual are available on the internet at the Lawson support site.

  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 on the internet support site.
  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).
Related topics