AnsweredAssumed Answered

"Keep control" report

Question asked by LeszekŁuczkanin on Jun 20, 2017
Latest reply on Jun 20, 2017 by erolst

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?

Outcomes