Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you'd like some help with this I'd suggest you provide some example actual data to work with. It's difficult to understand your question without this. (For example what is in MonthEndDate / [Period in Month] - these are calculated fields, it's not obvious (well to me anyway).
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.
Any ideas how to get that June reported also?
Thanks
Regards
Janne
See attached qvw.