Stock history data set

The stock history data set contains one row for every item every transaction that affects stock levels.  This data set is the best data set for reports that require data from multiple kinds of transactions, for example purchase shipments and builds, or require the exact historical records resulting in current stock levels.

Important primary columns available on this data set:

• Stock history: Row sequence number A unique sequential number for each row in the data set.  The numbers are assigned in the sequence that transactions are applied when calculating stock levels: first by record date and then by transaction commit timestamp for transactions with the same record date.
• Stock history: Transaction type The type of transaction for this row.  One of Sales shipment, Purchase Shipment, Return shipment,Transfer, Stock change or take, or Build.
• Stock history: Transaction update type Some transaction types have multiple status changes that result in stock changes, for example a Build is first Started and then Completed.  This column indicates the specific status change resulting in the row.  One of Sales shipment packed, Sales shipment packed transfer, Sales shipment packed shipped, Sales shipment unpacked, Sales shipment shipped, Transfer shipment shipped, Transfer shipment received, Purchase shipment received, Return shipment received, Quick stock transfer, Stock change or take, Build consume started, Build consume completed, Build produce completed.
• Stock history: Stock type Some transactions result in stock going into a status where it is not included in the main quantity on hand numbers.  For example, transfer order shipments are first shipped, at which point the stock is move to the In transit state, and then is received, as which point the stock is moved back into the On hand state.  The Stock type column indicates what the update in the row is applied to.  For example, when a transfer order is shipped, each item in the transfer creates two rows in the stock history report: one to remove the stock from the source sublocation and one to add the stock to the In transit state.  One of: In stock, In transit, Packed, or WIP.
• Stock history: Record date The record date depends on the specific transaction: it is the receive date for purchase shipments, the ship date for sale shipments, the commit date for stock changes, etc.
• Stock history: Transaction commit timestamp The exact date and time the transaction was committed to the Finale Inventory database.  For transactions entered on the scanner, the timestamp is based on when the data is synced not when it is scanned.
• Stock history: Transaction commit user The name of the user that was logged in when the transaction was committed to the Finale Inventory database.  For transactions entered on the scanner, the user is based on who is logged in when the data is synced not who is logged in when it is scanned.
• Stock history: Units The number of units for the row.  This will be the quantity from the transaction unless the transaction has a packing.  If there is packing, then the quantity will be multiplied by the number of units in the packing to get the number of units in the transaction. 
• Stock history: Average cost per unit The average cost for the product at the time of the transaction.  It is very important to not confuse this column with the Product: Average cost column which is also available on the dataset.  The Product: Average cost column will show the current average cost at the time the report is run.  Generally reports using the stock history data set will want historical cost data and should use Stock history: Average cost per unit.
• Stock history: Transaction cost subtotal The value of the stock transaction.  For sale shipment, return shipment, transfer, and stock change or take transactions this will be the quantity multiplied by the average cost at the time of the transaction.  If the average cost is unknown because no previous transaction established the average cost, then the value will be zero.  For purchase shipments this will most often be the price of the product on the purchase order multiplied by the quantity in the shipment.  The exception is that if the previous average cost was unknown, then the value will be the price of the product on the purchase order multiplied by the sum of the quantity in the shipment and the quantity on hand at the time of the transaction.  This exception is required so that after the transaction is applied the average cost will be the price on the purchase order.
• Stock history: Transaction cost per unit The value is the Stock history: transaction cost subtotal divided by the Stock history: Units.  This will be the same as the Stock history: Average cost per unit, except for purchase shipments and builds which can establish a new average cost.
• Stock history: Transaction description A brief description of the transaction for the row.  For example, for a sale shipment this will just have the order id of the related sale order.
• Stock history: Transaction details A longer description of the transaction for the row.  For example, for a sale shipment this will have the customer and origin of the related sale order and also the tracking number for the sale shipment.
• Product: * All the primary columns from the product data set are available for the product related to the row.
• Shipment for stock history: * All the primary columns from the shipment data set are available.  If the row relates to a sale shipment, purchase shipment, transfer shipment, or return shipment then the value is for the related shipment, otherwise it is blank.
• Shipment order for stock history: * All the primary columns from order data set are available.  If the row relates to a sale shipment or purchase shipment, then the value is for the related shipment, otherwise it is blank.
• Build for stock history: * All the primary columns from build data set are available.  If the row relates to a build, then the value is for the related build, otherwise it is blank.
• Variance for stock history: * All the primary columns from variance data set are available.  If the row relates to a stock change or take, then the value is for the related stock change or take, otherwise it is blank.