I’m trying to figure out how to calculate the qty of a specific barcode.
Table #1 has a column with total qty with a specific barcode.
Table #2 has stock movement (+1 or -1 attached to a specific barcode, on a row )
How do I get the “total qty” to tally up the numbers from Table #2 using the barcode and qty #?