This document describes the report for E-WMS transaction history, when using WMS SKU Management, as available from product update 412.
This document has following sections:
Exact Globe Next menu WMS, Reports, Transaction history offers insight in
WMS historical and processed transactions. This document describes the report
when using E-WMS SKU Management.
When you are not using WMS SKU
Management, please refer to
this document.
General remarks
For SKU items, the report will also show transaction history for transactions
created before release 407.
For non-SKU items, transaction history is only
available for transactions processed in release 407 or later.
After updating to release 407 or later, and rebuilding E-WMS stock balances,
stock corrections (E-WMS stock opening balance) will be created where necessary, at least for
all non-SKU items, which will be visible on this report as 'Stock corrections'.
The report is sorted by:
- The sorting key you selected (in case of 'location': warehouse + location)
Next, by following fields, which are required to keep transactions of one SKU together
(in case of transfers of two-layer SKUs or SKUs with serial numbers):
- 'Our reference'
- SKU number
- Warehouse + warehouse location
- Serial/batch number
- WMS transaction type code
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',
and indicates whether the item is a SKU item or not.
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
Location type
Selection on WMS 'Location types', as defined in menu WMS, Setup, Location
management, Location types
Outer SKU
Selection on specific outer SKU numbers
Inner SKU
Selection on specific inner SKU numbers
Out.SKU type
Selection on a specific outer SKU type, as defined in menu WMS, Setup, SKU,
SKU types
Inn.SKU type
Selection on a specific inner SKU type, as defined in menu WMS, Setup, SKU,
SKU types
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 the employee may be 0 (zero) and for correction counts, 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 E-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 process type from the report, see remarks
above for 'Transaction type'
SKU items only
When enabled, the report will only show SKU items (=an item which is configured
in menu WMS, Setup, SKU, SKU per item)
When disabled, the report will show all items. Please also note the report
option 'Hide transactions in sales units' below.
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 (15 December 2013 would result in "2013-12").
Show: Subtotal
When enabled, the report will show group headers and subtotals per 'Sort by'
field. These subtotals include: total quantity in sales units, number of
transactions, number of SKUs involved in the listed transactions.
When disabled, the report will show no subtotals and no group headers, but only one
report totals. The listing is still sorted
on the 'Sort by' field.
Show: SKU details
When enabled, the report will show the content of a SKU, which can be:
inner SKU numbers (in case of a two-layer SKU) and/or serial numbers.
When disabled, the report will just show totals per outer SKU number.
Note: an inner SKU when not part of an outer SKU, is regarded as 'outer SKU' for
this report (and the SKU number will show in column 'SKU').
When the SKU is shown 'compressed' then only the
first serial number
on the SKU is shown. From release 412, this serial number is followed by ' * '
to indicate that more serial numbers are involved.
Show: transactions in sales units
When enabled, transactions for all unit types are listed.
When disabled, transactions without SKU number (transactions for SKU items with
empty SKU number, or transactions for non-SKU items) are not shown in the
report.
Please note, when disabled, you may see only one part of a 'transfer' or
repacking action, if a bulk SKU was transferred to a location where it was
'broken up' to sales units.
Report columns
After pressing 'Start', the report will be generated, and shows following
columns:
SKU
The SKU number for the outer SKU, or for the inner SKU when not part of a
two-layer SKU configuration.
Item code, Item description
The item used in the transaction. Available space for long item codes and item
descriptions is limited.
Serial/batch
The serial batch number, for serial number- or batch items
Date
The transaction date
Wrh.
The warehouse code
Location
The warehouse location
Type
Refers to the E-WMS transaction type. This transaction type code is
explained in the footer of the report:
A - Replenishment
H - Purchase Entry
I - Stock inventory
K - Production - Issues
O - Fulfilment
P - Production - Receipts
R - Receipts registration
S - Stock transactions
T - Sales Entry (Mobile Sales)
V - Stock transfers (including repacking)
X - Correction counts
G - 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'.
Our ref.
The Exact Globe Next 'our reference' number assigned to the transaction,
when processed by E-WMS.
This column can be empty in case of 'correction counts' (inconsistency repair
transactions), or for transaction type 'Transfers': repacking of a SKU (since
this means no stock movement in Exact Globe Next).
You can use this 'our reference' number to search the created transactions in
Exact Globe Next.
User
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 item quantity in standard sales units, using 3 decimals for divisible items,
else without decimals.
Totals
Total quantity
The total quantity in sales units, using 3 decimals if a divisible item was part
of the list, else without decimals.
Number of SKUs
The count of unique SKU numbers in the selected transactions. On subtotal level,
this is only shown for SKU items.
Number of transactions
The total number of transactions for
the selected range. For transfers, each issue and receipt of a transfer is
counted as a separate transaction.
Related documents