Navigate To:

1 Description
2 Fields
3 Filters
4 FAQs

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

	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

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

Omni Public

Inward Report at GRN SKU Level - OMS

Navigate To:

Description

Fields

Filters

FAQs