Hello, I need help for a sales report.
This report is an example to explain my problem.
I have some products that are sold and others that are bought. They are not the same product. For example when I buy beer, I buy a barrel, but when I sell beer, I sell a jug. They are different product codes. I have a table to relate both products.
The report gives me the sales between the 2 selection dates, and what I need to find the price at which a product was purchased before the selected dates.
In the example, in May I sold 7 beer jar, but the last barrel of beer I bought in March and I need to get that price. I managed to get the date of the last purchase, but I can't get the price. In the example the price should be 45. And if I choose february the price should be 40.
Any help will be appreciated
