Inward Report at GRN UOM-SKU Level - OMS

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

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

  2. 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

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

  2. Max date range : 31 days

4

Vendor

Name of the vendor

Multi Select

5

Order Type

Type of Order

Multi Select

FAQs

Â