This content has been marked as final. Show 4 replies
Here's a tough case:
How do you calculate the stock available after a sale by using two tables - one for the
sales and another for the deliveries?
I ran into the following problem: as I join the two tables of the sales and the
deliveries together, for each sale I have to get the delivered quantity for the period before the sale (Date>SupplyDate) and calculate the remaining quantity. I can't figure out how to make this work. Any ideas?
For example look at the file attached...