Product Transaction Activity Report ranges and options

Ranges

For more information, see Report ranges.

Options

Print (A)ctive, (I)nactive, or (B)oth?

Specify Active to print only active transactions.

Specify Inactive to print only inactive transactions.

Specify Both to print both transaction types.

(D)etail, (P)roduct, or (W)arehouse Totals?

Specify Detail to print detailed history transactions, product totals, and warehouse totals

Specify Product to print product totals and warehouse totals without the detailed transactions.

Specify Warehouse to print only the warehouse totals.

Include OE Transactions?

Sales Entry Invoice Processing Report creates Inventory Control invoice, return in, stock adjustments, and unavailable history transactions. Specify Yes to include these transactions.

PO Transactions?

Purchase Receipt of Inventory Entry creates Inventory Control receipt, return out, stock adjustments, and unavailable history transactions. Specify Yes to include these transactions.

IC Transactions?

Product Unavailable Inventory Entry and Product Adjustment Entry create all transaction types. Specify Yes to include these transactions.

WT Transactions?

Transfer Shipping Feedback Entry and Transfer Receipt of Inventory Entry create Inventory Control invoices, receipts, returns in, returns out, stock adjustments, and unavailable history transactions. Specify Yes to include these transactions.

KP Transactions?

KP Work Order Center Entry creates invoice and receipt history transactions. Specify Yes to include these transactions.

AP Transactions?

Vendor Invoice Center Entry creates Accounts Payable history transactions. Specify Yes to include these transactions.

VA Transactions?

VA Order Entry creates Value Add history transactions. Specify Yes to include these transactions.

PD Transactions?

Price/Discounting creates history transactions. Specify Yes to include these transactions.

Print Manual Balance Changes?

Select Yes to print the balance changes from Product Warehouse Product Setup and Product Warehouse Inventory Audit Report after the product totals.

Note: Manual balance changes are not printed if you specify Warehouse for the (D)etail, (P)roduct, or (W)hse Totals option.

Print references?

Select Yes to print the transaction references after each of the detail history transactions. You must also specify Detail for the (D)etail, (P)roduct, or (W)hse Totals option.

Include Cap(A)dd, WO(D)isc, (B)oth in Cost

Specify A to include capitalized addons.

Specify D to include whole order discounts.

Specify B to include both.

Print Trans for (D)ist, (C)ust, or (B)oth

Use this option for Storeroom-managed warehouses. Storeroom warehouses are defined as a Managed Warehouse in Product Warehouse Description Setup-Storeroom. The inventory type of C or D is printed on each transaction on the report between the transaction type and the journal number.

Specify D to print Inventory Control transactions for distributor-owned inventory from the internal ICET table.

Specify C to print transactions for customer-owned inventory from the ICETC table.

Specify B to print both customer- and distributor-owned transactions from the ICET and ICETC tables. ICET and ICETC are updated during Sales Entry Invoice Processing Report when a sales order line with an inventory type of D or C is processed.

Note: If you are printing this report for a range of warehouses, and any selected warehouse is not Storeroom-managed, the message Whse xxxx is not Storeroom Managed; No Customer Inventory Transactions Exist is printed on the report.

Print Transaction Notes

Select Yes to print any notes attached to IC transaction records where the Print Note option was selected on the Notes context widget.

Note: If the option Print Trans for [D]ist, [C]ust or [B]oth is set to display customer-owned transactions, notes are not included. IC transaction notes are not stored for customer-owned inventory transactions.