Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Due Date Field on Sale...
Microsoft Dynamics NAV (Archived)

Due Date Field on Sales Header

(0) ShareShare
ReportReport
Posted on by AndreaNardiello 115

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

  • AndreaNardiello Profile Picture
    AndreaNardiello 115 on at
    RE: Due Date Field on Sales Header

    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.

  • Verified answer
    4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: Due Date Field on Sales Header

    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.

    2500.2.png

    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.

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: Due Date Field on Sales Header

    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. 

  • Verified answer
    Tina Menezes Profile Picture
    Tina Menezes 2,576 on at
    RE: Due Date Field on Sales Header

    Hi,

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

    Due-Date-calculation.JPG

  • Suggested answer
    RobertasR Profile Picture
    RobertasR 5,002 on at
    RE: Due Date Field on Sales Header

    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

  • AndreaNardiello Profile Picture
    AndreaNardiello 115 on at
    RE: Due Date Field on Sales Header

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

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Due Date Field on Sales Header

    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.

  • AndreaNardiello Profile Picture
    AndreaNardiello 115 on at
    RE: Due Date Field on Sales Header

    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.

  • Suggested answer
    Mohamad Barada Profile Picture
    Mohamad Barada 180 on at
    RE: Due Date Field on Sales Header

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans