I am looking for a report that can tell us if a stocking location (bin) has a SKU defaulted to the location regardless of the current on hand stocking level.
For example, SKU# 12WD12 is defaulted to location 12.12.01.01 but currently that are 0 (zero) on hand.
|
Bin Location |
Item Number |
On hand |
Default |
|
12120101 |
12WD12 |
0 |
Yes |
|
12120102 |
NB65FG |
41 |
Yes |
|
12120103 |
38YH12 |
0 |
Yes |
|
12120104 |
87SD35 |
8 |
No |
|
12120105 |
902D34 |
0 |
Yes |
|
12120106 |
832W75 |
0 |
No |
Because we have a number of items we need to realign. We don’t want to realign them to empty/open locations that have a SKU defaulted to it.
Thank you very much for your assistance.
AndyWa