C
Christie - IKC
I have created a database to calculate cash flow projections using the
invoice date and adding the terms for each customer to the date. It works
great for customers who pay 30, 60, etc. However, I have some customers who
pay 60 days or on the 5th day of the month, whichever comes last and I'm not
sure how to calculate that. I started to do a query, but I'm not sure that's
the best way. Can anyone help me?
invoice date and adding the terms for each customer to the date. It works
great for customers who pay 30, 60, etc. However, I have some customers who
pay 60 days or on the 5th day of the month, whichever comes last and I'm not
sure how to calculate that. I started to do a query, but I'm not sure that's
the best way. Can anyone help me?