I/C Transaction Listing Report

Learn more

Printing Transaction Listings

Inventory Control Reports

Open Inventory Control > I/C Transactions > Transaction Listing.

Overview

Use the I/C Transaction Listing Report screen to generate transaction listings.

A transaction listing provides information about saved and/or posted transactions, including details about those transactions.

You can print the following types of transaction listings, one for each transaction type you can post in Inventory Control:

  • Receipts
  • Shipments
  • Internal usage
  • Adjustments
  • Transfers
  • Assemblies

When to Print

The timing and type of transaction listing you print depends on your transaction workflow:

  • If you enter and save transactions before posting them, you can print the Transaction Listing report showing all unposted transactions, review the report, and then posting the transactions.
  • After posting transactions, you can print the Transaction Listing report showing all posted transactions listings at the end of the day, and then compare the report with the source documents.

Information Printed on This Report

The top of the report includes the transaction type, document number range, transaction date range, status of transactions, whether optional fields and comments are included, and whether reprinted transactions are included.

The remainder of the report depends on the transaction type.

The report shows information about the overall receipt, including:

  • Receipt number, description, and reference.
  • Transaction status.
  • Receipt date, posting date, and year/period.
  • Vendor number and name (if an A/P vendor)
  • PO number
  • Any additional costs

The report shows information about each item received, including:

  • Item number and item description.
  • Inventory location.
  • Original quantity received and unit of measure.
  • Original unit cost and extended cost.
  • Quantity returned and total return cost.
  • Total adjusted cost.
  • Comments and optional fields (if selected for the report).

The report shows information about the overall shipment, including:

  • Shipment number, description, and reference.
  • Transaction status and type.
  • Ship date, posting date, and year/period.
  • Customer number (if an A/R customer).
  • Contact
  • Price list used

The report shows information about each item shipped, including:

  • Item number and item description.
  • Item category.
  • Inventory location.
  • Quantity shipped and unit of measure.
  • Price list
  • Unit price and extended price.
  • Unit cost and extended cost.

The report shows information about the overall internal usage transaction, including:

  • Internal usage number, description, and reference.
  • Transaction status.
  • Internal usage date, posting date, and year/period.
  • Used by

The report shows information about each item, including:

  • Item number and item description.
  • Item category.
  • Inventory location.
  • Quantity and unit of measure.
  • Unit cost and extended cost.
  • Usage account number and account description.

This report includes adjustments created using:

  • I/C Adjustments screen.
  • I/C Post Inventory Reconciliation screen (if you are including posted transactions).

For information about adjustments, see About Processing Adjustments.

The report shows information about the overall adjustment transaction, including:

  • Adjustment number, description, and reference.
  • Transaction status.
  • Adjustment date, posting date, and year/period.

The report shows information about each adjustment, including:

  • Item number and item description.
  • Adjustment type (Cost Increase, Cost Decrease, Quantity Increase, Quantity Decrease, Both Increase, Both Decrease).
  • Inventory location.
  • Bucket type (Offset Bucket, Specific Bucket, or Prorate if the adjustment was to a LIFO or FIFO item).
  • Document number and cost date.
  • Quantity, cost adjustment, and unit of measure.
  • Adjustment account number and account description.

The report shows the following information:

  • Assembly number, description, and reference.
  • Transaction type (whether an assembly or disassembly).
  • Assembly date, posting date, and year/period.
  • The original assembly (if disassembling a previous assembly).
  • Bill Of Material (BOM) number and type of item (master or component).
  • The build quantity for the bill of material used in the assembly.
  • The fixed and variable costs for the assembly.
  • The disassembly cost (if disassembling a previous assembly).

The report shows information about the overall transfer, including:

  • Document number
  • Transaction status
  • Document date, posting date, and year/period.
  • Transaction type.
  • From transfer number (if a transit receipt).
  • Description and reference.
  • Additional cost.
  • Proration method.
  • Expected arrival date.

The report shows information about each item transferred, including:

  • Item number and item description.
  • From inventory location, goods in transit location, and to location.
  • Requested quantity and unit of measure.
  • Manual proration and unit of measure.
  • Unit weight, extended weight, weight unit of measure, and weight conversion.
  • Unit cost and extended cost.
  • Comments and optional fields (if selected for the report).