How to calculate days due?

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I have a table (tblTerms) with 2 fields [strTerms] & [dblDaysDue]. The
typical terms in the table would be 2%10 Net 30 with [dblDaysDue] having a
value of 30. I then take the difference between the ship date from the
invoice and the paid date to calculate if they are paying within terms.
Everything works well, but now there's a customer with terms of 6/1. How can
I calculate if they are paying within terms when the number of days due
changes everyday?

Thanks



Jim
 
What does "6/1" mean with respect to terms? I have no idea how to interpret
what that means with respect to your post. Help us understand how it's to be
interpreted.
 
Hello,
Sorry, 6/1 means terms of June 1.

Jim

Ken Snell said:
What does "6/1" mean with respect to terms? I have no idea how to
interpret what that means with respect to your post. Help us understand
how it's to be interpreted.

--

Ken Snell
http://www.accessmvp.com/KDSnell/


Jim said:
I have a table (tblTerms) with 2 fields [strTerms] & [dblDaysDue]. The
typical terms in the table would be 2%10 Net 30 with [dblDaysDue] having a
value of 30. I then take the difference between the ship date from the
invoice and the paid date to calculate if they are paying within terms.
Everything works well, but now there's a customer with terms of 6/1. How
can I calculate if they are paying within terms when the number of days
due changes everyday?

Thanks



Jim
Click to expand...
Click to expand...
 
So, how would you calculate the number of days due? Is it a countdown from
the shipping date to the next June 1 date? Or something else? Show us some
examples using data.

--

Ken Snell
http://www.accessmvp.com/KDSnell/


Jim said:
Hello,
Sorry, 6/1 means terms of June 1.

Jim

Ken Snell said:
What does "6/1" mean with respect to terms? I have no idea how to
interpret what that means with respect to your post. Help us understand
how it's to be interpreted.

--

Ken Snell
http://www.accessmvp.com/KDSnell/


Jim said:
I have a table (tblTerms) with 2 fields [strTerms] & [dblDaysDue]. The
typical terms in the table would be 2%10 Net 30 with [dblDaysDue] having
a value of 30. I then take the difference between the ship date from the
invoice and the paid date to calculate if they are paying within terms.
Everything works well, but now there's a customer with terms of 6/1. How
can I calculate if they are paying within terms when the number of days
due changes everyday?

Thanks



Jim
Click to expand...
Click to expand...
Click to expand...
 
Back
Top