Jump to content

Statement of Accounts


zalephoto

This topic is 8169 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I have successfully laid out a statement using a portal to list all of the client's outstanding invoices. The portal row contains:

Invoice date, Invoice Number, Job description and Invoice amount.

My problem is the following:

How do I break out the amounts in the portal and total them into separate areas (on the statement)for

30 Days

60 Days

90 Days

120+Days

Obviously given the fact that I have successfully bloodied myself I now realize this formula(?) Is beyond my reach. I am hoping I can receive some help. Thanks.

Link to comment
Share on other sites

First, you really want to print this statement from the related file, not from the main file using a portal. In the related file you can sort and summarize to a report with multiple levels of subsummaries. You can then have a client subsummary (leading and trailing) and subsummaries by period. To break the invoices into aging groups, create a calculation:

Aging Group (calculation, number) =

Case(

Today - InvoiceDate < 30, 30,

Today - InvoiceDate < 60, 60,

Today - InvoiceDate < 90, 90,

.

.

.

,"")

Sort and subsummarize by Client first and Aging Group second.

-bd

Link to comment
Share on other sites

This topic is 8169 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.