MonsterCR7
New Member
- Joined
- Jun 27, 2013
- Messages
- 29
I have a tricky situation...i am recreating an Aging Report and have been able to show all invoices for a customer with both the invoice and payment or credit memo and have the total shown in the apply to group footer...some more background would be that the report is grouped by the apply to number, therefore the invoice and payment or credit memo all have the same apply to number...
The tricky situation is i now only want my report to show invoices that still are open and contain a balance...is there a way to do this in report format or do i have to go back to the query and enter in a formula there(report is based off a query)?
The tricky situation is i now only want my report to show invoices that still are open and contain a balance...is there a way to do this in report format or do i have to go back to the query and enter in a formula there(report is based off a query)?
