Inventory Allocation based on Warehouses near expiry and less Qty location

Status
Not open for further replies.

majid

New member
Joined
Oct 22, 2018
Messages
6
Reaction score
0
Points
0
Location
pakistan
Excel Version(s)
2013
Hi all,
i need your help to identify Pick items based on near expiry and less qty location warehouses. i do on a sheet manually to present what i want. its a scenario based problem. kindly tell me if it is possible pivot table. please review the attached sheet.
i want first Qty, Location and Lot based on above criteria.
Thanks
 

Attachments

  • PICT ITEM EXPIRYWISE.xlsx
    13.9 KB · Views: 20
Hi all,
you can change this Data by warehouse, like where W-1 Data end to paste W-2 Data and so on. actually this data are in four sheets W-1, W-2, W-3 and W-4.
 
Again no link added to cross post. Already warned multiple times. Banned 7 days.Thread closed
 
Last edited:
Status
Not open for further replies.
Back
Top