AGOS Network
New Member
Hi Experts,
Need help in-regards to our small inventory.
Basically in the excel file there are two sheets, one for stock in and another is usage.
Stock is placed in warehouse location and boxes with numbers.
My main concern here is based on the usage there is new BYD P/N which will be used from some location and I want to deduct the QTY from the Stock in based on the BYD P/N usage and location and box (if there is box number in usage) from the stock. If the QTY is 0 move to another row and search and deduct.
So the criteria is on the usage check for the BYD P/N, location & box and match it to STOCK IN BYD P/N, location & box and deduct the usage qty if all match and if 0 stock left on stock in go to another row and check.
I hope I was able to explain my concern properly.
Please if their is any further explanation needed let me know.
TIA.
Need help in-regards to our small inventory.
Basically in the excel file there are two sheets, one for stock in and another is usage.
Stock is placed in warehouse location and boxes with numbers.
My main concern here is based on the usage there is new BYD P/N which will be used from some location and I want to deduct the QTY from the Stock in based on the BYD P/N usage and location and box (if there is box number in usage) from the stock. If the QTY is 0 move to another row and search and deduct.
So the criteria is on the usage check for the BYD P/N, location & box and match it to STOCK IN BYD P/N, location & box and deduct the usage qty if all match and if 0 stock left on stock in go to another row and check.
I hope I was able to explain my concern properly.
Please if their is any further explanation needed let me know.
TIA.