Navigate To:
Description
Inward Orders at PO SKU, Gate Entry level data is populated
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_abc |
| 3 | Fulfilment Location City | City of the Fulfilment Location | NA | Bengaluru |
| 4 | Gate Entry ID | gate entry no | NA | 123456789 |
| 5 | PO Date | Purchase order date | NA | 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 | NA | abc245 |
| 10 | Order Type | Type of Order | NA |
|
| 11 | Order Status | Status of the 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 | Channel SKU ID | Channel SKU ID | NA | 123445566 |
| 16 | SKU Desc | Sku description | If not configured in Article/SKU Master | abc345 |
| 17 | Style | Style | If not configured in Article/SKU Master | acb345 |
| 18 | Size | Size | If not configured in Article/SKU Master | abc433 |
| 19 | Color | Color | If not configured in Article/SKU Master | abc134 |
| 20 | MRP | MRP | If not configured in Article/SKU Master | 123.50 |
| 21 | Value | 123.40 | ||
| 22 | Brand | Brand | If not configured in Article/SKU Master | abc345 |
| 23 | LR No | AWB Number |
| abc123 |
| 24 | Vehicle No | Vehicle Number |
| abc123 |
| 25 | HSN Code |
| If not configured in Article/SKU Master | abc123 |
| 26 | Vendor Tin | GST Number | abc123 | |
| 27 | PO Qty | Purchase quantity | NA | 12343 |
| 28 | Pass Qty | QC Passed Quantity | NA | 123 |
| 29 | Fail Qty | QC Failed Quantity | NA | 23 |
| 30 | Received Qty | Quantity Received | NA | 134 |
| 31 | Putaway Qty | Putaway | 123 | |
| 32 | Pending Putaway Qty | Pending Putaway Quantity | 123 | |
| 33 | Pending GRN Qty | Quantity which is not yet GRNed. | 123 | |
| 34 | Balance Qty | 134 | ||
| 35 | Gate Entry Created Time | Gate entry created time | 2023-01-01 12:34:56 | |
| 36 | GRN Start Time | Grn Start time | 2023-01-01 12:34:56 | |
| 37 | Gate Entry Closed Time | Gate entry closed time | 2023-01-01 12:34:56 | |
| 38 | Latest GRN Time | Latest GRN time | 2023-01-01 12:34:56 | |
| 39 | Latest Putaway Time | Latest Putaway Time | 2023-01-01 12:34:56 | |
| 40 | Gate Entry Status | Gate entry status |
| |
| 41 | Gate Entry Updated Time | Gate entry updated time | 2023-01-01 | |
| 42 | Remarks | Remark | abc444 |
Filters
Filters | Description | Limitation | |
|---|---|---|---|
| 1 | Client | Name of the client | Mandatory |
| 2 | Fulfilment Location | Name of the Fulfilment Location | Mandatory |
| 3 | PO Created From - PO Created To | To filter the report based on PO Creation Timestamp | Max date range : 92 days |
| 4 | Vendor | Partners | Multi select input |
| 5 | PO Number | Purchase Order ID | Multi Text Input |
| 6 | Client SKU ID/EAN | Client sku Id | Single text Input |
| 7 | Order Type | Partners | Multi select input |
| 8 | Gate Entry Created From - Gate Entry Created To | To filter the report based on Gate Entry Creation Timestamp | Max date range : 92 days |