Inward Report at GRN UOM-SKU Level - OMS
Navigate To:
- 1 Description
- 2 Fields
- 3 Filters
- 4 FAQs
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 |
|
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 |
|
4 | Vendor | Name of the vendor | Multi Select |
5 | Order Type | Type of Order | Multi Select |
FAQs
Â