Inward Extra Item Detail Report - WMS
- Prakash Nagulapati
Navigate To:
- 1 Description
- 2 Fields
- 3 Filters
- 4 FAQs
Description
Provides PO and Gate entry wise Extra Item details such as Extra Box ID, Extra Item Status, Item ID etc. which can be filtered based on PO and Gate Entry dates.
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 Fulfillment/Warehouse location | NA | wms_hsr |
| 3 | Gate Entry ID | Increff’s unique Id for each gate entry. | 123 | 12355667 |
| 4 | Gate Entry Date | Date when the gate entry is created. | NA | 2023-01-01 |
| 5 | PO No | Purchase Order Number | NA | abc245 |
| 6 | PO Date | Inward Order Date | Yes if the order is not placed by any channel. | 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 | Vendor Name | Supplier/Vendor from whom the inward order is received | NA | abc134 |
| 10 | Item ID | Increff’s Unique Item ID | NA | 1234566778 |
| 11 | External Item Code | item id generated by the client. If it’s not present then we will show increff’s item id. | NA | 1234566778 |
| 12 | Extra / Excess | Extra : When more quantity is received than expected for an SKU which is already present in PO Excess : When items of an SKU that are not present in the PO are received | NA |
|
| 13 | Extra Item Creation Time | Creation time of extra item | NA | 2023-01-01 12:34:56 |
| 14 | Extra Item Updated Time | Updated time of extra item | NA | 2023-01-01 12:34:56 |
| 15 | Extra Item Status | status of the extra item | NA |
|
| 16 | Extra Box ID | Increff’s Unique Extra Box ID | NA | 123455678 |
| 17 | Lot ID | Increff Lot ID | NA | 123455678 |
| 18 | External Box ID | External Box ID | Â | abc123 |
| 19 | Global SKU ID | Increff’s Unique sku id | NA | 123455678 |
| 20 | Client SKU ID | client sku id/EAN | NA | abc123 |
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 on PO created time | NA |
| 4 | Extra Box ID | Extra Box ID | Single input |
| 5 | External Invoice ID | Vendor invoice ID | Single input |
| 6 | Status | Status of the Items. | NA |
| 7 | Extra Item Created From - Extra Item Created To | To filter the report on Extra Item created time | NA |
| 8 | Extra Item Updated From - Extra Item Updated To | To filter the report on Extra updated time | NA |
| 9 | Gate Entry From - Gate Entry to | To filter the report on Gate Entry time | NA |
FAQs
Â
Â
Â