Stock item history

Find this screen

Open: Stock Control > Enquiries > Stock Item History.

How to

View stock item history

Open: Stock Control > Enquiries > Stock Item History.

Select the stock item Code.
A list of transactions are displayed in the Current History section, in order of the date they were recorded.
You can choose what to display in the transaction list.
- To hide stock adjustment and stock allocation transactions from the list, select Exclude adjustments.
- To filter the list by transaction type, select Item history selection, then select the transaction Type.
  
  For a list of transaction types, see Transaction types.
- To filter the transaction list by account type, select Item history selection, then select Account Type to view Customer, Supplier, or Internal transactions. You can select an individual customer and supplier.
- To filter the transaction list by analysis code, select Item history selection, then select or enter the Value for the appropriate analysis code.
  
  Note: If you haven't used any analysis codes with the transaction, then nothing will be displayed for the Value.
Tips for using the list
- Search for items by typing in the box at the top of a column.
- Use filters to show items that contain particular text or a range of values.
  - To filter a column, select the filter button in the column heading, or select the filter button from the menu in the column header.
  - If you want to filter by a date, use the filter button from the menu in the column header.
- Sort the list by selecting the column heading. Select the heading once to sort in ascending order, and select it again to sort in descending order.
- To add or remove columns, select the menu button in the column header, then select the columns button.
- To pin a column, select the menu button in the column header, then select Pin Column and choose the column.
- To move a column, select and hold the column heading, then drag it to a new position.
Note: You'll not see the menu button in the column header until you either: hover over the column heading with a mouse, press and hold the column heading on a touch screen, or navigate to the column heading using a keyboard Tab key (use Ctrl + Enter to open the menu).
Select a transaction to see more information, displayed in the Details and Analysis Codes tabs.

Useful info

Transaction types

All Goods in: Goods received from purchase orders. Sales returns recorded from sales orders. Stock recorded from adding stock, stocktake adjustments, internal returns, stock transfers, stock returns from suppliers, stock opening balances, and BOM builds.
All Goods out: Goods despatched using sales orders, and goods returned to suppliers (that are not required in purchase orders). Stock recorded from stock internal issues, stocktake adjustments, stock transfers, stock returns to suppliers, customer FOC issues, write offs, and BOM issues.
All Allocations: Allocations assigned to sales orders, and current and issued allocations recorded using Stock Control.
All Issues: Goods issued for an internal area (using Stock Control), stock return to supplier, customer FOC issue, and BOM issues.
Internal issues: Goods issued only for an internal area (using Stock Control).
Internal returns: Goods received from internal returns.
BOM issues: Stock issues for the components of a BOM.
BOM build: Stock of the built BOM item.
Customer FOC issues: Goods issued free of charge to a customer (using Stock Control).
Returns to suppliers: Goods returned to a supplier, that you want replaced or repaired (recorded in Stock Control).
Returns from suppliers: Goods returned from a supplier.
Stock additions: Goods that have been discovered and added to stock (using Stock Control).
Write offs: Stock values that are written off (using Stock Control).
Transfers: Stock transfers between different locations (warehouses and bins).
Stocktake adjustments: Stock updates as a result of completing a stocktake (using Stock Control).
Opening balances: Opening balances for an item recorded in Stock Control.

Movement types

The Movement Type tells you how the stock item was moved in or out of Sage 200.

Stock movement types for different transactions
Transactions	Stock level updated (+/-)	Free Stock updated (+/-)	Movement Type	Description
Purchase order
POP order			On POP Order	Added to a purchase order.
POP Receive order	+	+	On POP Order Adjustment In - POP	Stock received. For more details about In (No Price) - POP movements, see What is an "In (No Price) - POP" movement type?
POP Despatch return	-	-	Out - POP	Purchase return despatched.
Sales order
SOP order		-	Allocation - Customer	Allocated to sales order.
SOP Amend Allocation		+ / -	Allocation - Adjustment	Stock allocated to a sales order was manually changed.
SOP Despatch Order	-	-	Allocation - Adjustment Out - SOP	Sales order despatched.
SOP Receive Return	+	+	In - SOP	Sales return received.
Add Stock
Add stock	+	+	In - Unknown Source	Item added using the Add Stock screen.
Internal areas
Internal Issue Issue Allocation	-	-	Out - Internal	Stock is moved to an internal area.
Internal Allocation		-	Allocation - Internal	Stock is reserved for an internal area. Free stock reduced.
Amend Allocation		+ / -	Allocation - Adjustment	The number of items reserved is changed. Free stock is updated.
Internal Return	+	+	In - Internal Return	Stock previously moved to an internal areas is returned.
Return goods to supplier for repair
Return To Supplier	-		Out - Return	Stock is moved from the current warehouse to the Returns warehouse.
Return from Supplier	+		In - Completed Return	Stock retuned from supplier after being repaired. It's moved from the Returns warehouse to warehouse specified.
Issue to customer free of charge (FOC)
Customer FOC Issue Allocation	-		Out - FOC	Stock sent to a customer free of charge.
Customer Allocation		-	Allocation - Customer	Stock is reserved for a customer. Free stock is reduced.
Amend Allocations		+ / -	Allocation - Adjustment	The number of items reserved is changed. Free stock is updated.
Transfer stock
Transfer stock	+		In - Transfer	Stock is moved between warehouses.
	-		Out - Transfer	Stock is moved between warehouses.
Write Off stock
Write Off Stock	-		Out - Write Off	Stock is written off.
Stocktake
Complete Stocktake	+		In - Stocktake	Stock level increased after a stocktake.
	-		Out - Stocktake	Stock level decreased after a stocktake.
Opening balances
Opening Balances at Locations	+	+	Opening balance	Stock level opening balance.
Bill of Materials
Record Built item	+	+	BOM Build	Increases the stock of the built item.
	-	-	BOM issue	Reduces the stock for the components of a BOM.

Questions

What is an "In (No Price) - POP" movement type?

Transaction movements labelled as In (No Price) – POP are created when you receive goods for a purchase order before the price has been confirmed and invoiced. The No Price transaction is used to record that the goods have been received, but the final cost price is not known.

At this stage, when you see the In (No Price) – POP transaction:

Sage 200 records the stock movement (goods received).
No cost value is assigned to the stock item, as the purchase invoice has not been processed.

After you enter the purchase invoice, a new transaction is recorded:

The new transaction will be labelled as In – POP.
Sage 200 applies the correct cost price to the stock based on the invoice value.