Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AM97


AM97.1 - Item Interface Adjustment

**Form Purpose
Use Item Interface Adjustment (AM97.1) to view and edit the asset item
records imported into the Asset Item Interface file (AMASTITCNV) for interface
into the Asset Management application.

**More Information

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 item file named Asset Item.csv
from your PC, you could use the following command:

winptxfr -u asset-item c:\\Data\\Asset Item.csv

where asset-item 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 asset-item

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).

- (This form) To display AMASTITCNV data, Item Interface Adjustment (AM97.1).

- To display AMASTBKCNV data, Asset Book Interface Adjustment (AM98.1).

- 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.

If you use a company that has two or more required books, you will have to
add two or more books (AMASTBKCNV file) for each asset that should be added.

Once you successfully interface transaction records from the Asset Item
Interface file (AMASTITCNV) 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.




Updated Files

    AMASSET    - Used by a common library, not by this program.

    AMASSETADJ - Used by a common library, not by this program.

    AMASTITADJ - Used by a common library, not by this program.

    AMASTITCNV - Primary file, updated. Contains non-Lawson asset item
                 information to be converted to asset items in the Lawson Asset
                 Management system.

    AMASTITEM  - Used by a common library, not by this program.

    APAPPROVAL -

    APAUDIT    -

    APCOMMENTS -

    APCPYVND   -

    APHLDINV   -

    APVENADDR  -

    APVENBAL   -

    APVENGROUP -

    APVENLOC   -

    APVENMAST  -

    APVENPAY   -

    CBBANKINST -

    CBCASHCODE -

    CKPOINT    - Used by a common library, not by this program.

    CUSTDESC   -

    POVENDLOC  -

    POVENDOR   -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -


Referenced Files

    AMASSETCNV - Used by a common library, not by this program.

    AMCONTROL  - Used by a common library; not used by this program.

    AMLOCATION - Used by a common library; not used by this program.

    AMLOCDTL   -

    APACCRCODE -

    APAPPROVAL -

    APAUTHOR   -

    APCOMMENTS -

    APCOMPANY  -

    APCPYVND   -

    APDISCCODE -

    APDISTHDR  -

    APHLDINV   -

    APHOLDCODE -

    APINCCODE  -

    APINVOICE  -

    APPAYMENT  -

    APPROCGRP  -

    APUSRFLDEF -

    APVENBAL   -

    APVENCLASS -

    APVENLOC   -

    ARCUSTGRP  -

    CBCHECK    -

    CBUSER     -

    CBUSRCLASS -

    CUCONV     - Used by a common library, not by this program.

    CURELAT    - Used by a common library, not by this program.

    EEADVANCE  -

    EEAPPROVAL -

    EEEXPENSE  -

    GLADDRESS  - Used by a common library; not used by this program.

    GLCHART    - Used by a common library; not used by this program.

    GLSYSTEM   - Used by a common library; not used by this program.

    INSTCTRYCD -

    INSTREGN   -

    LMLEASE    -

    LMLEASESEG -

    MAINVHAND  -

    MAMATCHTBL -

    MAMTCHRULE -

    MAPOOLCNT  -

    POAOCDTL   -

    POVAGRMTHD -

    POVENDLOC  -

    PROCUREGRP -

    PURCHORDER -

    TXTAXRATE  -


INVOKED Programs

    ACAC
    ACCL
    API4
    IFAC
    IFCU
    IFSG
    SLSE
    SLSU
    IFOB