I’m trying to incorporate the amount paid into a progress report for the projects in the construction module. I have still not been able to figure out how to build the relationships correctly between the tables and have it happen.
These are the current tables in the report:
And these are the relationships that work so far:.
This is what my report looks like, but the “Balance” Collumn is what I’m looking at. I want to show either the amount already paid, or the balance still owed off of current invoiced amount.
Any suggestions?
Best answer by meganfriesen37
View original