Surplus Stock Report (ICR715) field descriptions

Using reports

Use these fields to print a Surplus Stock Report.

1. Order

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

2. Beginning [Order Choice]

Press Enter 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 to default to the LAST record on file, or you can enter specific information to narrow the focus of your report.  

4. Surplus Stock

Specify the type of surplus stock for the report. Options include: Long Term / Short Term / All.

When shown, the surplus value is the total of long- and or short-term surplus. This is defined as the quantity “over” the long and or short-term surplus point. If reporting short term surplus (and long term surplus point exists greater than short term) and both short and long term stock exists only the short term stock will be shown. If reporting long term stock (and short term surplus exists less than long term stock) then only that stock which is over the long term surplus will be shown. Reporting “Both” long and short term surplus shows the total surplus.

5. Item Detail

Select an output option: Summary, Detail or Detail with Transactions.

6. Purchasing Line

Specify a purchasing line to limit the report to the items included on the line in Purchase Line Entry (ICE920).

7. Vendor/Item Class

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

8. Buyer

Specify a buyer code to limit the report output by buyer.

9. Warehouse

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

10. Minimum Value

Select $ or % and specify the minimum amount. When $ is selected, the minimum value compared is against the ‘surplus cost’; when % is selected, the minimum value compared is against the “on hand stock percent” the surplus represents.

The Minimum Value selection output only lines with surplus ($ or %) >= minimum value. Items less than the minimum value are omitted from the report output.

11. Include Surplus Point

Indicate whether to include the item’s surplus point (short/long/both) as determined by Surplus prompt. The report out includes 1 column for Short- or Long-term surplus or 2 columns when Both is selected.

12. Include Cost

Indicate whether to include cost information in the report. Press Enter to default to selected.

13. Customers Sold To

Indicate whether to include listing of all customers an item was sold to.

14. Vendors Purchased From

Indicate whether to include all vendors an item was purchased from.

15. Item Description

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

16. Smallest/Stocking

Specify 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.

17. RestockingType

Specify whether to print restocking type Order/line point and/or Min/Max. Press F1 to default to ALL.

See also

Selecting existing templates

Creating system templates

Editing the order, range and properties stored in templates

Setting printer properties in templates

Using print options in reports

Setting a default printer using templates topics

Using print options

Using report templates

Viewing reports on screen (using the viewer)
Register formats and procedures

Reports and Prints Menu Options

Using reports