Forum Discussion
Create a new report
Hi Nathaniel,
Thank You for the reply
My data is in below template.
Org Code : are warehouse 1 and warehouse 2
CPN : are part numbers
Total On Hand qty : Stock
I'm tried the setups you have mentioned but bit lost with it.
May I ask to provide more details with steps, screen shots
Hi santu1021 ,
Just got online again. Would you copy and paste what you in that picture directly into this message. I will build a pbix with it and detail the steps.
Thanks,
Nathaniel
Warehouse 1 and 2 have common part numbers. I have over 1 billions lines and I need to run this daily report to take action.
scenario 1 : If same part number (ex part 1) is in stock at Both Warehouses : No action for me to take.
Scenario 2 : If same part number (ex part 2) is in stock at WH 1 and not in stock at WH2 : Action to take for me on WH2.
Scenario 2 : If same part number (ex part 3) is not in stock at WH 1 and is in stock at WH2 : Action to take for me on WH1.
Scenario 3 : If same part number (ex part 3) is not in stock at WH 1 and WH2 : Action to take for me on WH1 and WH2
WareHouse 1 and 2 Item No Stock Warehouse 2 Part 1 7 Warehouse 1 Part 1 315 Warehouse 2 Part 2 Warehouse 1 Part 2 100 Warehouse 2 Part 3 50 Warehouse 1 Part 3 0 Warehouse 1 Part 4 0 Warehouse 2 Part 4 0 is the blank 0
Yes, 0 is no stock at ware house