Solution Properties
Solution ID:
200427112218656
Last Modified Date:
Tue Jul 21 13:55:20 UTC 2026
Taxonomy Path:
Case category//How do I...//processing
Author:
[email protected]
Explanation of stock transaction types
Description

Sage 50 Accounts includes several product transaction types that record the movements of products in and out of stock. You can view these in the product's activity window.

Only product records with an item type of Stock Item have product activity. Service Items and Non Stock Items don't have any activity. 

NOTE:

Not all transaction types are available in all variants of Sage 50 Accounts.

Cause
Resolution

Stock transaction types 

Transaction type and Description Details Effect on stock level

AI - Adjustment in

In AI posts when you use the Adjustment in option in Products and services.

NOTE:

The Stock take option also posts an AI if the Actual value entered is greater than the In Stock value.

 
▲

Increases
AO - Adjustment out

An AO posts when you use the Adjustment out option in Products and services.

NOTE:

The Stock take option also posts an AO if the Actual value entered is less than the In Stock value.

 
▼

Decreases

 
GI - Goods In
(Sage 50 Accounts Professional)

A GI transaction posts when you deliver a purchase order.
▲

Increases
GO - Goods Out A GO transaction posts when you  update a sales invoice to the ledgers, or, when you despatch a sales order.

NOTE:

A GO transaction increases the values in the Sales tab in the product record.

 
▼

Decreases
GR - Goods Returned A GR transaction posts when you update a sales credit note to the ledgers.

NOTE:

A GR transaction decreases the values in the Sales tab in the product record.

 
▲

Increases
MI - Movement In
(Sage 50 Accounts Plus and above)		 An MI transaction posts when you use the Stock Transfer option.

Use this option when there's a bill of materials (BOM) whereby one product consists of various other products.

To calculate the cost price for the MI, Sage 50 Accounts calculates the total cost price for every sub-component. It uses the first in first out (FIFO) cost price of the sub-component, not the cost price from the sub-component record.

NOTE:

An MI transaction always has at least one corresponding MO transaction on its sub-components.

 
▲

Increases
MO - Movement Out
(Sage 50 Accounts Plus and above)		 An MO transaction posts when you use  the Stock Transfer option.

Use this option when there’s a bill of materials (BOM) whereby one product consists of various other products.

NOTE:

An MO transaction always has a corresponding MI transaction on the product that it's a sub-component of.

 
▼

Decreases
DI - Damages In
(Sage 50 Accounts Plus and above)		 A DI transaction posts when you use the Returns option.

This represents damaged goods returned by the customer. It doesn't affect the quantity in stock because the goods are damaged or faulty.

NOTE:

 A DI transaction doesn't affect the values in the Sales tab of the product record.

 
►◄

No change
DO - Damages Out
(Sage 50 Accounts Plus and above)		 A DO transaction posts when you use the Returns option.

This represents damaged goods returned to your supplier. Because the goods are damaged or faulty, it's assumed the supplier will replace it and it doesn't affect the quantity in stock.

NOTE:

 A DO transaction doesn’t affect the values in the Sales tab of the product record.

 
►◄

No change
WO - Write Off
(Sage 50 Accounts Plus and above)		 A WO transaction posts when you use the  Returns option.

This represents goods that you write off because they're damaged or obsolete. A WO transaction decreases the quantity in stock.

NOTE:

A WO transaction doesn't affect the values in the Sales tab of the product record.

 
▼

Decreases

 

 

[BCB:19:UK - Sales message :ECB]



Steps to duplicate
Related Solutions