Navigate To:

Description

Inward received at GRN date and UOM 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 GRN Date Date of GRN NA 2023-01-01
6 PO Date Purchase order date NA 2023-01-01
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 Vendor Invoice No External invoice number. NA abc134
11 Order Type Type of Order NA 1. STOCK_TRANSFER
  1. PURCHASE | | 12 | Vendor Name | Partner Name | | abc333 | | 13 | Vendor City | City of Partner | | abc345 | | 14 | Client SKU ID/EAN | client sku id | NA | abc123 | | 15 | Global SKU ID | global sku id | NA | 123455678 | | 16 | Each Client SKU ID | client sku id | NA | abc123 | | 17 | Each Global SKU ID | global sku id | NA | 123455678 | | 18 | SKU Desc | Sku description | NA | abc345 | | 19 | Style | Style | NA | acb345 | | 20 | Size | Size | NA | abc433 | | 21 | color | color | NA | abc134 | | 22 | Brand | Brand | NA | abc345 | | 23 | LR No | AWB Number | | abc123 | | 24 | Vehicle No | Vehicle Number | | abc123 | | 25 | HSN Code | | NA | abc123 | | 26 | Vendor Tin | GST Number | | abc123 | | 27 | Category | Category | NA | abc123 | | 28 | Fail Qty | Total QC Failed Quantity | NA | 12345 | | 29 | Pass Qty | Total QC Passed Quantity | NA | 12345 | | 30 | Received Qty | Total Received Quantity | NA | 12345 | | 31 | Received Each Qty | Total quantity received in each box | NA | 1234 |

Filters

Filters Description Limitation
1 Client Name of the client Mandatory
2 Fulfilment Location Name of the Fulfilment Location Mandatory
3 GRN From - GRN To To filter the report on GRN time 1. Mandatory
  1. Max date range : 31 days | | 4 | Vendor | Name of the vendor | Multi Select | | 5 | Order Type | Type of Order | Multi Select |

FAQs