Viewing Stock Transactions
Account > Stock > [Search] > {double click on a Stock item} > (Transactions)
(Understanding this Path above)
The Transactions tab contains a list of transactions for a particular stock item. Transactions include:
- Creditors Invoice
- Debtors Invoice
- Sales Order
- Purchase Order
- Stock Receipt
- Manual Adjustment
- Stocktake Var Adjustment
- Stock Transfer
- Edited Invoice
To view the list of transactions, click the Transactions tab. This window displays:
The Location field contains the default location. Select a location from the list.
Click the Load button to refresh the transaction list for the location.
Select the Group by Period checkbox to enable the Transactions by Period window view.
Field definitions
The grid header fields are:
Default Window
Field |
Description |
Date |
The date of the transaction |
Alpha |
The debtor or creditor code assigned by Exo Business. The code is the first six characters of the account name followed by two sequential numerals, starting at 01. |
Ref1 |
Details about the transaction such as transaction description. |
Ref2 |
|
Batch Code |
Explained in the topic Keying stock batch codes |
Qty |
The number of stock items. |
Unit Price |
The price of a single stock item. |
Unit Cost |
The cost price of a single stock item. |
Loc |
The code of the location where the transaction took place. |
To loc |
The code of the location where the stock is being transferred. |
Receipt no |
The receipt number. |
Kit code |
A kit (BOM) code if this has been added to non sales orders. |
Plu |
Stockcodes or Barcodes for lookup items that link to a stocked item. |
Transactions by Period Window
Field |
Description |
Age |
Transaction ages are numbered from current (0) backwards. See Transaction age numbering for details. |
Period Name |
The period name that represents the current period for each ledger associated to the age number. |
Sales Qty |
Stock items sold for the period. |
Sales Value |
The total value of the stock items sold in that period, including any markups to the stock items. Note: A sale is a credit value. The Sales Value displays as a negative amount. The corresponding Unit Price displays as a positive amount. |
Purchase Qty |
The number of stock items bought for the period. |
Purchase Value |
The total cost to purchase all these stock items for that period. |
Other Trans Qty |
The quantity of all the other types that do not belong to purchases and sales – for example, adjustments – for the period. |
Other Trans Value |
The value of all the other types that do not belong to purchases and sales – for example, adjustments – for the period. |
Level |
The remaining number of items in stock at the end of that period. |
Notes
Stock on Hand Quantities - Stock on Hand quantities can be forced into a negative by overselling. The stock valuation reports ignore this. Stock quantities can be to several decimal places as governed by the options you specify under MYOB Exo Business Configurator > Essential > General Settings.
Transaction Quantities - Negative transactions represent removal of stock from Stock on Hand (Sales Invoice). Positive transactions represent an addition to Stock on Hand (Stock Receipt).