Provides details of Inward Orders at PO SKU level
| 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 | PO Date | Purchase order date | NA | 2023-01-01 |
| 5 | PO No | Purchase order no. | NA | abc145 |
| 6 | Parent Order ID | Parent Order Code | NA | abc245 |
| 7 | Order Type | Type of Order | NA | abc24 |
| 8 | Order Status | Status of order | NA | abc144 |
| 9 | Vendor Name | Supplier Name | abc333 | |
| 10 | Vendor City | City of Partner | abc345 | |
| 11 | Client SKU ID/EAN | client sku id | NA | abc244 |
| 12 | Brand | Brand | NA | abc345 |
| 13 | SKU Desc | Sku description | NA | abc345 |
| 14 | Style | Style | NA | acb345 |
| 15 | Size | Size | NA | abc433 |
| 16 | color | color | NA | abc134 |
| 17 | MRP | MRP | NA | 123.50 |
| 18 | Value | cost price | NA | 1323.50 |
| 19 | HSN Code | HSN ID | NA | abc123 |
| 20 | Vendor Tin | Vendor GSTIN | abc145 | |
| 21 | PO Qty | Purchase quantity | NA | 12343 |
| 22 | Pass Qty | QC Passed Quantity | NA | 123 |
| 23 | Fail Qty | QC Failed Quantity | NA | 23 |
| 24 | Received Qty | Quantity we received | NA | 134 |
| 25 | Putaway Qty | Putaway quantity | NA | 123 |
| 26 | Pending Putaway Qty | Pending Putaway quantity | NA | 123 |
| 27 | Pending GRN Qty | Quantity which is not yet GRN. | NA | 123 |
| 28 | Remarks | Remark | abc444 |
| 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 Created Time | 1. Max date range : 31 days |
| *sm | |||
| 4 | PO Number | Purchase Order ID | *sm |
| 5 | Vendor | Partners | Multi text input |
| 6 | PO Status | Purchase order status | Multiple select |
| 7 | Client SKU ID/EAN | Client sku Id | Single text Input |