Due Date Field on Sales Header

(0) Share

Report

Posted on by AndreaNardiello

150

Hi everybody,

I have a question related to the field mentioned in the subject: I cannot understand how is this field being automatically written by the system.

MS documentation says that:

By default, the field is calculated as the date in the Shipment Date field plus the period defined in the Payment Terms Code field.

The fact is that this does not seem to be true because I tried "playing" with these fields but Due Date still remains blank.

I need this date because it is necessary to look for the valid Direct Debit ID linked to the customer I am invoicing. Without the Due date, Direct Debit ID would be blank.

Hope someone can help me understand.

Tried it with NAV 2017.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (2)

Suggested answer

Mohamad Barada 180 on at

Like (0)

Report
Copy link

Link copied!

Due date is calculated from posting date adding to it the payment terms date formula. check by changing posting date and see the change done.

Please check this question as answered if it do.

Was this reply helpful? Yes No
AndreaNardiello 150 on at

Like (0)

Report
Copy link

Link copied!

Hi Mohamad.

I forgot to say that I made tests on MS Dynamics NAV 2017 with Italian localization.

It seems that the field Due Date is kind of unused because in the Italian version we have a table (12170) named Payment Lines with which NAV creates more than one Entry in the Customer Ledger because in Italy we have Deferred Payments (for example one invoice is splitted into three entries, each one with a specific Due date, which means three Due Dates).

This way, Due Date field is useless to the system, I think.

Anyway, I would like to see with my eyes the C/AL code where the system make this field populated, just for my own knowledge.

Thank you.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report
Copy link

Link copied!

Do you want to check it in the Italian version or in the W1 version? In W1, it is calculated from the posting date plus the payment terms formula.

Was this reply helpful? Yes No
AndreaNardiello 150 on at

Like (0)

Report
Copy link

Link copied!

Would like to see W1 C/AL code making the calculation.

Was this reply helpful? Yes No
Suggested answer

RobertasR 5,004 on at

Like (0)

Report
Copy link

Link copied!

Hi Andrea,

in W1 the Due Date is calculated from the "Document Date" (NOT Posting Date), adding Due Date Calculation formula from the Payment Terms. Simply put it's

"Due Date" := CALCDATE(PaymentTerms."Due Date Calculation","Document Date");

Robertas

Was this reply helpful? Yes No
Verified answer

Tina Menezes 2,582 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can find calculation of Due Date present in Sales Header as shown in the below screenshot.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,967 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Alexander Ermakov - Are you sure in Italian version Due date is calculated based on Posting Date??

As per my understanding Posting date as no influence on Due date rather it gets always calculated from Document Date. Pardon my curiosity.

Was this reply helpful? Yes No
Verified answer

4BzSoftware 6,073 on at

Like (0)

Report
Copy link

Link copied!

Hi Andrea Nardiello,

I think the NAV context help document is not correct. It should be:

By default, the field is calculated as the date in the Document Date field plus the period defined in the Payment Terms Code field.

Procedure:

1. When you create new document, system assigns "Document Date" := WORKDATE;

2. When system validates Bill-to Customer No., it fills in "Payment Terms Code" from Customer master data, then validates the "Payment Terms Code" field.

3. Payment Terms Code - OnValidate invoked, there is no Shipment Date involved.

Was this reply helpful? Yes No
AndreaNardiello 150 on at

Like (0)

Report
Copy link

Link copied!

As I wrote, Due date is not calculated onto table 36. We have the Italian 12070 in which we can have multiple due date depending on the Payment Terms.

Was this reply helpful? Yes No