Dear all
I have an inventory table with purchase and sales positions.
| ID | Type | Date | Quantity |
|---|
| A | Purchase | 31.01.2012 | 100,00 |
| A | Sales | 25.08.2012 | -50,00 |
| B | Purchase | 28.02.2012 | 222,00 |
| B | Sales | 01.05.2012 | -22,00 |
| C | Purchase | 31.01.2012 | 50,00 |
| C | Purchase | 01.08.2012 | 75,00 |
| C | Sales | 01.03.2012 | -25,00 |
| C | Sales | 01.10.2012 | -10,00 |
| D | Purchase | 31.12.2012 | 60,00 |
| ID | Type | Date | Quantity |
|---|
| B | Purchase | 28.02.2012 | 222,00 |
| D | Purchase | 31.12.2012 | 60,00 |
Can somebody help me out here ?
I do attach my sample qvw.
Thanks a lot.
Cheers
Joerg
Basing on Date 31.12.2012, I need to see all ID which had no Sales since 01.07.2012
The result should look like this
