Report Update July 11, 2006

 

Note: This report is currently only available in POS.  A future release will make this report available in the Home Office.

Part Number Transactions Report

This is a new report designed to give you detailed transaction activity for any individual part number.  Transaction activity includes receiving,

adjustments, transfers, and sales. To see detailed activity for individual part numbers:

 

1.      In POS, go to your Reports Menu and select the Part Number Transactions Report.

 

         Enter the Start Date

         Enter the End Date

         Enter the Brand ID

         Enter the Part Number to be reviewed, press ENTER.  The part number will appear in the upper left hand portion of the report.

 

Information Detail

         All Individual Transaction Dates will appear in the first column

 

         The second column will show how the transaction affects the part number, either through an inventory transaction or sales transaction

 

         The third column, Reftype Reference, will refer to the transaction triggers for example, part number quantity affected by a sale or received with or without a Purchase Order.  Individual details for sales transactions will be shown after the part number reference.

 

         The fourth column, Pqty, shows the starting inventory quantity, before the individual transactions.  This quantity will always be the same as the ending quantity from the previous transaction.

 

         The fifth column shows, Qty shows both the Ending Part Quantity and the quantities of the individual sales transactions that resulted in the Ending Part Quantity

 

         The Final Column shows the extended cost for the individual sales transactions only

 

 

In the example below, the following information can be obtained.

 

         On 4/5/06, the starting inventory quantity of Part BGO 062-29 was 20.  Four of this item were sold on ticket number 11770 at a cost of $129.60 each.  After the sale the ending quantity is 16. (20 less 4)

         On 4/6/06, the starting inventory is the same as the previous day. (16) Two individual sales transactions changed the inventory.  Ticket Number 11822 contained two individual line items, each with a quantity of 2.  The first line item of 2 parts sold changed the inventory from 16 to 14, the second line item of 2 parts sold changed the inventory from 14 to 12.

 

         On 5/30/06, the quantity on hand of this part is 2.  I received 6 into inventory (without a PO) with brings my on-hand up to 8. 

 

         On 6/1/06, an additional 4 were received into inventory without a PO, bringing the quantity up to 12.

 

Receiving Cost is not reflected in this report.