View stock item history

How to

View stock item history

Open: Stock Control > Enquiries > View Stock Item History.

1. Select the stock item Code or Name.

   Tip: You can also find a stock item using search categories (if you have set these up), by selecting the search icon.

2. A list of transactions are displayed for your selected stock item, in order of the date they were recorded.

   • Use the Current History tab to view current transactions.

   • Select the Archived History tab to view historical archived transactions.

3. You can choose what to display in the transaction list.

   • Select the transaction Type to show transactions by their type, such as All Goods In or All Goods Out.

     For a list of transaction types, see Transaction types.

   • Select the Warehouse to show transactions for a particular location, .

   • To show transactions in a date range, enter the from and to dates.

   • Select Advanced Selection to filter the list by Movement type, Account type or Analysis codes.

   • Select Find to search for an item in the list.

4. Select Show details to view more information about the selected transaction, such as prices, value, analysis code values, and the Sage 200 user.

5. For a batch or serial numbered item, select Serial No Details or Batch No Details to view the item's batch or serial numbers, and Sell By and Use By dates if applicable.

6. Select Print to print the movement history details.

Useful info

About stock item history

A stock item history is available if the stock item is set to maintain a movement history.

You can view current and archived transactions for the stock item.

The transactions are displayed in chronological order based on the date they were recorded. The information provided covers the movement type, quantity, location and references used.

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 allocations: Stock allocations for the components of a BOM.

• 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 In (No Price) - 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 Out (No Price) - 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.