Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Aged Debtor Sales List


johnnysalt
 Share

Recommended Posts

Hello, I hope that somebody can help me. I have produced an accounting system using FM for my small design business. At the moment I produce statements in the invoice database by simply performing a search for 'Unpaid' invoices (this is a particular field in the db) and client name (another field).

 

I trying to set 4 fields that show the following at the end of the layout based on the search above,

 

30 - 60 days outstanding. Total amount.

60 - 90 days outstanding. Total amount.

90 - 120 days outstanding. Total amount.

120 plus outstanding. Total amount.

 

any help will be much appreciated.

 

Johnny

Link to comment
Share on other sites

As with most things, there are lots of ways to get to where you want. It depends on what other data might be useful along the way. Here is one method that could be condensed into fewer fields if required.

 

InvOutstanding (calculation, number)

= AmountInvoiced - AmountPaid

 

DaysOverdue (calculation, number, unstored)

= Case(InvOutstanding > 0, Get (CurrentDate) - DateInvoiced, 0)

 

Outstanding3060 (calculation, number)

= Case(DaysOverdue >= 30 and DaysOverdue

 

Outstanding3060.st (summary field)

= Total of Outstanding3060

 

Outstanding6090 (calculation, number)

= Case(DaysOverdue >= 30 and DaysOverdue

 

Outstanding6090.st (summary field)

= Total of Outstanding6090

 

Outstanding90120 (calculation, number)

= Case(DaysOverdue >= 30 and DaysOverdue

 

Outstanding90120.st (summary field)

= Total of Outstanding90120

 

Outstanding120 (calculation, number)

= Case(DaysOverdue >= 120, InvOutstanding)

 

Outstanding120.st (summary field)

= Total of Outstanding120

 

See how you go with that. :cool:

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use