How to handle amount carry over

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We pick up items from customers. We pay them every three months for the
customers only the accumulated amount reaches a certain number and their
account becomes "0", for the rest the amount will carry over for next quarter.

How do I handle this situation?

Any suggestion is highly appreciated.
 
Query for those in the last 3 months that meet the criteria. Pay them.
Flag them as such.
Query for those from the previous 3 months that did NOT meet the criteria.
Add their current 3 months. If they meet the criteria, pay them and flag
them as such.

Hope that none of them span a 6 month period, or set a regulation that they
get paid after that time, too.
 
Back
Top