Navigate To:

Description

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

	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	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	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 (Maximum 31 days)
5	Vendor	Name of the vendor	Multi Select