Master Records > Inventory > Inventory Reports

There are various costing methods available in the Inventory Control module. One of these costing methods is the Specific ID costing method. Specific ID cost method assumes that the actual cost of individual units of inventory items can be determined through specific identification like serial numbers assigned to each inventory item unit.

The Specific ID Item Listing function allows you to generate a report that shows inventory items using the Specific ID cost method. This report is useful for reviewing the values of inventory items using specific ID inventory valuation.

To generate the Specific ID Item Listing report, perform the following procedures:

1.Access the Specific ID Item Listing function from the Cost Listings group under the Reports main menu in the Inventory Control module.

2.Click the List box button next to the Configuration field; then, select the report configuration that you want to use.

3.Select the report sorting option by clicking the List box button next to the Sort By field.

4.In the Layout field, click the List box button to select the report layout you want to use in generating the report.

5.In the Report Configuration area, define the desired report filters. You may mark the Individual checkbox if you want to generate the report for a single record and enter the appropriate value in the adjacent field; otherwise, select in the Filters area the desired criteria in generating the report.

6.Mark any or all of the following checkboxes, if applicable:

oExclude Unassigned Serial #'s

Choose this option if you want to include in the report only those inventory items already assigned with serial numbers.

oShow Serial #

Choose this option if you want to display on the report the serial numbers assigned to the inventory items.

oShow Lot #

Choose this option if you want to display on the report the lot numbers assigned to the inventory items.

oShow Kit #

Choose this option if you want to display on the report the kit numbers assigned to the kit inventory items.

oShow Specification

Choose this option if you want to include in the report the specifications assigned to the inventory items using Specific ID cost method.

7.Select which inventory items to include in the report:

•All Selected Items

•Items Used in Invoices/Sales Orders

•Items Used in Purchase Orders

•Items Used in Work Orders

Note: To generate a report on inventory items designated for use in customer invoices, sales orders, purchase orders and work orders, you must activate the corresponding module..

8.Choose the items you want to include in the report, depending upon the status:

•Active and Inactive Items

•Active Items Only

•Inactive Items Only

9.Click the Preview or Print button to preview or print the report. Click the Configure tab to return to the report configuration page.

The Specific ID Item Listing function also provides you with the flexibility to perform the following:

•Set up user-defined report macro

•Set up user-defined sort option

•Set up user-defined report layout

•Include notes in the printed report

•Export the report to various supported file formats

•Send the report as attachment to an email

•Include time and printed by information

•Drill-down on certain fields in the report:

oItem #

AccountMate displays the Item Profile when you double-click an item number in the report.

Specific ID Item Listing

Specific ID Item Listing

See Also