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 Type||Description||Transaction Complexity||Affect On Stock|
|Built Stock||Production of an item||Single||Adds|
|Consumed Stock||Stock used during production of another item||Single||Removes|
|Inventory Adjustment||Use +ve to increase inventory, -ve to decrease||Single||Adds|
|Received Stock||Stock has been received into inventory from another company||Double|
|Scrapped Stock||Scrapped stock will be deleted from inventory||Double|
|Sold Stock||Sold stock item to some other entity||Double|
|Movement||Transfer of material between two locations. Can be internal or external.||Double|
|Ordered Stock||Ordered stock from another company||Single||Adds|
|Order Adjustment||Adjust quantity on an existing order from another company. Use +ve to increase quantity, -ve to decrease||Single||Adds|
Here’s an example of the result of a single-sided transaction, in this case in Inventory Adjustment to remove 2 pieces of stock:
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: