Item Inquiry (ICI610)—Activity View

How To

The Activity view displays current period item activity from the warehouse/item file including the warehouse, beginning on hand, receipts, production, adjustments, sales, transfer in/out, current on-hand, month-to-date, year-to-date, and prior year sales units and dollars, last sale date, lowest on-hand for the period and the 12 period average. The out-of-balance (*) quantity is the difference between the actual on-hand and the calculated on hand. The out-of-balance is caused by the fact that many transactions update the actual on-hand and provide an after-the-fact audit trail which later updates the sales or the adjustments figures listed on this screen. During normal processing in a period, many items are out-of-balance. All items should be in balance however just prior to the end of the period after all registers have been run and updated.

Items Detail Window

In the view area, highlight the line that you want more detail on and choose the Line Detail button, or you can double click the icon at the beginning of that line. The Item Detail window provides information on quantity information for Receipts, Production, Adjustments, Sales, Transfers in and out, as well as Beginning and current on-hand, and out of balance details.