AM93.1 - Transaction Interface Adjustment
**Form purpose
Use Transaction Interface Adjustment (AM93.1) to review and edit the
transaction records imported into the Asset Transaction Interface file
(AMASTTRCNV) for interface into the Asset Management application. You can
convert transactions when you add new assets or attach transactions to already
interfaced assets. The transaction portion of the interface does not need to
be run at the same time as the new asset interface.
**Prerequisites
You must create a non-Lawson asset transaction file and import it into
AMASTTRCNV before you can view the interface transaction records on this form.
**Required fields
The following fields are required: Conversion Number, Sequence Number,
Transaction Description, Book, Company, Transaction Date, Accounting Unit,
Account, Account Type, and Process.
**Process at a glance
1. Format each non-Lawson file you want to convert as a comma-separated-value
(CSV) file. The fields in each file must match the fields in the Lawson
database file into which it will be imported. At a minimum, you must create
the three following files that must always be processed at the same time:
- An asset file matching the fields in AMASSETCNV,
- An asset item filed matching the fields in AMASTITCNV, and
- An asset book file matching the fields in AMASTBKCNV.
Optionally, you can create the two following files that can be both
processed concurrently with the three others, or each processed separately at
a later time.
- An asset transaction file matching the fields in AMASTTRCNV
- An attribute matrix file matching the fields in AMASTMXCNV
The file layouts for the Lawson interface files are available on the Web.
See your Lawson representative for more information.
2. Transfer each non-Lawson file to the target machine, using a transfer
utility program (such as the winptxfr or ftp command). When you transfer the
non-Lawson file, you may need to rename the file for use in the Lawson system.
For example, if you are transferring an asset file named Trans Interface.csv
from your PC, you could use the following command:
winptxfr -u trans-intf c:\\Data\\Trans Interface.csv
where trans-intf is the name you assign to the file in the Lawson
environment.
3. Load each transferred file into the appropriate Lawson interface file,
using an Import command. For example, to load the prevasset file from the
previous example, use this command:
importdb productline AMASSETCNV trans-intf
where productline is the Lawson product line where your Asset Management
data is stored.
4. (This step) Display and edit as needed the data for each Lawson interface
file as follows:
- To display AMASSETCNV data, use Asset Interface Adjustment (AM96.1).
- To display AMASTITCNV data, Item Interface Adjustment (AM97.1).
- To display AMASTBKCNV data, Asset Book Interface Adjustment (AM98.1).
- (This form) To display AMASTTRCNV data, Transaction Interface Adjustment
(AM93,1).
- To display AMASTMXCNV data, Attribute Interface Adjustment (AM94.1).
5. Run Asset Management Interface (AM500) to load the asset information into
the Asset Management application. Once asset records are interfaced
successfully, they are deleted from the Lawson interface file and exist as
unreleased records in the Asset Management application.
**Decision/impact
The Conversion Number field associates the transaction with the asset. It can
be a user-defined alphanumeric string that is common to all the matching
interfaced asset, item, and book files, or it can be the asset number
automatically assigned to the asset if it was interfaced before the
transaction.
If you interface the Asset Transaction file (AMASTTRCNV) after you interfaced
the Asset, Asset Item, and Asset Book files, you can choose to interface the
file by conversion number, or by asset number. If you interface by asset
number, the Conversion Number field must contain the zero-filled,
right-justified asset number. You can use the Select tool to view a
cross-reference of conversion numbers and asset numbers.
**More help
Once you successfully interface transaction records from this file, using
Asset Management Interface (AM500), you can no longer view or edit them on
this form. However, you can view them on Asset Management drill-around and
analysis forms.
Interfaced transaction records exist as historical records only in the
AMTRANS, AMBKTRANS, AMBKHIST, and AMBKHISX files. They are not interfaced to
the General Ledger.
Updated Files
AMASSETGRP -
AMASTTRCNV -
CKPOINT -
Referenced Files
AMACCTGRP -
AMASSET -
AMASTTYPE -
AMBOOK -
AMCNVASSET -
GLADDRESS -
GLCHART -
GLSYSTEM -
LMLEASE -
LMLEASESEG -
INVOKED Programs
IFAC
ACAC
ACCL
IFCU
IFSG
IFAU
SLSE
SLSU
|
