Report As-Is Product Details
(As-Is Inventory)
Access
This report displays as-is goods in inventory along with each item’s
-
warehouse and storage location
-
Reason code (that is, why it was moved to As-Is)
-
date it was added to As-Is inventory
In the "costed" version of this report (that is, if you select Unit Cost at the Show Cost/Selling Price field), the unit cost of each item appears along with totals for the selected sorting criteria. You can sort on three levels using any of the following criteria:
-
Vendor
-
Group
-
Category
-
Storage Location
-
Reason Code
The output of this report may be affected by Regional Processing restrictions.
To include landed costs in the report, set the Landed Cost Distribution field in the Costing Control Settings to "Allocate Upon Receipt".
This process determines its costing method (either average or exact costing) based on the General Ledger Postings field in the Costing Control Settings.
The run-time options for this report are:
Region
LocationEnter the locations you want to include in this report. If you know the code of the location, enter it directly. If you click on the Arrow, you can choose a location from the list that appears. If you select Multiple Locations from the list, you access the Multiple Locations Selection Window, from which you can choose one or more locations. You can also access the Multiple Locations Selection window if you click on the Action button. If you click on the Search button in the Multiple Locations Selection Window, you access the Multiple Selection Lookup Window. Use this window to select all locations (that is, all locations available to you) by clicking on Select All.
At this and any other Location field, the locations you see (that is, the list of locations available to you) may be affected by Regional Processing restrictions.
ProductEnter the codes of the products you want to include in this report. If you click on the Search button, you access the Search for a Product window from which you can create a list of products for your report. If you click on the Action button, you access the Multiple Product Selection Window, from which can select one or more products from a list. If you leave the field blank, you select all products.
GroupThis field is used to indicate the product group or groups to be included in this report. One, multiple, or All groups may be selected. To report on a single group select a specific group code at this field. To report on All Groups, leave this field blank. To report on multiple groups, use the Multiple Product Group Selection screen (available from Actions) to select the groups for this report.
CategoryThis field is used to indicate the category or categories to be included in this report. One, multiple, or All categories may be selected. To report on a single category select a specific category code at this field. To report on All Categories, leave this field blank. To report on multiple categories, use the Multiple Product Category Selection screen (available from Actions) to select the categories for this report.
VendorThis field is used to indicate the vendor or vendors to be included in this report. One, multiple, or All vendors may be selected. To report on a single vendor select a specific Vendor code at this field. To report on All Vendors, leave this field blank. To report on multiple vendors, use the Multiple Vendor Selection screen (available from Actions) to select the vendors for this report.
Reason CodesThis field is used to indicate the reason code or reason codes to be included in this report. One, multiple, or All reason codes may be selected. To report on a single reason code select a specific reason code at this field. To report on All Reasons, leave this field blank. To report on multiple reason codes, use the Multiple Reason Codes Selection screen (available from Actions) to select the reason codes for this report.
Include or Exclude CodesIf one or multiple reason codes were selected at the Reason Codes field this field will be available. Select Include to include the reason code(s) specified in this report. Select Exclude to exclude the reason code(s) specified from this report.
Inventory TypeSelect the type of inventory to be reported. Select All Inventory for both retail and service parts products; select Retail Inventory to report on retail products only; select Parts Inventory to report on service parts products only.
Show Cost/Selling Price
Piece CommentsSelect this option to print piece comments entered during Inventory Adjustments entry.
This field is available only when you select Screen or Printer in your output settings.
Primary SortSelect Vendor (V), Category (C), Group (G), Storage Location (S), or Reason Code (R) to indicate the item by which the report data is to be sorted in the Primary (first) sort.
Secondary SortSelect Vendor (V), Category (C), Group (G), Storage Location (S), or Reason Code (R) to indicate the item by which the report data is to be sorted in the Secondary (second) sort. If no secondary sort is desired, choose None Selected.
Tertiary SortSelect Vendor (V), Category (C), Group (G), Storage Location (S), or Reason Code (R) to indicate the item by which the report data is to be sorted in the Tertiary (third) sort. If no tertiary sort is desired, choose None Selected.
Send Output toThe output destination of the report displays. To change the output destination, click on the Actions button and select Output Settings.
Export PathIf you select either the Personal Report Viewer (PRV), Excel Export, or ASCII Export, this field displays the pre-set computer drive and folder location to which the system exports the report data. You cannot edit the export path using this process.
Once the run-time options have been selected, choose Run to produce the report.