This document describes the report for E-WMS transaction history, when not using E-WMS SKU Management, as available from product update 412.
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:
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:
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.