2 Replies Latest reply on Jun 20, 2017 5:14 AM by erolst

    "Keep control" report

    LeszekŁuczkanin

      Hi,

       

      in my database I have a fields:

       

      OPERATION ID

      CUSTOMER

      AMOUNT

      DATE

      DESCRIPTION

      OPERATION MONTH

      OPERATION YEAR

      TAX

       

      Every customer has to pay each month a tax which is set for every month and different for everyone. Some of them pay once a month, others few times a month (partially).

      I need a report with a table like this

       

      TAXJanuaryFebruaryMarch...NovemberDecemberTOTAL25% of Total
      Customer 11000 $1000 $1000$1000$1000$11 000 $2750 $
      Customer 22020 $500 + 500 +1000 $2000 $20201010 $21 170 $5292,5
      Customer 3500 $500 $500 $500 $500 $5500 $1375 $
      ...
      Customer 120890 $890 $890 $ 0 $ !!!890 $8900 $2225 $

       

       

      It will help me check if everything is paid on time.

       

      Any ideas?