For business management solutions email us or call 020 3004 4600

Payment Terms Formulas and their meanings

The setup of Payment Terms in NAV can be confusing.

In NAV we have various terminology that equates to a time period. For example:

D = Day. A number before this will equal the number of days. 20D = 20 days. If the number appears after the D with no sign in front of it, this means the next occurrence of that particular date. See below for an example.
W = Week.
M = Month.
CM = Current Month.

Additional to this, mathematical signs can be used in the equation, for example CM+20D which is basically saying, end of the current month, + 20days. So on, or around the 20^th of the next month.

Some possible entries for Payment Terms and their meaning are listed below.

Entry	Result – Based on Date of 28 Jan 2016	Comment
20D	17/02/2016	+ 20 Days
D20	20/02/16	The next occurrence of the 20^thof the month
CM	31/01/16	End of the current month.
CM+20D	20/02/16	End of the current month plus 20 days.
1W	4/02/16	1 week (usually from date of invoice.)