web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... [AL] New Column : Sum ...

Small and medium business | Business Central, N...

Suggested Answer

[AL] New Column : Sum Posting_Date + Payment Terms Code

(0) Share

Report

Report

Posted on by JMartin

160

Hi mates! :)

I have a question, I just want to sum "Payment Terms Code" to "Posting_Date" on "Purch. Rcpt. Lines".

Payment and Posting are two fields on a new customized page.

Posting -> Lookup on "Purch. rcpt. lines" table [Text type]

Payment -> Lookup on "Vendor" table [Date type]

I mean, for example:

Posting_Date --> 01/01/21

Payment Terms Code --> 30D

NewDate (Posting_Date + Payment Terms Code) --> 01/02/21

Maybe I can do it with calcDate form, but I'm not sure how to work with it.

Thank you so much! :D

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

IB-29041624-0 1,187 Moderator on at

Like (0)

Report
Copy link

Link copied!

What you will have to do is to use the calcdate functioon

newDate := Calcdate(paymenterm.calcformula,Postingdate);

So you must use the payment term code, to get the payment term record and use the dateformula from that record.

docs.microsoft.com/.../calcdate-function--date-

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,961 Super User 2026 Season 1

#2

YUN ZHU 1,211 Super User 2026 Season 1

#3

AndrewThomas81 1,141

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans