"30 Days End of Month" payment terms

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

This post has 12 Replies | 0 Followers

Male
26 Posts
344 Points
Joined: 2004-8-19
Last Online:
2007-11-14 16:07
Location: Oxford, UK
Mark Aspinall Posted: 2004-8-19 14:07 | Locked
For the first time in a while, I have arrived at the site of a client who wants to be able to set payment terms as "net month end" (i.e. 30 days from the end of current month.)

This is something which I haven't come across since I last looked at Sage (the pain [xx(]) and I have never seen it work in Navision, although I know some have tried.

Anyone got any experience of making this work. My initial response to my client has been that it is not likely, but I promised to investigate.

I have been playing with the formulae in the payment terms table to little effect (other than managing to apply terms of 30 months and 30 years respectively!!)

Thanks in anticipation...
Mark E Aspinall Consultant Project Manager
Male
11,031 Posts
177,863 Points
Joined: 2000-11-3
Last Online:
2014-9-21 20:12
Location: UK
DynamicsNAVMVP
Moderator
AdamRoue replied on 2004-8-19 14:19 | Locked
Hi

Try CM+30D [:D]

“Any fool can know. The point is to understand.”
Albert Einstein

Male
26 Posts
344 Points
Joined: 2004-8-19
Last Online:
2007-11-14 16:07
Location: Oxford, UK
Mark Aspinall replied on 2004-8-19 15:02 | Locked
Thanks Steven

It seems to work perfectly...
Mark E Aspinall Consultant Project Manager
Male
454 Posts
2,920 Points
Joined: 2000-2-8
Last Online:
2011-5-24 8:34
Location: Glendale, CA
Henrik Helgesen replied on 2004-8-20 0:27 | Locked
Hmm - What's going to happen in February?

I would proberbly do something in the line of:

CM+1M

Henrik Helgesen, Navision Developer since 1995 LinkedIn profile @ http://helgesen.info | My blog @ http://eshipguy.com

169 Posts
1,648 Points
Joined: 2003-10-20
Last Online:
2009-9-9 19:13
Location: Cambridge UK
Meint Dijkstra replied on 2004-8-20 11:53 | Locked
Hi,

We use CM+1D+1M-1D and it seems to work perfectly...

Meint
Male
11,031 Posts
177,863 Points
Joined: 2000-11-3
Last Online:
2014-9-21 20:12
Location: UK
DynamicsNAVMVP
Moderator
AdamRoue replied on 2004-8-20 13:29 | Locked
Hi Henrik

February does not matter. CM+30D will go into March whether it is a leap year or not, it will mean the due date is just in early march, not 30 days into the subsequent month.

Hi Meint

How is CM+1D+1M-1D different from CM+1M. Doesn't it get to the same date?

“Any fool can know. The point is to understand.”
Albert Einstein

123 Posts
957 Points
Joined: 2000-11-23
Last Online:
2007-1-30 23:42
JSoage replied on 2004-8-20 14:02 | Locked
Is not the same if you are looking for month ends.

CALCDATE('CM+1M', 31/08/2004) = 30/09/2004

CALCDATE('CM+1M', 30/09/2004) = 30/10/2004 (it should be 31/10/2004)
Male
11,031 Posts
177,863 Points
Joined: 2000-11-3
Last Online:
2014-9-21 20:12
Location: UK
DynamicsNAVMVP
Moderator
AdamRoue replied on 2004-8-20 14:32 | Locked
hmmmm

Interesting one! [:D]

Still at least CM+30D always gives you 30 days from the EOM which is what the original question asked!!

“Any fool can know. The point is to understand.”
Albert Einstein

Male
454 Posts
2,920 Points
Joined: 2000-2-8
Last Online:
2011-5-24 8:34
Location: Glendale, CA
Henrik Helgesen replied on 2004-8-20 15:20 | Locked
quote:
Originally posted by SBWEAVER

hmmmm
Still at least CM+30D always gives you 30 days from the EOM which is what the original question asked!!



Steven -

Your profile says Implementation - You - off all people - should know, that it's not always what people ASK they need - You need to read between the lines [:D]

Henrik Helgesen, Navision Developer since 1995 LinkedIn profile @ http://helgesen.info | My blog @ http://eshipguy.com

Male
11,031 Posts
177,863 Points
Joined: 2000-11-3
Last Online:
2014-9-21 20:12
Location: UK
DynamicsNAVMVP
Moderator
AdamRoue replied on 2004-8-20 16:41 | Locked
Hi Henrik,

That is a good point, and as you are in development you will do exactly what they say, and then charge them again for making the changes they should have seen in the first place!!!

And remember the originator asked a question, I answered it and the response was
quote:
Thanks Steven

It seems to work perfectly...

No need to read between the lines!!

“Any fool can know. The point is to understand.”
Albert Einstein

Male
454 Posts
2,920 Points
Joined: 2000-2-8
Last Online:
2011-5-24 8:34
Location: Glendale, CA
Henrik Helgesen replied on 2004-8-20 17:50 | Locked
The word: 'seems' is key here [;)][:D]

Oh Well - It's friday, and only 4 - 5 hours from going to the martini bar [:o)]

Henrik Helgesen, Navision Developer since 1995 LinkedIn profile @ http://helgesen.info | My blog @ http://eshipguy.com

Male
11,031 Posts
177,863 Points
Joined: 2000-11-3
Last Online:
2014-9-21 20:12
Location: UK
DynamicsNAVMVP
Moderator
AdamRoue replied on 2004-8-20 18:32 | Locked
I'm off now. Have a good weekend!

“Any fool can know. The point is to understand.”
Albert Einstein

204 Posts
1,048 Points
Joined: 2002-3-28
Last Online:
2007-6-6 9:14
Location: milano Italy
silenced replied on 2004-8-23 18:09 | Locked
If you want to set the due date the end of the next month, you could use 1M+CM (the result is the same as using CM+1D+1M-1D)

Elena
Page 1 of 1 (13 items) | Get this RSS feed | Bookmark and Share