Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To see full sized image, right-click on the image, and select Open image in new tab

...

...

dashboard-sample-20240223-050628.pngImage Added

Image Added

Image Added

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

General

OMS

System

Assure

Omni Magic Message Posting Status - OMS

Helps with the Relay Status and Time of Messages(Gate Entry Closure, Item GRN, Outward Order Completion, Return Order Completion) posted to

Assure

Omni Magic.

OMS

General

Billing

Billing Report - OMS

Billing reports contains Inwards, Outwards and Returns data Summarized at Month, Brand and Category level.

WMS

General

Audit

Bin/Box Audit

Pojo

Report - WMS

Provides Warehouse wise Bin audit log.

WMS

General

Control Tower

Bird's Eye view of Warehouse Operations. This includes Transactions, productivity and Inventory data.

General

OMS

Master

Customer/Supplier details - OMS

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

General

Productivity

Day wise Productivity Report - WMS

Day wise productivity of each actor against each action in a warehouse.

OMS

General

Storage

Inventory Reco - OMS

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

Inwards

Inwards :

Inward PO wise

extra item count

Extra 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

Listing :

Channel Inventory Exposure Summary - CIMS

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

Listing

:

Snapshot - CIMS

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

Outwards:

B2C Order Status Dashboard By Order Date - OMS

Order Date, Channel, Status wise B2C Order Count.

OMS

Outwards

Outwards:

B2C Order Status Dashboard By SLA Date - OMS

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.

Outwards

OMS

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.

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

Outwards

Outwards :

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

Outwards :

SKU wise open order & Inventory available - OMS

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

Outwards :

Time wise Pending B2C Orders by SLA Date - OMS

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

Productivity Report - WMS

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

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

General

Audit

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

Storage

Storage : 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.

Storage

WMS

Outwards

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.

Storage

OMS

Master

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.