Inward Report at PO SKU Level - OMS
- Prakash Nagulapati
Navigate To:
- 1 Description
- 2 Fields
- 3 Filters
- 4 FAQs
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 | Fulfilllment Location Name | Name of the Fulfilment Location | NA | wms_abc |
| 3 | Fulfillment Location City | City of the Fulfilment Location | NA | Bengaluru |
| 4 | Fulfillment Location ID | Increff’s Internal ID of Fulfillment Location | NA | 1891238124 |
| 5 | Gate Entry ID | gate entry no | NA | 123456789 |
| 6 | PO Date | Purchase order date | NA | 2023-01-01 |
| 7 | Vendor Invoice No | External invoice number. | NA | abc134 |
| 8 | Vendor Invoice Date | External Invoice Date. | Yes if the external invoice is not present. | 2023-01-01 |
| 9 | PO No | Inward Purchase Order ID | Yes if the order is not placed by any channel. | abc245 |
| 10 | Parent Order ID | Order ID of parent order | NA | abc245 |
| 11 | Order Type | Type of Order | NA |
|
| 12 | Order Status | Status of the Order | NA |
|
| 13 | Vendor Name | Partner Name | Â | abc333 |
| 14 | Vendor ID | Partner ID | Â | 1243234322 |
| 15 | Vendor City | City of Partner | Â | abc345 |
| 16 | Client SKU ID/EAN | client sku id | NA | abc123 |
| 17 | Channel SKU ID | Channel SKU ID | NA | 123445566 |
| 18 | SKU Desc | Sku description | If not configured in Article/SKU Master | abc345 |
| 19 | Style | Style | If not configured in Article/SKU Master | acb345 |
| 20 | Size | Size | If not configured in Article/SKU Master | abc433 |
| 21 | Color | Color | If not configured in Article/SKU Master | abc134 |
| 22 | MRP | MRP | If not configured in Article/SKU Master | 123.50 |
| 23 | Value | Â | Â | 123.40 |
| 24 | Brand | Brand | If not configured in Article/SKU Master | abc345 |
| 25 | LR No | AWB Number | Â | abc123 |
| 26 | Vehicle No | Vehicle Number | Â | abc123 |
| 27 | HSN Code | Â | If not configured in Article/SKU Master | abc123 |
| 28 | Vendor Tin | GST Number | Â | abc123 |
| 29 | PO Qty | Purchase quantity | NA | 12343 |
| 30 | Pass Qty | QC Passed Quantity | NA | 123 |
| 31 | Fail Qty | QC Failed Quantity | NA | 23 |
| 32 | Received Qty | Quantity Received | NA | 134 |
| 33 | Putaway Qty | Putaway | Â | 123 |
| 34 | Pending Putaway Qty | Pending Putaway Quantity | Â | 123 |
| 35 | Pending GRN Qty | Quantity which is not yet GRNed. | Â | 123 |
| 36 | Balance Qty | Out of the qty received against the particular PO, the qty that is still part of Increff’s System (WMS inventory) |  | 134 |
| 37 | Gate Entry Created Time | Gate entry created time | Â | 2023-01-01 12:34:56 |
| 38 | GRN Start Time | Grn Start time | Â | 2023-01-01 12:34:56 |
| 39 | Gate Entry Closed Time | Gate entry closed time | Â | 2023-01-01 12:34:56 |
| 40 | Latest GRN Time | Latest GRN time | Â | 2023-01-01 12:34:56 |
| 41 | Latest Putaway Time | Latest Putaway Time | Â | 2023-01-01 12:34:56 |
| 42 | Gate Entry Status | Gate entry status | Â |
|
| 43 | Gate Entry Updated Time | Gate entry updated time | Â | 2023-01-01 |
| 44 | 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 |
FAQs
Â