B2C Order Wise SLA and Pendency Report

Navigate To

Description

Provides order wise leg to leg time taken and pending qty.

Fields

Fields

Description

This column can be null

Sample Data

Fields

Description

This column can be null

Sample Data

1

Client Name

Name of the client

NA

Increff

2

Fulfillment Location Name

Name of the Fulfillment Location

NA

wms_hosur

3

Sales Channel

Channel through which order is placed

 

FLIPKARTV3

4

Channel Order Date

Order placed timestamp

 

2023-01-01 12:34:56

5

Channel Order No

Order ID from channel

 

abcd123

6

System Order ID

Increff’s unique Order ID

NA

5234242342

7

System Sub Order ID

Increff’s Unique Sub Order ID

NA

1231212312

8

Order Type

Type of order

NA

SALES

9

SLA Breach

Whether order has breached SLA or not

NA

YES or NO

10

Order Qty

Quantity Ordered

NA

423

11

Cancelled Qty

Quantity Cancelled

NA

454

12

Reserve Qty

Quantity Reserved

NA

6453

13

Dispatched / Packed Qty

Quantity Dispatched or Packed

NA

523

14

Pending Qty

Quantity Pending

NA

534

15

Unfulfillable Qty

Quantity unfulfillable

NA

534

16

OMS Order time to WMS Order time in Hrs

Hours Taken to Create Order in WMS from OMS

If WMS order is not yet created

0.012

17

WMS Order Creation to Last Picked in Hrs

Hours Taken to Complete Picking from Order Creation in WMS

If no items were picked yet

1.23

18

Last Picked to Invoice Creation in Hrs

Hours Taken to Create Invoice after Last Item Picked

If Invoice is not yet created

42.42

19

Invoice Time to Manifest Time in Hrs

Hours Taken to Manifest after Invoice

If manifest is not yet created

5.32

20

Manifest Time to Handover Time

Hours Taken to Handover a Shipment after Manifested

If not handed over yet

43.11

Filters

Filters

Description

Limitation

Filters

Description

Limitation

1

Order Created From

Order created from the date

  1. Mandatory

  2. Max Date Range : 92 days

2

Order Created To

Order created to the date

3

Channel Order Number

Order ID from channel

NA

4

System Order ID

Increff’s unique Order ID

NA

5

System Sub Order ID

Increff’s Unique Sub Order ID

NA

FAQs