1 Reply Latest reply on Aug 13, 2010 10:53 AM by philmodjunk

    Account Ageing



      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.