Order Lookup Dashboard

Dashboard Overview

Start Date

End Date

Sales Count

0

₹0.00

Returns Count

0

₹0.00

Shipping Charges (Clr Date)

Start Date

End Date

Shipping Count

0

₹0.00

Doc Report (Doc Date)

Start Date

End Date

Cleared

0

₹0.00

Not Cleared

0

₹0.00

History & Records

Upload Data Files

File 1 Main Orders Sheet

FWD PO No + Seller Invoice No

Cust Order No lookup sheet

File 2 Value / Price Sheet

Invoice Number + Value

Value lookup sheet

Select File 2

File 3 Retention / Deduction

Reference DV + Amount

Deduction sheet

Select File 3

Upload RTV & MKT Files

Step 1 MKT File

Upload MKT Sheet

Contains Order No, Tracking & Condition

Step 2 RTV File

Upload RTV Sheet

Contains Order No to find

Select RTV File

Dashboard Overview

Shipping Charges (Clr Date)

Doc Report (Doc Date)

RTV Missing Records (FWD PO Date)

History & Records

Result Table

Upload Data Files

Upload RTV & MKT Files

RTV Extraction History

Extracted Orders (Missing Tracking & Condition)

Secure Login

Dashboard Overview

Shipping Charges (Clr Date)

Doc Report (Doc Date)

RTV Missing Records (FWD PO Date)

History & Records

Result Table

Upload Data Files

Upload RTV & MKT Files

RTV Extraction History

Extracted Orders (Missing Tracking & Condition)