Stock Status Report (ICR710)

Using Reports

Use this program to obtain a report of the status and valuation of all items in inventory. The user selects the cost (standard, average, last or manual) used to determine valuation.

$image\pinpurpl_shg.gif$ Serial/Lot Item Costing
You now have the ability to cost serial and lot items by the system cost (costing method for the module). The feature provides for GAAP compliance. For the FACTS SO, IC and MC modules, you can decide if the cost for serial and lot items will be averaged actual (as it has always operated in the past) or system cost (costing method for the module). The default setting for each Static Control F/M is A-Averaged Actual (same behavior as they have before the monthly is applied). Users who want to take advantage of this change will need to change the option to S-System Cost for each of the applicable modules. The net result of selecting S-System Cost is that serial/lot items will be costed like non-serial/lot items. The results of this program are affected by this selection.

Report information includes:

item number	selected cost
description	costing unit of measure
rank range information	extended cost
quantity on hand	item class totals
quantity on order	vendor totals
quantity backordered	warehouse totals
stocking unit of measure	report totals
seasonality codes	total number of items

An asterisk (*) indicates the on hand and committed quantities are insufficient to meet the committed and backordered requirements.

A Rank range can be set at the company level, alone, or, it can also be set at a warehouse level. When the rank is set at the company level, the rank information is displayed in the header of the report (and indicates what the type is, either ‘Percentage’ or ‘Hit Count’) and the range that makes up each of the 5 possible entries (A – E). When the warehouse level is set, the warehouse level rank over-rides the company level rank with its own rank values and type of hit count. The Warehouse Rank value only prints on the report when a rank range is specified at the warehouse level.

In the three formats, item and report totals and the total number of items listed are printed. If the print order selected is vendor, the report prints item class totals within vendor and vendor totals. If the print order selected is item class, the report prints vendor totals within item class and item class totals.

FACTS Report Formatter and Multiple Output Options

This report has access to the FACTS Report Formatter and Multiple Output option. The Multiple Output option also allows you to print to more than one output for each instance of a report. For example, a report can print to Excel, the viewer, and to a printer all in one print run. To access the multiple output feature simply choose the Multiple option from the Print Options screen. The FACTS Report Formatter allows you to expand your reporting capabilities beyond defining a printer (in Printer F/M). For the Stock Status Report, you can select Template-->Select from the menu bar to associate a system template with a custom layout to include bin location and weight. To access the FACTS Report Formatter, select Custom Report Layout--> Customize Report from the menu bar.

To access this program, choose Inventory Control-->Reports & Prints -->Stock Status Report.

Use the following fields to print a Stock Status Report:

1. Order

Enter whether to print in Item, Alpha, Vendor, Rank or Item Class order. Press Enter (CR) to default to Item.

2. Beginning [Order Choice]

Press Enter (CR) to default to the FIRST record on file, or you can enter specific information to narrow the focus of your report.

3. Ending [Order Choice]

Press Enter (CR) to default to the LAST record on file, or you can enter specific information to narrow the focus of your report.

4. Item Type

Enter the item type to print: Stocked items or Nonstocked items. Press Enter (CR) to default to SN, or both.

5. Vendor/Item Class

Enter the vendor or item class to print. Press F1 to default to ALL.

6. Item Description

Enter whether to print item description 1, 2, or Both from Item F/M. Press Enter (CR) to default to 1.

7. Smallest/Stocking

Enter whether you want to print items in the smallest unit of measure or in the default stocking. Due to precision, the count won’t include rounding when you print in the smallest unit of measure.

8. Warehouse

Enter up to 20 two-character warehouse codes side by side to print. Press Enter (CR) to default to the warehouse assigned to the terminal. Press F3 to default to ALL.

9. Include Zero Balance

Enter whether to include items with a zero balance. A caption will print at the top of the first page to indicate if zero balance items are not included. Press Enter (CR) to default to selected.

10. Activity

Enter whether to print A-active or I-inactive items based on the last activity (last purchase or sale) date. Press F1to default to ALL. and skip to field #12.

11. (In)Active As Of

This prompt only appears if either A-Active or I-inactive were selected in the previous prompt. Enter the cutoff date for activity (ref. 3). The date entered is the last date of activity (or inactivity). Items that have been active (or inactive) since this date are not included on the report.

12. Valuation Cost

Enter whether the cost to be used in calculating the item valuation is Standard, Average, Last, Manual or None. Press Enter (CR) to default to S.

13. Include Next Period

Indicate if next period activity should be included. Press Enter (CR) to default to selected.

14. Totals Only

Indicate if only totals should print for each item number on the report. Press Enter (CR) to default to N. Note that you can select to print totals only for Item, Alpha, or Vendor order. The order of the report remains Warehouse first, then Primary Vendor.

15. Serial/Lots

Indicate whether to include zero balance serial/lot. Press Enter (CR) to default to N.

16. Include Zero Balance (For Serial/Lot Items)

Indicate whether to print serial/lot items with on-hand balances of zero. Press Enter (CR) to default to N.

Stock Status Report (ICR710)

Using Reports

Report information includes:

Use the following fields to print a Stock Status Report:

See Also