Item Transaction Report

Overview

The Transaction report prints a summary of each inventory transaction and there are checkboxes so you may choose which transactions you want to be printed. All transactions for items are printed except for those types of transactions that are to be excluded from the report. Other criteria allow selection of which warehouse location, item category, date range and item number range for the transactions to be printed. 

Detail

     This report is useful to view unusual transactions that are occurring for inventory items. The unit cost on the report is normally the cost of the item used during the transaction. A drop down list allows use of the item's current cost, standard cost, last cost, or the current calculated cost of the item.

INV>Reports>Inventory Transaction Report
  • Starting and Ending Item – You can choose an item or range of items to report on

  • Starting and Ending Warehouse - You can choose a warehouse or range of warehouses to look in for reporting.

  • Starting and Ending category – This report can be pulled by a items category or range there of

  • Start and End Date – the time period that you would like to check inventory usage in.

  • User ID –

  • Cost By – The report will display the costs of items that are in the report this drop down box. This will default to the cost of the items when the actual transaction occurred but can be changed to standard, last, or average.

There are check boxes for different types of transactions that you can exclude from the report they include:

  • Shipped orders

  • PO receipts

  • Transfers

  • Physical Counts

  • Project Issues

  • Project Receipts


Each transactions excluded allows the report to be used in a different way. 


Â