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

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Inge M. Bruvik 1,029 Moderator on at

Like (0)

Report

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

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-

Helpful resources

Quick Links

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

#1

Sohail Ahmed 2,655

#2

Mansi Soni 1,574

#3

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans