OK, I edited OP to make it easier to understand. Hopefully, it makes more sense now.
So my STOCK.QTY of ABC in bin DMG is 5. I need to show only the latest transactions that will match the qty of stock. So while there are 5 records in the STOCKTRANSACTIONS for ABC, I need it stop printing...
Sorry, made it confusing with transaction numbers, trying to simplify the issue.
TXN 5 is for a different product(DFE), so OH QTY for DFE is 1. And adding other transactions for ABC, you get OH QTY = 5. Each transaction just shows the adjustment for the product at that transaction, not how...
Hi there,
I have 2 tables: STOCK table and STOCKTRANSACTIONS table. The stock table shows me how much product I have in every bin right now. STOCKTRANSACTIONS have every product transaction recorded (could be in multiple bins). I am trying to display all the latest transactions that apply to a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.