I have now attached example. Hopefully that clarifyis the problem.
AS you can see in this case I can see "Accounts Receivables" only in May although the orderID 2 will be paid in July and that means that it would be reported as receivables still in end of June.
- Receivables in the end of May 3000+1000=4000 is correct cause orderID 3 is already paid in May 15th
- There should be receivables under June also (1000) cause OrderID 2 is due in July 9th.
Any ideas how to get that June reported also?
test.qvw 180.5 K