Hey clever Jet Pilot people..
I need a Jet formula that can tell me the SUM of what invoices were 60 and 90 days overdue without having to replicate out to the invoice detail level. Is it not possible to SUM any entries with filters from the Det. Cust. Ledg. Entry table to get a total value of overdue Invoices? Note also that we do not use the Due Date field on Invoices. We are aging by Posting Date.
In the attached example I can get a Balance at a date no problem. But I need to get a balance of 60 and 90 day outstanding invoices. My formulas are obviously not right but I'm kind of stuck as to how what to do.
Any help or clever ideas will be greatly appreciated.
0 comments
Please sign in to leave a comment.