...
To see full sized image, right-click on the image, and select Open image in new tab
...
Standard Reports (Sample)
...
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 | GeneralSystem | Helps with the Relay Status and Time of Messages(Gate Entry Closure, Item GRN, Outward Order Completion, Return Order Completion) posted to Omni Magic. | |||
WMSOMS | GeneralBilling | Billing reports contains Inwards, Outwards and Returns data Summarized at Month, Brand and Category level. | |||
WMS | GeneralAudit | Provides Warehouse wise Bin audit log. | |||
WMS | General | Bird's Eye view of Warehouse Operations. This includes Transactions, productivity and Inventory data. | |||
OMS | GeneralMaster | 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 | GeneralProductivity | Day wise productivity of each actor against each action in a warehouse. | |||
OMS | GeneralStorage | 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 | Inwards : Inward Extra Item detail report - WMS | 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 | Inwards: Inward Box Report - OMS | Inward received at GateEntry date and Inward Box level data is populated and can be filtered on Gate Entry date. | ||
OMS | Inwards | Inwards: Inward Report at GRN Level - OMS | Inward received at GRN date and Invoice level data is populated and can be filtered on GRN done date. | ||
OMS | Inwards | Inwards: Inward Report at GRN SKU Level - OMS | Inward received at GRN date and SKU level data is populated and this report can be filtered on GRN done date. | ||
OMS | Inwards | Inwards: Inward Report at Invoice Level - OMS | Inward received at GateEntry(Invoice) level data is populated and can be filtered on Gate Entry date. | ||
OMS | Inwards | Inwards: Inward Report at PO SKU Level - OMS | Inward Orders at PO SKU level data is populated and can be filtered on PO Created date. | ||
WMS | Inwards | Inwards: Inward SLA Report - WMS | Provides Average time taken in each step from gate entry to putaway during inwards. Helps with the Inward Productivity. | ||
WMS | Inwards | Inwards: Item Inward Items Stuck in New Status - WMS | 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 | InwardsInwards : | Inward PO wise extra item countExtra Item Count - WMS | 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 | Listing : Channel Inventory Exposure Detail - CIMS | Channel ,SKU wise Inventory Exposure. | ||
CIMS | Listing | Channel wise Inventory Exposure against Available and Listed Inventory. | |||
CIMS | Listing | Listing : Channel Mapping Error - CIMS | 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 | Listing : Unmapped Channel SKUs - CIMS | Client SKUs(EAN) for which Channel SKU Id mapping is not present in the System with their total available Quantity. | ||
OMS | Outwards | Outwards : B2B Outward Sku SKU Wise Report - OMS | 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 | Outwards : B2C outwards Outward SLA report - OMS | Provides Average time taken in each step from Outward Order creation to manifest. | ||
OMS | Outwards | Outwards : B2C Outward Sku SKU Wise Report - OMS | Invoiced B2C Outward Orders with tax information, Customer details, life-cycle timestamps(creation, packed, SLA, manifest etc) | ||
WMS | Outwards | Outwards : Outwards Box report at Item Level - WMS | Outward Open Orders with BOX details at item level. | ||
CIMS | Outwards | Outwards : Failed Order Report - CIMS | Failed Outward Orders, due to unavailability of listing in CIMS. | ||
OMS | Outwards | Outwards : Manifest Report Detail - OMS | Manifest level Outward Order Details. | CIMS | Outwards |
Outwards : Order Exposure History - CIMS | 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. | OMS | Outwards | Outwards : Order Flow - OMS | Channel wise flow of unfulfillable orders with 2 Hours interval. |
OMS | Outwards | Outwards : Order Status Report - OMS | Outward Order details at Order level with all the relevant information. | ||
OMS | Outwards | Outwards : Order Status Report Detail - OMS | Outward Order details at Order-SKU level with all the relevant information. | ||
OMS | Outwards | Outwards : Outward Summary Report - OMS | Invoiced Outward Orders at Order-Invoice level data with their Tax Split ups. | ||
OMS | OutwardsOutwards | : Outward Unfulfillbale Unfulfillable Orders Detail - OMS | 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 | Outwards : Outwards at Box ID Level - WMS | Outward Open Orders data at Box ID-Invoice level with Transporter and Shipment Details. | ||
OMS | Outwards | Outwards : Packed Order Details - OMS | 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 | Outwards : Picklist Summary - WMS | Warehouse wise picklist count for current and future dates SLA channel wise. | ||
OMS | Outwards | Outwards : RTV Suggestions - OMS | 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 | Outwards : SLA brached breached and Unfulfillable Orders - OMS | Current day snapshot of SLA Breached orders and Unfuflfillable Orders received. | ||
WMS | Outwards | Outwards : Shipped Order Items Detail Report - WMS | 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. | |||
WMSOMS | Returns | Returns : Return Gate entry Entry Report - OMS | Return gate entry details and AWBs received against it. | ||
OMS | Returns | Returns : Return Image URLs - OMS | 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 | Returns : Return Order Report Item Level - WMS | Return Order details at Item level. | ||
OMS | Returns | Returns : Return Order Report SKU Wise - OMS | Return Orders with their Forward Order details and customer Information at Return Order, SKU level. | ||
WMS | Returns | Returns : Return SLA report - WMS | Provides Average time taken from return recived to putaway during return process. Helps with Return Productivity | ||
OMS | GeneralAudit | SKU audit log Audit Report - OMS | Provides OMS SKU audit log details. | ||
WMS | Storage | Storage : Bin & and Item ID Level Snapshot - WMS | Helps in Identifying the Items present in a bin. | ||
WMS | Storage | Storage : Bin & and SKU level Inventory Snapshot - WMS | Total Inventory at Bin and SKU level with Bin status and QC status. | ||
WMS | Storage | Storage : Bin Cycle Count Report - WMS | Provides Bin wise cycle count before and after quantities. | ||
WMS | Storage | Storage : Bin Locations Report - WMS | Helps with Aisle details like Aisle ID, Location, Bin present in those Aisles,Bin quantity and wheather the Aisle is empty or not. | ||
WMS | StorageStorage | : GRN at Item Level Non Live Items Report - WMS | 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 | Storage : Inventory Ageing - WMS | Ageing of Live Inventory at SKU level with Last 15 days sales and ROS. | ||
OMS | Storage | Storage : Inventory Available for Sales - OMS | Total Inventory and Available Inventory summarized at SKU, QC Status and Reservation Pool level. | ||
WMS | Storage | Storage : Inventory at Supplier Level - WMS | 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 | Storage : Not Found Snapshot - WMS | Ageing of Live Inventory at SKU level with Last 15 days sales and ROS. | ||
WMS | StorageOutwards | Storage : Picklist Report - WMS | Picklist Related details like Current Items, Picked status, Picked time. | ||
WMS | Storage | Storage : Pigeonhole details at item level - WMS | Pigeon holes and the Items present. | ||
WMS | Storage | Storage : Pigeon Hole Location - WMS | List of all the Pigeon Holes with their status and Location Details | ||
WMS | Storage | Storage : QC Reject Reasons Report - WMS | QC Rejected Items with their SKU Details and the Reason for their Rejection. | ||
OMS | StorageMaster | Storage : SKU Master - OMS | All the SKUs present in the Product Master and their details. | ||
WMS | Storage | Storage : Stock Movement Detail - OMS | Total Inwards, Outwards and returns at Date-SKU level. | ||
WMS | Storage | Storage : Stock Movement Summary - OMS | Total Inwards, Outwards and returns for the selected time period. | ||
WMS | Storage | Storage: Warehouse Inventory Status - WMS | Warehouse Inventory at SKU,Item Status, Qc Status level. |