MYOB Exo Business

Hide NavigationShow Navigation

  • Contents
  • Index
  • Search
 
Show results that include all search words

 

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).