Introduction
This document describes the report for E-WMS transaction history, when not
using E-WMS SKU Management, as available from product update 412.
Description
Exact Globe Next menu WMS, Reports, Transaction history offers insight
in E-WMS historical and processed transactions. This report is based on
transactions created without using E-WMS SKU Management.
When you are using SKU
Management, please refer to
this document.
General remarks
The report is intended to show stock transactions processed in E-WMS
logistical processes. However, also other transaction types determine the total
stock of an item:
- stock balance corrections, which can be created by E-WMS Inventory
Counts (when creating a new count and in case of stock inconsistency), or by the E-WMS Stock Diagnose 'repair'
function. These transactions are shown as transaction type 'Correction
counts'
- stock transactions processed directly in Exact Globe Next (or add-ons),
outside E-WMS processes. These transactions are shown as transaction type
'Exact Globe Next' (from release 412; in earlier releases these
transactions are shown as 'Stock
inventory')
The report will only show transaction history for processed transactions from release 407 or higher.
E-WMS transactions from earlier releases are
not available in the E-WMS transaction history table, and are only visible as stock starting
position ('Stock corrections'), created by E-WMS function 'Rebuild stock
transactions' (available from release 407).
The report is sorted on: the sorting key you selected (in case of 'location': warehouse + location); 'our reference', item code,
and in case of a transfer: the issue
first, then timestamp of processing the transaction.
Selections
After starting the report, you have following
selections and options available:
Date
Selection on the processed transaction date
Item code
Selection on item code. The browser shows items of type 'standard' and 'bulk'
Item group
Selection on item group
Serial/batch number
Selection on serial- or batch number (only visible when your license contains
SE1325 E-Serial/Batch)
Warehouse
Selection on warehouse. This is not limited by 'warehouse rights' for the user
starting the report.
Location
Selection on warehouse location (only visible when your license contains SE1312
E-Warehouse Location)
Location type
Selection on E-WMS 'Location types', as defined in menu WMS, Setup, Location
management, Location types.
This option is only visible when your license contains SE1312 E-Warehouse Location.
Employee
Selection on the warehouse employee who scanned the transaction. The browser
lists all employees, but shows employees linked to scanners first.
For E-WMS Stock Inventory transactions and corrections, the assigned employee is always 0 (zero).
Our ref.
Selection on Exact Globe Next 'our reference', as assigned to this transaction
on processing. The browser shows all 'our references' known in the WMS
transaction table.
Transaction type
You are able to report all WMS transaction types, or show one specific
transaction type.
"Stock transaction" refers to the stock receipts or issues
processed through E-WMS menu WMS, To be processed, Stock transactions (or
the E-WMS RF Service).
"Stock inventory" are count differences processed through the
E-WMS inventory process (menu WMS, To be processed, Inventory counts).
"Correction counts" are stock balance corrections,
which can be created by E-WMS Inventory Counts (automatically generated when creating a new count
in case of stock inconsistency), or
by the E-WMS Stock Diagnose 'repair' function.
"Exact Globe Next" are stock transactions processed directly
in Exact Globe Next (or add-ons), outside E-WMS processes.
"Corrections" refers to two types: "Correction
counts" and "Exact Globe Next", so you are able to report (or exclude,
see 'Exclude' below) these two types of transactions at the same time.
Exclude
You are able to exclude one E-WMS process type from the report, see remarks
above for 'Transaction type'
Report options
The following reporting options are available:
Sort by
You can use these key fields to sort the report. 'Month' refers to the year and
month of the transaction date, where 15 December 2013 would result in "2013-12".
The sorting order is always 'ascending'.
Subtotal
When enabled, the report will show group headers and subtotals per 'Sort by' field. These
subtotals include: total quantity in sales units and number of transactions.
When disabled, the report will show no subtotals and no group headers, but only one
report total (quantity and number of transactions). The listing is still sorted
by the 'Sort by' field.
Report columns
After pressing 'Start', the report will be generated, and shows following
columns:
Date
The date of the WMS transaction
Item code, Item description
The item used in the transaction
Serial/batch
The serial batch number, for serial number- or batch items
Wrh.
The warehouse code
Location
The warehouse location
Our ref.
The 'our reference' number assigned to the transaction, when processed by
E-WMS to Exact Globe Next. This column can be empty in case of 'correction
counts' (inconsistency repair transactions).
Transaction type
The E-WMS transaction type. This can be one of following:
- Replenishment
- Purchase Entry
- Stock inventory
- Production - Issues
- Fulfilment
- Production - Receipts
- Receipts registration
- Stock transactions
- Sales Entry (Mobile Sales)
- Stock transfers (including repacking)
- Correction count
- Exact Globe Next
Before release 412, type 'Stock Inventory' also includes all transactions processed directly in
Exact Globe Next instead of through E-WMS. In these cases the column 'Employee'
would be empty.
From release 412, these transactions are reported separately as transaction type
'Exact Globe Next'.
Employee
The full name of the hand terminal user who scanned the transaction. This column
will be empty for transaction types 'Correction count' and 'Exact Globe Next'.
This column can also be empty for 'Stock Inventory' transactions, because these
stock corrections can be based on combined counts of multiple scanners.
Quantity
The quantity in sales units, using 3 decimals if a divisible item was part of
the list, else without decimals (before release 412: always 2 decimals).
Totals
Quantity
The total quantity in sales units, using 3 decimals if a divisible item was part
of the list, else without decimals (before release 412: always 2 decimals).
Number of transactions
The total number of transactions for
the selected range. For transfers, the issue and receipt parts of a transfer are counted as separate transactions.
Related documents