AC50.1 - Activity Import Adjustment Use AC50.1 (Activity Import Adjustment) to adjust activity information that you want to import from your existing non-Lawson system to the Activity Management system. AC500 (Activity Import) uses the data from this program during the import process. This import allows the addition of new activities, a manager resource, and up to ten activity attributes. Use a transfer utility program (such as the winptxfr or ftp command) to transfer the non-Lawson file to the target machine. When you transfer the non-Lawson file, you rename the file. For example, if you are transferring from Excel, use: winptxfr -u filename c:\\Data\\Excel\\filename where the filename is the Lawson Activity Import file. Use an Import command such as: importdb productline ACIFACTV filename where the filename is the name you assigned when you transferred the file to the Lawson system to load the activity import file into the ACIFACTV file for use in this program. If you are adding activities that have revenue history or billed history (prior to going up on Lawson), you must update the fields on the Bill Totals form tab on AC50.1. If you are adding or changing an activity record that will be imported to a General Ledger-only activity group, the only fields required on AC50.1 are Activity, Activity Description, and Old Activity Group. Updated Files ACIFACTV - This is the primary file maintained by this program. Maintains the activity information to be imported to Activity Management system. CKPOINT - Used for restart capability. Referenced Files ACACCTCAT - References this file to validate the account category. ACACCTCATX - References this file to validate the account categories assigned to the activity group. ACACTGPREL - References this file to validate the old activity group and determine the activity group. ACACTGRP - References this file to validate the activity group. ACACTIVITY - References this file to validate the activity does not already exist. ACACTREL - References this file to validate the old activity and determine the activity. ACADDRESS - References this file to validate the activity address. ACASSIGN - References this file to validate the activity resource assignment. ACAUDIT - References this file to validate the activities in the audit file in the process of being copied or moved. ACLEVEL - References this file to validate the activity level does not already exist and validate a parent activity exists for this activity group. ACRESCLASS - References this file to validate the resource class. ACRESOURCE - References this file to validate the Activity Management person resource being assigned as the activity manager. ACRPTGRP - References this file to validate account category group header information. ACRPTGRPX - References this file to validate the existence of account categories in an account category group. ACSTATUS - References this file to validate the activity status. ACUOM - References this file to validate the unit of measure code. APCOMPANY - References this file to validate the Accounts Payable Company for vendor resources assigned as the activity manager. APCPYVND - This file is used by a common routine that is used by this program. APHLDINV - This file is used by a common routine that is used by this program. APVENCLASS - This file is used by a common routine that is used by this program. APVENGROUP - This file is used by a common routine that is used by this program. APVENMAST - References this file to validate the Accounts Payable vendor assigned as the activity manager. EMPLOYEE - References this file to validate the Human Resource employee assigned as the activity manager. GLADDRESS - This file is used by a common routine that is used by this program. GLCHART - This file is used by a common routine that is used by this program. GLSYSTEM - References this file to validate the General Ledger company assigned as the activity's responsible company. HRSECLEV - This file is used by a common routine that is used by this program. MXCATDEF - This file is used by a common routine that is used by this program. MXELEMENT - This file is used by a common routine that is used by this program. MXOBJCAT - This file is used by a common routine that is used by this program. MXVALIDATE - This file is used by a common routine that is used by this program. PRSYSTEM - References this file to validate the Human Resource company assigned to the employee resource assigned as the activity manager. INVOKED Programs HRFN IFAC ACAC IFCR IFSG IFCU IFAU SLSE SLSU |