Navigate To:

Description

Inward received at GRN date and SKU level data is populated and this report 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 ASN ID 123456789
6 ASN Approved Quantity 123
7 GRN Date Date of GRN 06/10/2019 11:43:38
8 GRN Start Time Start time of grn 06/10/2019 11:43:38
9 Gate Entry Closed Time Close time of gate entry 06/10/2019 11:43:38
10 Vendor Invoice No External invoice number. NA abc134
11 Vendor Invoice Date External Invoice Date. Yes if the external invoice is not present. 06/10/2019 11:43:38
12 PO No Inward Purchase Order ID Yes if the order is not placed by any channel. abc245
13 Parent Order ID Order ID of parent order abc245
14 PO Date Purchase order date 22/09/2019 00:28:44
15 Order Type Type of Order abec124
16 Vendor Name Partner Name abc333
17 Vendor City City of Partner abc345
18 Global SKU ID global sku id NA 123455678
19 Client SKU ID/EAN client sku id NA abc123
20 SKU Desc Sku description abc345
21 Brand Brand abc345
22 Category Category abc123
23 Style Style acb345
24 Size Size abc433
25 color color abc134
26 MRP MRP 123.50
27 Received Qty Total Received Quantity 12345
28 Pass Qty Total QC Passed Quantity 12345
29 Fail Qty Total QC Failed Quantity 12345
30 LR No AWB Number abc123
31 Vehicle No Vehicle Number abc123
32 HSN Code abc123
33 Vendor Tin GST Number abc123
34 Base Price Base Price 1234
35 Received Value Value of total received quantity 123
36 IGST Rate Interstate GST 123
37 CGST Rate Central GST 123
38 SGST Rate State GST 123
39 IGST Amount per Unit Interstate GST per unit 123
40 CGST Amount per Unit Central GST per unit 123
41 SGST Amount per Unit State GST per unit 123

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 1. Mandatory
  1. Max date range : 31 days | | 5 | Vendor | Name of the vendor | Multi Select | | 6 | Order Type | Type of Order | Multi Select |

FAQs