...
To see full sized image, right-click on the image, and select Open image in new tab
...
...
Standard Reports (Sample)
Here are a few reports and their functionality. Note that this is just a sample set of reports, the product contains many more reports.
You can find the google sheet template https://docs.google.com/spreadsheets/d/1gQKuDFZ6R0k_FSPhWpFXbywcJMXpH4hNMYaG_Sg-cu0/edit#gid=1761091054
Quick Links
Product | Report Name | Description |
OMS | System |
Helps with the Relay Status and Time of Messages(Gate Entry Closure, Item GRN, Outward Order Completion, Return Order Completion) posted to |
Omni Magic. |
OMS |
Billing | Billing reports contains Inwards, Outwards and Returns data Summarized at Month, Brand and Category level. | |
WMS |
Audit |
Provides Warehouse wise Bin audit log. | |||
WMS | General | Bird's Eye view of Warehouse Operations. This includes Transactions, productivity and Inventory data. |
OMS | Master | Provides customer and supplier details present in the system. | |
WMS | General | Dashboard | Provides Sales, Inwards and returns data of last day, current week and current month. Current Snapshot of Unmapped SKUs is also populated. |
WMS |
Productivity | Day wise productivity of each actor against each action in a warehouse. | |
OMS |
Storage | Contains warehouse wise Total Outwards, Total Inwards, Total Returns, Total Items in various stages, System storage, Inventory and Lost quantities. Helps with Inventory Reconcilation. | |
WMS | Inwards |
Provides PO and Gate entry wise Extra Item details such as Extra Box ID, Extra Item Status, Item ID etc. which can be filtered based on PO and Gate Entry dates. | |
OMS | Inwards |
Inward received at GateEntry date and Inward Box level data is populated and can be filtered on Gate Entry date. | |
OMS | Inwards |
Inward received at GRN date and Invoice level data is populated and can be filtered on GRN done date. | |
OMS | Inwards |
Inward received at GRN date and SKU level data is populated and this report can be filtered on GRN done date. | |
OMS | Inwards |
Inward received at GateEntry(Invoice) level data is populated and can be filtered on Gate Entry date. | |
OMS | Inwards |
Inward Orders at PO SKU level data is populated and can be filtered on PO Created date. | |
WMS | Inwards |
Provides Average time taken in each step from gate entry to putaway during inwards. Helps with the Inward Productivity. | |
WMS | Inwards |
Helps in Identifying possible locations of Misplaced Items which are in New status. Report can be filtered on Item ID and the result set will include 5 Actions done before and after creating that Item by the same Actor. | |
WMS | Inwards |
Provides PO wise extra items received for each SKU and also provides it's attributes. This report can be filtered based on PO and Gate Entry dates. | |
CIMS | Listing |
Channel ,SKU wise Inventory Exposure. | |
CIMS | Listing |
Channel wise Inventory Exposure against Available and Listed Inventory. | |
CIMS | Listing |
SKUs that got Failed in CIMS due to lack of listing. | ||
CIMS | Listing |
Client SKUs(EAN) with their corresponding Channel SKU IDs for different Channels. | |
CIMS | Listing |
Client SKUs(EAN) for which Channel SKU Id mapping is not present in the System with their total available Quantity. | |
OMS | Outwards |
Invoiced B2B Outward Orders with tax information, Customer details, life-cycle timestamps(creation, packed, SLA, manifest etc) | |
OMS | Outwards |
Order Date, Channel, Status wise B2C Order Count. | |
OMS | Outwards |
SLA Date, Channel, Status wise B2C Order Count. | |
OMS | Outwards |
Provides Average time taken in each step from Outward Order creation to manifest. | |
OMS | Outwards |
Invoiced B2C Outward Orders with tax information, Customer details, life-cycle timestamps(creation, packed, SLA, manifest etc) | |
WMS | Outwards |
Outward Open Orders with BOX details at item level. | |
CIMS | Outwards |
Failed Outward Orders, due to unavailability of listing in CIMS. | |
OMS | Outwards |
Manifest level Outward Order Details. |
OMS | Outwards |
For a given SKU, shows entire timeline of inventory updates sent and orders received for all channels for last 7 days. Very crucial in debugging Unfulfillable orders.
Outwards |
: Order Flow - OMS | Channel wise flow of unfulfillable orders with 2 Hours interval. |
OMS | Outwards |
Outward Order details at Order level with all the relevant information. | |
OMS | Outwards |
Outward Order details at Order-SKU level with all the relevant information. | |
OMS | Outwards |
Invoiced Outward Orders at Order-Invoice level data with their Tax Split ups. | |
OMS | Outwards |
Unfulfillable SKUs with their last unfulfillable Order details, Last Sync details and inventory stuck in Recycle, Offline and GRN state. Helps with the analysis of Unfulfillable orders. | |
WMS | Outwards |
Outward Open Orders data at Box ID-Invoice level with Transporter and Shipment Details. | |
OMS | Outwards |
Packed Outward Orders at SKU level | |||
WMS | Outwards | Outwards : Pending B2C Outward Orders Summary | Pendency of B2C Outward Orders by SLA date , release date at channel level. |
WMS | Outwards |
Warehouse wise picklist count for current and future dates SLA channel wise. | |
OMS | Outwards |
Suggests Item IDs that can be considered for an RTV (Return to Vendor) order. | |
OMS | Outwards |
SKU wise open orders, order quantity and total quantity in the warehouse. | |
OMS | Outwards |
Current day snapshot of SLA Breached orders and Unfuflfillable Orders received. | |
WMS | Outwards |
Provides Order, Item level details for a shipped Outward orders. | |
OMS | Outwards |
Pendency of Current day B2C SLA orders grouped on status with 2 Hours interval. | |||
OMS | Outwards | Outwards : Top Sellers | Style level report sorted on last 15 days revenue. Provides metrics like ASP, ROS, Expected Days of Inventory, etc calculated with last 15 days sales data. |
WMS | General | Provides hourly productivity of all the Warehouse Employees for various actions like GRN, Picking, Packing and Putaway. When the report is run for multiple days, it gives the average of items for which some action is done in that hour. | |
OMS | Returns |
Return gate entry details and AWBs received against it. | |
OMS | Returns |
Provides with image URLs for QC Fail items received in returns | |||
WMS | Returns | Returns : Return Order CIMS FAIL Report - CIMS | Return Orders that are Failed in CIMS with Remarks and other details. |
WMS | Returns |
Return Order details at Item level. | |
OMS | Returns |
Return Orders with their Forward Order details and customer Information at Return Order, SKU level. | |
WMS | Returns |
Provides Average time taken from return recived to putaway during return process. Helps with Return Productivity | |
OMS |
Audit |
Provides OMS SKU audit log details. | |
WMS | Storage |
Helps in Identifying the Items present in a bin. | |
WMS | Storage |
Total Inventory at Bin and SKU level with Bin status and QC status. | |
WMS | Storage |
Provides Bin wise cycle count before and after quantities. | |
WMS | Storage |
Helps with Aisle details like Aisle ID, Location, Bin present in those Aisles,Bin quantity and wheather the Aisle is empty or not. | |
WMS | Storage |
Details of Items present in NEW, Live, GRN, LOST and OFFLINE Status. Helps in Identifying the Items which are in New and GRN status but not yet made live with time gap. | |
WMS | Storage |
Ageing of Live Inventory at SKU level with Last 15 days sales and ROS. | |
OMS | Storage |
Total Inventory and Available Inventory summarized at SKU, QC Status and Reservation Pool level. | |
WMS | Storage |
Current Inventory against each SKU at supplier level. | |||
OMS | Storage | Storage : Master HSN IDs - FISCAL | HSN Codes present in our system with their tax details. |
WMS | Storage |
Ageing of Live Inventory at SKU level with Last 15 days sales and ROS. |
WMS | Outwards |
Picklist Related details like Current Items, Picked status, Picked time. | |
WMS | Storage |
Pigeon holes and the Items present. | |
WMS | Storage |
List of all the Pigeon Holes with their status and Location Details | |
WMS | Storage |
QC Rejected Items with their SKU Details and the Reason for their Rejection. |
OMS | Master |
All the SKUs present in the Product Master and their details. | |
WMS | Storage |
Total Inwards, Outwards and returns at Date-SKU level. | |
WMS | Storage |
Total Inwards, Outwards and returns for the selected time period. | |
WMS | Storage |
Warehouse Inventory at SKU,Item Status, Qc Status level. |