payment terms / due date formula

mweusten
Member Posts: 6
Hi, this is my first post. Let's see if it works...
One of our clients has the following payment term: due date = posting date + 45 days, where payment will be effected on the 15th of the month after the 45 days will be over.
How can I get a due date formula in NAV5.0 that will calculate the payment date instead of the due date? Is it even possible to fix a "hard" payment date?
Thanks for your help!
BR
Maurice
One of our clients has the following payment term: due date = posting date + 45 days, where payment will be effected on the 15th of the month after the 45 days will be over.
How can I get a due date formula in NAV5.0 that will calculate the payment date instead of the due date? Is it even possible to fix a "hard" payment date?
Thanks for your help!
BR
Maurice
0
Comments
-
Check code on OnValidate trigger of "Payment Term Code" field in Sales Header(36).0
-
Hi Vijay,
I can't find the OnValidate trigger, could you help? Is it in the C/AL?
Thanks,
Maurice0 -
Words are confusing... :oops:
Can you list an example?
Let's say I invoice you today (6/8/10). What should be the resulting due date? And what do you mean by Payment Date? Do you mean it'll be automatically paid on a date defined?Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
Example:
sales invoice date (posting date) = June 8, 2010
due date = invoice date + 45 days = June 8, 2010 + 45 days = July 23, 2010
effective payment date = next time it's the 15th of a month = August 15, 2010
In this case effective payment term is 68 days(!), but this changes of course with the posting date.
I would like to calculate automatically in NAV the effective payment date instead of the due date, as I do not want to summon my client earlier than his effective payment date (he wont pay earlier than that anyway).
Thanks.0 -
+45D+1M-CM+15D
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
0
-
Wow! This is a great tool!Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
Hi all,
thanks for your support. The given formula solves many dates, but not all:
sales invoice date (posting date) = June 30, 2010
due date = invoice date + 45 days = June 30, 2010 + 45 days = August 14, 2010
effective payment date = next time it's the 15th of a month = August 15, 2010
Using the date formula, I would get June 30 + 45D = August 14 + 1M = September 14 - CM = September 1 + 15D = September 16, so one entire month later. Is there a possibility to conditionally generate the right date? For example:
If due date < 15th of a month then due date = 15th of a month else due date = 15th of the next month0 -
Not without modification...Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
That's what I thought, too bad
Thanks all!
0 -
Not so fast. You can set up an if by first deducting the no. of days. This formula should do it:
-15D+45D+CM+15D (maybe -14D+45D+CM+15D, that depends on <15th or <=15th).Frank Dickschat
FD Consulting0 -
Hi,
To get "the next 15th" of a month - use D15 keyword. Or any dates term (D,M,Y,W) prior to number to get the next date.
For example:
date1 := 2013 January 14
date2 := 2013 January 16
CALCDATE(<D15>,date1) will return January 15th
CALCDATE(<D15>,date2) returns February 15th
I'm sure you can do the rest. Well, at least that's how it work in NAV2009;
What I'm looking for is the term like:
exactly 75 days if the invoice is issued before 15th of any month, and 60 days if it's issued after 15th of a month..
Any ideas how to construct that?
Any help is appreciated. Thanks.0 -
Sorry to rescue this old post.
I'm also looking for something similar, It would be great to do this withoud code modifications.
My requirement is:
- If the invoice date day is between the 1st and the 15th, Due date is next month's 10th day.
- If the invoice date day is between the 16th and the 31st, Due date is next month's 20th day.
Any ideas?0 -
Not without coding...0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions