Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms

AM98


AM98.1 - Asset Book Interface Adjustment

**Form purpose
Use  Asset Book Interface Adjustment (AM98.1) to review and edit the asset
book records imported into the Asset Book Interface file (AMASTBKCNV) for
interface into the Asset Management aplication.

**Prerequisites
You must create a non-Lawson asset transaction file and import it into
AMASTBKCNV before you can view the interface transaction records on this form.

**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 item file named Asset Book.csv
from your PC, you could use the following command:
     winptxfr -u asset-book c:\\Data\\Asset Item.csv
     where asset-book 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 asset-book file from the
previous example, use this command:
    importdb productline AMASSETCNV asset-book
    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).
-  (This form) 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.

**Decision/impact
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.

**More help
Once you successfully interface transaction records from the Asset Book
Interface file (AMASTBKCNV) 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

    AMACCOUNT  - Used to verify accounts. Used to store the general ledger
                 accounts that are used to create journal entries when assets
                 are processed (added, adjusted, transferred, and disposed of)
                 for an account group or for an asset type.


    AMACCTGRP  - Used to validate account groups. Used to store account group
                 records, which represent the general ledger accounts to use to
                 create journal entries when assets are processed (added,
                 adjusted, transferred, and disposed of).


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

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

    AMASSETGRP - Used to validate the asset group.

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

    AMASTBKCNV - Primary file updated. Contains non-Lawson asset book
                 information to be converted to asset books in the Lawson Asset
                 Management system.


    AMASTBOOK  - Used to verify book information.

    AMASTITADJ - Referenced by a common routine, not used by this program.

    AMASTITEM  - Referenced by a common routine, not used by this program.

    AMASTRECAP - Accessed by common library; not used by this program.

    AMASTRPAIR - Referenced by a common routine, not used by this program.

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

    AMAUGROUP  - Accessed by a common library; not used by this program.

    AMBKHIST   -

    AMBKHISTX  -

    AMBKTRANS  -

    AMCALENDAR - Used to edit dates and to update the Used field on the
                 Calendar file.


    AMCLASSDEP -

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

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

    AMDIVISION - Used to validate the division. Used to store division records,
                 which are used to report asset information.


    AMLOCATION - Used to validate the location. Used to store location records,
                 which describe where an asset is physically located.


    AMSEGBLOCK -

    AMTAXAUTH  - Used by a common routine, not by this program.

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

    AMTRANSUMM -

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

    MXLISTHDR  - Accessed by common library; not used by this program.

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


Referenced Files

    AMASSETCNV - Used to verify that the asset conversion record exists.

    AMASSETDSP - Not used.

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

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

    AMASTITCNV - Used to retrieve asset item conversion information.

    AMASTMXVAL - Referenced by a common routine, not used by this program.

    AMASTRPAIR - Referenced by a common routine, not used by this program.

    AMBOOK     - Used to verify the book name.

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

    AMLOCDTL   -

    AMMETHOD   - Used to validate the method. Used to store the Lawson-defined
                 and optional user-defined methods that asset books use to
                 calculate depreciation, replacement cost, and insurance values.


    AMPUCODE   - Used to validate personal use codes  Used to store personal
                 use codes, which asset books use to calculate depreciation.


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

    AMTABLEPCT - Used to validate percent table methods. Used to store
                 user-defined percent table methods that asset books use to
                 calculate depreciation, replacement cost, and insurance values.


    AMTABLETAX - Used to validate tax credit information. Used to store
                 optional tax credit table records that asset books use for
                 calculating tax credits.


    AMUOPPDS   - Used to verify Units of Production methods. Used to store
                 user-defined annual and period units of production table
                 methods that asset books use to calculate depreciation,
                 replacement cost, and insurance values.


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

    GLCGCPY    -

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

    GLCODES    -

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

    LMLEASE    -

    LMLEASESEG -

    MXOBJCAT   - Referenced by a common routine, not used by this program.


INVOKED Programs

    ACAC
    ACCL
    IFCU
    IFSG
    AMCO
    IFAC
    IFAU
    SLSE
    SLSU
    IFFC
    IFGT
    GLCC
    IFOB
    IFRS
    IFSC
    SLSB
    SLFD