Open topic with navigation

> Product and projects / Products / Records / To view product activity

Product Record Activity

This shows all of the stock transactions on this product record.

Find out more about how to enter information in:

Details Memo BOM Sales Graph Activity Discount Web

To filter the transactions which appear, from the Show drop-down list, choose the criteria you require. The following information appears in the Activity:

Product Code

The product code is shown here.

Description

The product description from the Details tab appears here.

Cat Number

The category number from the Details tab appears here.

Category Name

This shows the category name.

Type

The following transaction types appear:

AI = Adjustment In
AO = Adjustment Out
MI = Movement In - product transfers only
MO = Movement Out - product transfers only
GR = Goods Returned - using credit notes
GO = Goods Out - using sales orders and product invoices
GI = Goods In - using purchase orders
DI = Damages In
DO = Damages Out
WO = Write Off

Date

This is the date entered for the product transaction when it was posted.

Ref

This is the reference you gave to the transaction when it was posted.

Details

This is the details or description text that was entered at the time of posting to identify the transaction.

Project Ref

Appears if Enable Project Costing is selected in Settings > Company Preferences > Parameters.

Shows which project the transaction is associated with.

Cost Code

Appears if Enable Project Costing is selected in Settings > Company Preferences > Parameters.

Shows the cost code that has been used on the transaction.

Qty In

Shows the amount of product that was recorded into stock.

Qty Out

Shows the amount of product that was recorded out of stock.

Qty Used

This shows the amount stock that has been used or sold from this adjustment in. It helps you understand the cost price of the stock as the software uses First In First Out (FIFO).

Cost Price

If the transaction line refers to an:

AI - Adjustment In
GI - Goods In
GR - Goods Returned
MI - Movement In
DI - Damages In

this shows the cost price.

Sales Price

If the transaction line refers to a GO (Goods Out), this shows the sales price.

Quantity On Order
Accounts Professional only

This is the quantity of the product which has been ordered and placed on order using the Purchase Order option but has not yet been delivered.

Quantity Allocated
Accounts Professional only

Stock that has been set aside for sales orders or projects.

Quantity In Stock

The current quantity in stock for the product - it includes allocated stock.

Quantity Available
Accounts Professional only

This is the quantity in stock less the quantity allocated.

To review Ask Sage, Business Advice and Health and Safety advice, go here. All contact details for Sage are available from here.

Go to top