Interfacing asset item adjustments

You can use a standard transfer utility such as ftp. You may have to rename the file to match your machine's requirements.

importdb productline AMASSETINV adjfilename

where adjfilename is the name of the non-Lawson asset adjustment file transferred to your machine in step 2.

Specify this information:

Run Group

Specify or select the run group name you assigned when you transferred the non-Lawson file to the target machine.

Asset, Sequence Number

These fields uniquely identify each item record in the interface file. The asset number must already exist as a released asset in Asset Management.

Item Number, Item Description

You are not required to assign an item number or a description to an item. If you do not assign a description, the asset description is used.

Purchase Date, Item Quantity, Item Cost Base,

These fields are required to create an item.

The item cost is expressed in company base currency.

Item Tax Base

If applicable, this field contains the item's tax in base currency.

Item Cost, Transaction, Item, Tax Transaction

If the transaction currency is different from the base currency, these fields contain the item cost and tax amounts in transaction currency.

Add to Basis

Select whether the cost of the item should be added to the asset base amount. Yes is the default.

Note: This field must be Yes if you select Yes in the Compute Depr field.

Compute Depreciation

Determines whether depreciation should be updated when you run Item Update Adjustment Interface (AM551) in step 5.

Note: If you use Yes in this field, you should also use Yes in the Add to Basis field.

Item Options tab: Barcode, Location, Location Detail

If the asset to which you are interfacing is part of the physical inventory, you must specify a bar code, a location, and (if applicable) a location detail for the item.

Other Item Options fields

Other fields are not required for a successful interface.

If applicable, you can specify or select a PO number, vendor, invoice number, model number, serial number, or activity associated with the item.

Specify this information:

Adjustment Date

This field is required

Release

Use Y (Yes) in this field to interface asset, asset items, and asset book records. Records that contain data incompatibility errors are not interfaced. Records that are interfaced are removed from the interface files.

It is strongly recommended that you first run AM551 with the Release field set to N (No) to generate a report of interfaced and rejected records, before you interface the records and modify the Asset Management data. This step may save you extensive rework.

Company, Company Group

You must select a company or a company group. Only one of these fields can have a value.