By using this website, you agree to our Terms of Use (click here)
I'm creating this GI to show the cash flow on all of our projects. The formula will ultimately be this: (Project Revenue - Project AR Balance = Cash Flow In) - (Project COGS - Project AP Balance = Cash Flow Out) = Project Cash Flow. One project per line. But I'm starting with the AP and AR Balances as they seemed to be easiest to start with.
My problem is that my GI combines each AP Bill with each AR Invoice so the totals are many times too high when summed.
I think I have a table relation problem. Anyone have any insights?
Try this technique. I've used it many times. It works perfectly!
I like that technique that Royce linked to so much that I wrote a blog post about it:
https://www.augforums.com/the-wyatt-erp-technique-for-generic-inquiries
Note that you could also use a SQL View with a UNION statement in this situation.