To convert non-Lawson project transaction history

Note: To import previously billed transactions, you must enter the transactions billable amount. This will trigger AC540 to set the override flag. Transactions with a zero billable amount will not be flagged as "Billed" even if the parameter is set on AC540.
  1. Prepare a comma-separated value (CSV) file containing the grant activity transaction information you want to convert. The file fields must match the order and data type of the fields in the Activity Transaction Relation (ACTRANSREL) 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 transactions from the CSV file into the Activity Transaction Relation (ACTRANSREL) file. For instructions for using the Import command, see Lawson Administration: Server Setup and Maintenance.
    Note: You can post converted transactions to General Ledger. On the GL Offset page of Transaction Interface (AC540) select the company, accounting unit, account, and subaccount to which the balancing entry should be posted.
  4. To review or check for errors, run Transaction Interface (AC540) in non-update mode.
  5. To review or edit records in the interface file, use Transaction Interface Adjustment (AC54.1).
  6. Update the transactions using Transaction Interface (AC540).
  7. Run Activity Posting (AC190) to post transactions to Activity Management. AC190 posts released journal entries created in AC540 and updates activity balances.