I should have been more clear. I don't want to delete the actual bin location, just the data showing in it. When I have 0 on-hand in a bin, I don't want the reporting to show previous part numbers that were in those bins, along with their lot #'s. I want those to disappear when the value of that part number hits 0. Some of the bins below have product in them and that I want to see. But the others with 0 on hand I don't want to see the old part number or the old lot #.
| Bin Location | | Part Number | | On Hand | | Lot Number |
| 3A14B | | | | | | |
| | | TA2-2B-T72-BLK (Dual Motor Height Adjustable Desk Base) | Dual Motor Height Adjustable Desk Base | 0.00 | | 7-23-20 |
| | | AIM02E002 (Electric Height Adjustable Desk Base Dual motor-3stage rectangular co... | Electric Height Adjustable Desk Base Dual motor-3stage rectangular column, Grey | 0.00 | | 9-24-20 |
| | | AIMYJYTAJ002 ("Electric Height Adjustable Desk Base without motor-2stage rectang... | "Electric Height Adjustable Desk Base without motor-2stage rectangle column, Gray" | 31.00 | | 1-18-2021 |
| 3C3A | | | | | | |
| | | AIM02E001 (Electric Height Adjustable Desk Base Dual motor-3stage rectangular co... | Electric Height Adjustable Desk Base Dual motor-3stage rectangular column ,Black | 0.00 | | 9-25-20 |
| | | AIMDP-12W (Table Top particle board 1200mm) | Table Top particle board 1200mm | 0.00 | | |
| 3C3B | | | | | | |
| | | AIM02E001 (Electric Height Adjustable Desk Base Dual motor-3stage rectangular co... | Electric Height Adjustable Desk Base Dual motor-3stage rectangular column ,Black | 0.00 | | |
| | | AIM02E003 (Electric Height Adjustable Desk Base Dual motor-3stage rectangular co... | Electric Height Adjustable Desk Base Dual motor-3stage rectangular column, White | 0.00 | | |
| | | AIMYJYTZB3002 (Electric Height Adjustable Desk Base-Dual motor-3stage rectangular... | Electric Height Adjustable Desk Base-Dual motor-3stage rectangular upside down column ,Gray | 30.00 | | 1-18-2021 |
| 3C3C | | | | | | |
| | | AIM01EDB2002 (Electric Height Adjustable Desk Base Dual motor-2stage rectangular... | Electric Height Adjustable Desk Base Dual motor-2stage rectangular column Grey | 0.00 | | |
| | | AIM02E001 (Electric Height Adjustable Desk Base Dual motor-3stage rectangular co... | Electric Height Adjustable Desk Base Dual motor-3stage rectangular column ,Black | 0.00 | | |
| | | AIMYJYTAJ001 ("Electric Height Adjustable Desk Base without motor-2stage rectang... | "Electric Height Adjustable Desk Base without motor-2stage rectangle column, Black" | 27.00 | | 1-18-2021 |
