Skip to content
logo Knowledgebase

Explanation of stock transaction types

Created on  | Last modified on 

Summary

The different stock transaction types in Sage 50 Accounts.

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.

Resolution

Stock transaction types

 NOTE: Not all transaction types are available in all variants. 

Transaction type and Description Details Effect on stock level

AI - Adjustment In

In AI posts when you use the Adjustment In option:

  • Products and services > Adjustment in

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:

  • Products and services > Adjustment out

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 and above)

A GI transaction posts when you deliver a purchase order:

  • Purchase orders > Receive deliveries / Received note / Amend deliveries
▲

Increases
GO - Goods Out A GO transaction posts when you update an invoice or when you despatch a sales order:
  • Invoices and credits > Update ledgers
  • Sales orders > Despatch orders / Despatch notes / Amend allocations

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

Decreases
GR - Goods Returned A GR transaction is posted when you update a sales credit note:
  • Invoices and credits > Update 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:
  • Products and services > Stock transfer

This option is used when there's a bill of materials (BOM) whereby one product consists of a number of other products.

To calculate the cost price for the MI, Sage Accounts calculates the total cost price for each and every sub-component. The first in first out (FIFO) cost price of the sub component is used and 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:
  • Products and services > Stock transfer

You use the Stock Transfer option when there is a bill of materials (BOM) whereby one product consists of a number of 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:
  • Products and services > Returns

This represents damaged goods returned by the customer. Because the goods are damaged or faulty, the quantity in stock isn't affected.

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:
  • Products and services > Returns

This represents damaged goods returned to your supplier. Because the goods are damaged or faulty, it's assumed they'll be replaced by the supplier and the quantity in stock is not affected.

NOTE: A DO transaction does not 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:
  • Products and services > Returns

This represents goods that are written 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

 

 

Upgrade your licence

Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.

Leave your details

Image