How to view asset details on Sage 300

Steps:

  1. From the Sage Fixed Assets Integration folder, choose Asset Inquiry.  The Asset Inquiry form appears. 
  2. Fill in the selection fields at the top of the form if you want to limit the display to asset details that meet certain criteria, as follows:
    • To display details only for assets recorded in a specified Sage 300
      program, enter the source code for the program in the Application Source field. You can enter:
      • AP for Accounts Payable
      • IC for Inventory Control
      • PO for Purchase Orders
        • Leave the field blank to display asset details for all Sage 300
          programs.
    • To display details only for assets that have a particular status,
      select the required status from Status list. You can select Created, Pending, Error, or you can accept All, the default status.
    • To display details only for assets that were acquired within a certain period, enter the range of dates using the From Acquisition
      Date and To Acquisition Date fields.
  3. Click Go.  The program displays asset details that meet the specified criteria.
  4. Edit or delete asset details, as you require.  To delete a detail, you select it, and then press Delete on your keyboard. (You can also clear Created assets using the Clear Assets form, as described in the next section.)  You can edit most information for assets that have an Error status, but
    you cannot edit information for assets that have a Pending or Created
    status.  The information provided for each asset includes:
    • Status. Sage Fixed Assets Integration uses three statuses for assets:
      • Pending. Assets for which you need to create records in Sage Fixed Assets have a Pending status, providing the asset details do not contain an error.
      • Error. Assets for which the Create Assets program could not create a record have an Error status.  You must correct any errors in the asset details, change the asset status to Pending, and then run the Create Assets program again to create the record.
      • Created. Assets for which you have created records in Sage Fixed Assets have a Created status.
    • Errors. For assets that have an Error status, the program displays the number of errors that the Create Assets program encountered when attempting to create the asset record in Sage Fixed Assets.  To see a report of the errors for a particular asset, select the asset on the grid, and then click the Zoom button on the Errors column heading. The program displays a separate form that lists the errors you must correct before you can create the asset record in Sage Fixed Assets.
    • Application Source. The program displays the application where you originally recorded the purchase or internal use of each asset.
    • Database ID. This field shows the ID of the Sage 300 database.
      You cannot change the database ID, regardless of the asset status.
    • Sage Fixed Assets Database, Company/Organization, Template / Description / Quantity / Unit of Measure. These fields show entries specified when you entered the asset detail in a Sage 300 transaction. You can edit the fields if the asset has an Error status.
    • Acquisition Date. This field shows a date from the Sage 300
      transaction that recorded the asset detail. The acquisition date is:
      • The Document Date for an Accounts Payable invoice, including invoices for intercompany transactions.
      • The Receipt Date for a Purchase Orders receipt transaction.
      • The Date for an internal usage transaction
        • You can change the acquisition date for assets that have an Error status.
    • Asset Value. This field shows the value entered for the asset
      when you entered the asset detail in a Sage 300 transaction. The
      value includes allocated taxes (not recoverable or expensed taxes), and, if the asset was posted in Purchase Orders, any prorated or manually entered additional costs.  If the ledger uses multicurrency, the asset values are shown in both source and functional currency, along with the type of currency and the exchange rate, rate type, and rate date.  You can change the asset value for assets that have an Error status.
    • Date Asset Created / Sys. No. For assets that were successfully
      created in Sage Fixed Assets, Asset Inquiry also displays the date that the record was created and the identification (Sys.) number that Sage Fixed Assets has assigned to the asset.
  5. To print a listing of assets recorded in Sage 300 that have not been cleared from your Sage 300 database, click Print. The listing prints to your usual print destination.
  6. Click Close when you have finished reviewing asset details.