One moment please...
 
Exact Globe+   
 

Viewing item cards

Menu path

To view transactions for an item, go to Inventory ➔ Items ➔ Cards, select the item and click Card. Alternatively, you can also access the item transaction card by clicking Card when you are viewing an item in the Items screen via Inventory ➔ Items ➔ Maintain.

Introduction

The item transaction card shows the final transactions of the item. From here, it can be tracked to the sales or purchase orders that resulted in the transaction.

Fields

You can filter the transactions you want to display by defining one or more of the following criteria, and then clicking Refresh. The transactions that match the criteria you have defined are then displayed.

Date

Type or select the start and end dates to display transactions with the selected date range. Select the All check box to display transactions for all dates. By default, a seven-day date range ending with the current date is displayed.

Note: Typing or selecting only the start date will display transactions with the selected date and later dates. Typing or selecting only the end date will display transactions with the selected date and earlier dates.

Transaction

Select either to view the transactions of the total movement in stock (Inventory), of only stocks sent out (Out) or of only stocks received (In). This option allows you to obtain a clearer view by grouping the movement of stocks.

Click  to define the following criteria:

Group by

Select an option to group the transactions either by Warehouse, Debtor, Creditor, Cost center, Cost unit, Resource, G/L, Date, Week, Period: Month, Quarter, Year, Project, Our ref., or Offset account. For example, selecting Resource will group the transactions according to the resource IDs. If you select None, all transactions will be displayed. Grouping the results differently can be used for different purposes. For instance, grouping results by resource can show stock movements that were carried out by a resource. This will quickly help to identify the stock movements made by each resource.

Type

Select the relevant type of transactions to be displayed. This can either be All, Receipt, Fulfillment, Count, Returns: Fulfillment, or Returns: Receipt.

Unit

Select to show transactions either in Sales or Purchase units. It is possible that your purchase unit is different from your sales unit, especially when you purchase, for example, in cartons and sell in single units.

Include: Unprocessed

Select this check box to show item transactions that are not processed. You can get an overall view of the status of your organization’s stock movements if you include unprocessed transactions.

Include: Stock at supplier

Select this check box to include stock at supplier. This option includes stocks that have been purchased but have not been received yet from the supplier. This provides a more complete picture by taking into account stocks that are scheduled to arrive later.

Incomplete

Select this check box to show items that were received but have not been assigned a serial or batch number yet. This allows you to efficiently find out which items have not been assigned a serial or batch number yet.

Note: This check box is available only if it is a Serial or Batch item.

Filter

Click  for more filtering options. Select or type the relevant criteria so that the required transactions are shown. You can use the filters to zoom in to specific items from the listed results.

Filter section

Filter

Select the required option to filter for results that either starts with or contain a certain letter, word, or number. This applies for the Our ref., Your reference, Order, Payment reference, Entry number, and Description fields only.

Our ref.

Type the Our ref. number to display the transactions with the entered Our reference number.

Your reference

Type the Your reference to display the transactions with the entered Your reference.

Order

Type the sales or purchase order number to display the transactions with the entered order number.

Payment reference

Type the payment reference number to display the transactions with the entered payment reference number.

Entry number

Type an entry number to display the transactions with the entered entry number.

Description

Type a keyword for the description to display the transactions with the entered entry number.

GL account

Type or select the GL account to display transaction(s) linked to the selected GL account.

Debtor

Type or select the debtor to display transaction(s) linked to the selected debtor.

Creditor

Type or select the creditor to display transaction(s) linked to the selected creditor.

Journal

Type or select the journal to display the transactions for the selected journal only.

Resource

Type or select the resource to display only transactions that originated from that resource.

Item group

Type or select the item group to display transactions for the selected item group only.

Project

Type or select the project to filter the results to show only transactions for that project only.

Cost center

Type or select the cost center to filter the results to show only transactions for that cost center only.

Cost unit

Type or select the cost unit to filter the results to show only transactions for that cost unit only.

Warehouse

Type or select the warehouse to filter the results to show only transactions for that warehouse only.

Currency

Type or select the currency to filter the results to show only transactions for that currency only.

Selection code

Type or select the selection code to filter the results to show only transactions for that selection code only.

Amount

Type or select the amount to filter the results to show only transactions for that amount only.

The section after the listing shows calculated information of the item. The left column calculates the quantity of the item while the right column calculates the value of the item. The middle column provides other related information about the item.

In the left column, Balance is the difference between Receipts and Issues. (Closing) Stock is the total of (opening) Stock and Balance. Free stock is calculated by taking into account any stock not allocated to a sales or production order.

In the middle column, Standard cost price is obtained from the Basic tab in the Items maintenance screen. Last purchase price displays the price from the latest purchase invoice, if available. Average purchase price is calculated when the stock valuation is set to APP. This will show the average purchase price of the item. The valuation method for inventory is set at System ➔ Settings ➔ Inventory settings. Date last counted shows the last date the item was counted based on the counting cycle.

In the right column, the first Stock value is the value of the opening stock (or the value of the stock as at the specified From date). Debit shows the value of stock that was received while Credit shows the value of stock that was sent out. Difference shows the difference between the Debit and Credit figures. The second Stock value is the value of the closing stock (or the value of the stock as at the specified To date).

Buttons

Refresh

Click this to refresh the screen and display the results based on the defined criteria.

Export

Click this to export the results to Microsoft Excel.

Note
: The opening and closing balance of an item will be incorporated in the reports, when you perform the export functionality. You can easily identify the opening, and closing inventories.

Note

Click this to view or add a note to the selected transaction.

Attachment

Click this to view or add an attachment to the selected transaction.

Sales order

Click this to view the related sales order for the item.

Note: This button is enabled only if the item has a sales order.

Serial/batch

Click this to view the serial or batch number of the selected transaction item.

Note: This button is available only if the item has a Serial or Batch attribute as specified in the item maintenance card at Inventory ➔ Items ➔ Maintain. The Serial or Batch check box option is found in the Inventory tab.

Maintain

Click this to view and maintain the details of the item.

Produce

Click this to view the production orders related to the item.

Note: This button is available only if the item has a Make attribute as specified in the item maintenance card at Inventory ➔ Items ➔ Maintain. The Make check box option is found in the Inventory tab.

Purchase

Click this to view the related purchase order for the item.

Note: This button is available only if the item has a Buy attribute as specified in the item maintenance card at Inventory ➔ Items ➔ Maintain. The Buy check box option is found in the Purchase/Sales tab.

Budget

Click this to view the budgeted transactions of the item for 12 periods based on a predefined budget scenario.

Our ref.

Click this to view the general ledger accounts affected by the selected transaction.

Allocate

Click this to view the allocation of the item to the appropriate pending sales orders or internal use requests.

Note: This button is available only for purchase transactions. Stock allocation will only affect stock count transactions and not stock revaluation transactions. Both the stock count transactions and stock revaluation transactions are displayed as transaction type Counts in the Type column. The system is able to differentiate between stock count and stock revaluation transactions.

Close

Click Close to exit.

Related documents

     
 Main Category: Attachments & notes  Document Type: Online help main
 Category:  Security  level: All - 0
 Sub category:  Document ID: 13.803.746
 Assortment:  Date: 13-09-2020
 Release:  Attachment:
 Disclaimer