Customer ID (pk)
Operation ID (pk)
Customer ID (fk)
I have 3 types of customers:
- Has to pay tax fixed - every month the same amount.
- Has to pay tax unfixed - every month different value
- Doesn’t have to pay
At the end of the year I give back 20% of taxes that was paid to me, so I need to summarize this incomes for everyone and then count 20% of it. And check if I pay it out.
I need a tool which will show me summary of all customers that has to pay with an amount every one paid each month. I also would like to have a portal (or anything) in my CUSTOMER layout to see how this particular customer was paying this year.
Problem is, that some of customers pay once a month all amount, while another pays few times a month, so sometimes it is 1x 4000,00 $ and another time it is 4 x 1000,00 $ a month.
Any ideas, please?