Navigate To:

Description

Inwards received at GRN date and Invoice level data is populated and can be filtered on GRN done date.

Fields

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 Fulfilment Location NA wms_hsr
3 Fulfilment Location City City of the Fulfilment Location NA Bengaluru
4 Gate Entry ID gate entry no NA 123456789
5 GRN Date Date of GRN 2023-01-01
6 Vendor Invoice No External invoice number. NA abc134
7 Vendor Invoice Date External Invoice Date. Yes if the external invoice is not present. 2023-01-01
8 PO No Inward Purchase Order ID Yes if the order is not placed by any channel. abc245
9 Parent Order ID Order ID of parent order abc245
10 Order Type Type of Order abec124
11 Vendor Name Partner Name abc333
12 Vendor City City of Partner abc345
13 Brand Brand abc345
14 PO Qty Total Ordered Quantity. 12345
15 Received Qty Total Received Quantity 12345
16 Pass Qty Total QC Passed Quantity 12345
17 Fail Qty Total QC Failed Quantity 12345
18 LR No AWB Number abc123
19 Vehicle No Vehicle Number abc123
20 Vendor Tin GST Number abc123
21 Net Value Rs. Total Cost 123
22 Total MRP Value Rs. Total MRP 123
23 Gate Entry Remarks Gate Entry Remark abc123

Filters

Filters Description Limitation
1 Client Name of the client Mandatory
2 Time Zone To show data in the specified time zone Mandatory
3 Fulfilment Location Name of the Fulfilment Location Mandatory
4 GRN From - GRN To To filter the report on GRN time Mandatory (Maximum 31 days)
5 Vendor Name of the vendor Multi Select

FAQs