Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AM51


AM51.1 - Item Update Adjust Interface Maint

**Form Purpose
Use Item Update Adjust Interface Maint (AM51.1) to review and edit asset item
records imported into the Lawson Asset Item Interface file (AMASSETINV) from a
non-Lawson asset item file. Use this form to verify that your information
transferred to the Lawson environment correctly.

Note This program is used to add items to existing assets and items, not to
interface new items.

**Process at a Glance

1. Format the non-Lawson asset-item file you want to convert as a
comma-separated-value (CSV) file. The fields in each file must match exactly
the position, size, and type of the fields in AMASSETINV.

The file layouts for the Lawson interface files are available on the Web. See
your Lawson representative for more information.

2. Transfer the 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 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 the transferred file into AMASSETINV, using an Import command. For
example, to load the asset-item file from the previous example, use this
command:

importdb productline AMASSETINV asset-item

where productline is the Lawson product line where your Asset Management data
is stored.

4. (This step) Display and edit the data in AMASSETINV, using Item Update
Adjust Interface Maint (AM51.1).

Note You can also run Item Update Adjustment Interface Listing (AM251) to
list asset item records in the Asset Item interface file.

5. Run Item Update Adjustment Interface (AM551) to load the asset information
into the Asset Management application. Once asset item records are interfaced
successfully, they are deleted from the Lawson interface file and exist as
unreleased adjusted records in the Asset Management application.

Once you have interfaced asset data successfully, using AM551, the records
are deleted from AMASSETINV file and they exist in the Asset Management
database in an unreleased adjusted state. You can use Items (AM20.3 or AM21.3)
to edit and release the asset adjustments online, or Processing Release
(AM170) to release the asset adjustments in batch.




Updated Files

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

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

    AMASSETINV - The primary file updated by this program.

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

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

    APAPPROVAL -

    APAUDIT    -

    APCOMMENTS -

    APCPYVND   -

    APHLDINV   -

    APVENADDR  -

    APVENBAL   -

    APVENGROUP -

    APVENLOC   -

    APVENMAST  -

    APVENPAY   -

    CBBANKINST -

    CBCASHCODE -

    CKPOINT    -

    CUSTDESC   -

    POVENDLOC  -

    POVENDOR   -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -


Referenced Files

    AMCONTROL  -

    AMLOCATION - Used to edit the location.

    AMLOCDTL   - Used to edit the location detail.

    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 by this program.

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

    GLSYSTEM   - Used by a common library, not 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