Use this program to print a report listing activity for each item for the current inventory period. You can run this report during the period as many times as necessary, but make sure you run it before you run the End-of-Period Update.
Report information includes: warehouse, item number, item description, rank range information, season code, period beginning quantity, quantity received, quantity produced, quantity transferred, quantity adjusted, quantity sold, and actual on hand quantity.
Item activity is grouped according to receipts, production (manufacturing), transfers, adjustments and sales.
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.
The calculated ending balance equals the period beginning quantity plus receipts plus produced plus adjustments plus transfers in minus transfers out minus sales.
Throughout the period, the calculated ending balance may not equal the actual on hand because in most cases the actual on-hand quantities are updated immediately, whereas the calculated quantities (i.e., sales) are not updated until the register (i.e., Daily Sales Register) is updated. At the end of the period after all registers have been updated, the two quantities should be the same.
To access this program, choose Inventory Control-->End of Period -->Item Activity 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
Select the beginning order choice to print.
3. Ending Order Choice
Select the ending order choice to print.
4. Item Type
Enter the item type to print: Stocked items or Nonstocked items. Press Enter (CR) to default to SN.
5. Vendor/Item Class
Enter the vendor (or item class if vendor selected in field #1) for which to print. The entry must be a valid vendor (or item class). Press F3 to default to ALL.
6. Item Description
Enter whether to print item description 1, 2, or Both from Item F/M, or Neither. Press Enter (CR) to default to 1.
7. 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
8. Include Zero Activity
Indicate whether to include items with zero net activity on the report. If N is entered here, only items that had activity are listed. If you select this checkbox, items that had zero net activity at End-of-Period are also listed. For example, five of item I101 were shipped, but five were also received into the warehouse - the net activity would then be zero even though there was activity on the item. Press Enter (CR) to default to selected.
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
Viewing reports on screen (using the viewer)
Register formats and procedures