Importing asset item adjustments

Use this procedure to import non-Infor asset item data to the Asset Accounting application and to adjust existing released Infor assets. You cannot modify data for existing items. You can only add items to already released assets. Assets must exist in a Released state. After the import, the assets are in an Adjusted state and must be released again.

See the Data Interface Guide.

  1. Prepare the non-Infor asset item file. The file must be in an importable format such as a CSV file. The file fields must match the order, size, and file type of the fields in the asset item adjustment interface file.
  2. Transfer the non-Infor file to the system that contains the Infor environment.

    Use a standard transfer utility, such as ftp. Rename the file to match your system requirements.

  3. Load the copied file into the asset item adjustment interface file using the importdb command at the environment prompt:
    importdb productline AssetItemAdjustmentImport adjfilename

    Replace adjfilename with the name of the non-Infor asset adjustment file that is transferred to your system in step 2.

  4. Select Conversion And Interfaces > Asset Item Adjustment Import List.
  5. Click Create.
  6. Specify this information:
    Run Group
    If you select a run group, then only the records in the run group are imported. If this field is blank, then records in the asset item adjustment import are included.
    Asset
    If you select an asset number, then only items for this asset are imported. If this field is blank, then all of the items for all of the assets are imported.
    Sequence Number
    Specify a sequence number where the records are imported.
  7. On the Item Detail tab, specify this information:
    Item Number
    Specify a number for the asset item. The item number must be unique within an asset, but can be duplicated from asset to asset.
    Item Description
    Provide the description for the asset item.
    Purchase Date
    Select the date of the asset item that is purchased. This date can be different from the in-service dates for the depreciation books.
    Item Quantity
    Specify the item quantity. Item quantity is the number of units that create the asset item.
    Item Cost Transaction
    Specify the item cost transaction. Item cost transaction is the cost of the asset in the transaction currency. This field is required if the asset is depreciable.
    Item Tax Transaction
    Specify the item tax transaction. Item tax transaction is the tax on the asset in the currency of the transaction.
    Add to Basis
    Select whether the cost of the item is added to the asset base amount.
    Compute Depreciation
    Select whether the compute depreciation is set to Yes, No, or Prospective.
  8. On the Item Options tab, specify this information:
    PO Number
    Specify the purchase order number, release number, and order code.
    Vendor
    Specify the vendor's identification code.
    Vendor Name
    Specify the vendor's name.
    Invoice
    Specify the invoice number for the item.
    Barcode
    Select the barcode that is assigned to the item.
    Model Number
    Specify the model number of the asset item.
    Serial Number
    Specify the serial number of the asset item.
    Project
    Select the project that is associated with the asset.
    Location
    Select the location for the asset.
  9. Click Save.
  10. Select Conversion And Interfaces > Asset Item Adjustment Import.
  11. Specify this information:
    Adjustment Date
    Specify the adjustment date.
    Release
    Select No to generate a report of imported records without importing them. Use this to catch errors before creating changes to the database. Select Yes to interface and delete the records that are not in error from AssetItemAdjustmentImport. Use Items to view and maintain the records.
    Run Group
    Select a run group to list the conversion records.
    Asset
    If you select an asset number, then only items for this asset are included. If this field is blank, then all of the items for all of the assets that meet your other selection criteria are imported.
    Page Break
    Select Yes to include a page break between assets.
  12. In the Report Distribution section, select a distribution list and export type for these reports:
    • Asset Item Update Adjustment Interface Report
    • Asset Item Interface Error Report
  13. Click Submit.
  14. View the report that is generated by Asset Item Update Adjustment Interface. Use these steps if errors exist:
    1. Correct the non-imported adjustments.
    2. Rerun Asset Item Update Adjustment Interface.
    3. Repeat this step until the report shows no errors.