AnsweredAssumed Answered

Account Ageing

Question asked by DanielHirtenstein on Aug 13, 2010
Latest reply on Aug 13, 2010 by philmodjunk


Account Ageing


FileMaker Pro



Operating system version

Mac OSX 10.5

Description of the issue

I am trying to work out how to set up a field or fields that calculate how long a payment has been unpaid. eg 30 days, 30-60 days, 90+ days. It would be working off a global date field that calculates the current date when the my related files open using "InsertCurrentDate" in my open file script.

I have a related transaction file that generates transactions for each client but have no way of tracking how long a transaction has been unpaid for. This is known as "account ageing".

Any ideas on whether there are calculations that can be done in filemaker to put together a script that would calculate a result based on how many days/weeks have elapsed from the date when any given transaction was generated, since the current date? This would allow me to create a report every month. I can currently run a report of all transactions unpaid but cannot categorise them.