3 Replies Latest reply: May 13, 2012 11:24 PM by Anosh Nathaniel RSS

    Transactions (invoices) vs. customer master data credit limits

    John Lauridsen

      Hi

       

      I have an accounting database with a lot of unpaid invoices, where I would like to group these into an aging balance 0-7days, 7-30days, 30-60 and 60->

      I have not done this in the script but in the charts.

       

      One expression is:

      Header 1Header 2

      =

      sum(IF(FORFALDSDATO>today()-30 and FORFALDSDATO<today()-7,FORFALDENFAKTURABELØB,0))
      eq to duedate between 7-30 days

       

      On the customer masterdata I have a field for the credit limit. Now I would like to have a chart with the sums of the different overdue invoices (per customer, per overdue age) and also the value of the credit limit. In the end I would like to be able to sum my total credit limit and the total of the customer balances (overdue and not due.