Inventory Reco - OMS
- Prakash Nagulapati
Navigate To
- 1 Description
- 2 Fields
- 3 Filters
- 4 FAQs
Description
Contains warehouse wise Total Outwards, Total Inwards, Total Returns, Total Items in various stages, System storage, Inventory and Lost quantities. Helps with Inventory Reconcilation.
Fields
Fields | Description | This column can be null | Sample Data | |
|---|---|---|---|---|
| 1 | Client Name | Name of the Client | NA | Increff |
| 2 | Fulfilment Location Name | Name of the Fulfilment Location | NA | wms_hsr |
| 3 | Total Inward(A) | Total inward quantity | NA | 123 |
| 4 | Outwards(B) | Total outward quantity | NA | 123 |
| 5 | Total Returns(C) | Total return received quantity | NA | 123 |
| 6 | Derived Inventory F=(A+C)-B | Total quantity available in inventory | NA | 123 |
| 7 | GRN(G) | Items grned in last 3 days | NA | 123 |
| 8 | LIVE(H) | Items which are in Live status | NA | 123 |
| 9 | OFFLINE(I) | Items which are in offline status in the last 3 days | NA | 123 |
| 10 | RECYCLE(J) | Items which are in recycle status in the last 3 days | NA | 123 |
| 11 | PICKED(K) | Items which are in Picked status | NA | 123 |
| 12 | PACKING(L) | Items which are in Packing status | NA | 123 |
| 13 | PACKED(O) | Items which are in Packed status | NA | 123 |
| 14 | System Inventory M=(G+H+I+J+K+L+O) | Â | NA | 123 |
| 15 | Shortage N=(F-M) | Â | Â | Â |
| 16 | LOST | Items which are in Lost status | NA | 123 |
| 17 | PERMANENT LOST | Items which are permanently lost | NA | Â |
| 18 | OLD OFFLINE | Items which are in offline status before the last 3rd day | NA | 123 |
| 19 | OLD RECYCLE | Items which are in recycle status before the last 3rd day | NA | 123 |
| 20 | OLD GRN | Items which are in grned status before the last 3rd day | NA | 123 |
Filters
Filters | Description | Limitation | |
|---|---|---|---|
| 1 | Client | Name of the client | Mandatory |
| 2 | Time Zone | To show data in the specified time zone | Mandatory |
| 3 | Fulfilment Location Name | Name of the Fulfilment Location | Mandatory |
FAQs
Â