"30 Days End of Month" payment terms

This post has 12 Replies | 0 Followers

Male
26 Posts
174 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,549 Posts
151,742 Points
Joined: 2000-11-3
Last Online:
2016-2-8 20:18
Location: UK
DynamicsMVP
ModeratorDynamicsNAV
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

  • | Post Points: 5
Male
26 Posts
174 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
  • | Post Points: 5
Male
454 Posts
2,375 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

  • | Post Points: 5
169 Posts
1,133 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
  • | Post Points: 5
Male
11,549 Posts
151,742 Points
Joined: 2000-11-3
Last Online:
2016-2-8 20:18
Location: UK
DynamicsMVP
ModeratorDynamicsNAV
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

  • | Post Points: 5
123 Posts
682 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)
  • | Post Points: 5
Male
11,549 Posts
151,742 Points
Joined: 2000-11-3
Last Online:
2016-2-8 20:18
Location: UK
DynamicsMVP
ModeratorDynamicsNAV
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

  • | Post Points: 5
Male
454 Posts
2,375 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

  • | Post Points: 5
Male
11,549 Posts
151,742 Points
Joined: 2000-11-3
Last Online:
2016-2-8 20:18
Location: UK
DynamicsMVP
ModeratorDynamicsNAV
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

  • | Post Points: 5
Male
454 Posts
2,375 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

  • | Post Points: 5
Male
11,549 Posts
151,742 Points
Joined: 2000-11-3
Last Online:
2016-2-8 20:18
Location: UK
DynamicsMVP
ModeratorDynamicsNAV
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

  • | Post Points: 5
204 Posts
1,018 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
  • | Post Points: 5
Page 1 of 1 (13 items) | Get this RSS feed