Item Activity Report (ICR810)

Using Reports

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, movement class, 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.

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.

Use the following fields to print an Item Activity Report:

1. Order

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

2. Beginning Order Choice

Select the beginning order choice to print. Press Enter (CR) or $image\ex_allft_shg.gif$ to default to the FIRST. Press F2 or $image\find_shg.gif$ to search.

3. Ending Order Choice

Select the ending order choice to print. Press Enter (CR) or $image\ex_allrt_shg.gif$ to default to the LAST. Press F2 or $image\find_shg.gif$ to search.

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 or $image\all_shg.gif$ to default to ALL. Press F2 or $image\find_shg.gif$ to search.

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 or $image\all_shg.gif$ to default to ALL. Press F2 or $image\find_shg.gif$ to search.

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.

Item Activity Report (ICR810)

Using Reports

Use the following fields to print an Item Activity Report:

See Also

Using Reports