OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   Running & Setting Up Queries (http://www.officefrustration.com/forumdisplay.php?f=25)
-   -   How to calculate days due? (http://www.officefrustration.com/showthread.php?t=1119552)

Jim June 4th, 2010 06:29 PM

How to calculate days due?
 
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



Ken Snell June 4th, 2010 08:24 PM

How to calculate days due?
 
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" wrote in message
...
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





Jim June 7th, 2010 04:18 PM

How to calculate days due?
 
Hello,
Sorry, 6/1 means terms of June 1.

Jim

"Ken Snell" wrote in message
...
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" wrote in message
...
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








All times are GMT +1. The time now is 04:12 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
OfficeFrustration.com