Inventory Transaction Types (Managing Inventory)

Parts Dashboard tracks inventory using a double-entry system. This means that one record is created for the “From” side of a transaction, and inventory is removed from here, and another record is created for the “To” side and inventory is added here. There is an exception, where only one record is created with no “From” or “To” direction, and that is determined in the Inventory Transaction Types form.

From the Inventory Transaction Types, there are two parameters that influence the state of inventory:

Transaction Complexity – this refers to how many records are created for any one transaction. A transaction is either Single- or Double-Sided. The preference is to have a double-sided transaction as this will allow you to record where material came from and where it went to. If using just a single-sided transaction then you only see the effect of the transaction, with no directionality. The ideal use-case for a single-sided transaction is an adjustment, either to an order, or to existing inventory, or to a previous BOM operation.

Effect On Stock – For single-sided transactions, this determines if the stock is added or removed from inventory. It is not relevant to double-sided transactions as the “From” side will have inventory removed, and the “To” side will have inventory added to it.

Transaction TypeDescriptionTransaction ComplexityAffect On Stock
Built StockProduction of an itemSingleAdds
Consumed StockStock used during production of another itemSingleRemoves
Inventory AdjustmentUse +ve to increase inventory, -ve to decreaseSingleAdds
Received StockStock has been received into inventory from another companyDouble
Scrapped StockScrapped stock will be deleted from inventoryDouble
Sold StockSold stock item to some other entityDouble
MovementTransfer of material between two locations. Can be internal or external.Double
Ordered StockOrdered stock from another companySingleAdds
Order AdjustmentAdjust quantity on an existing order from another company. Use +ve to increase quantity, -ve to decreaseSingleAdds


Here’s an example of the result of a single-sided transaction, in this case in Inventory Adjustment to remove 2 pieces of stock:

Inventory Adjustment


Here’s an example of the result of a double-sided transaction, in this case Scrapped Stock from the QC Hold location into the Scrap location:

Scrapped stock