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, click Inventory Control>End of Period>Item Activity Report.
Click field descriptions for information on each field.
See also
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