Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Posting Dates vs Docum...
Microsoft Dynamics NAV (Archived)

Posting Dates vs Document Dates = Due Dates

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Is it possible to make vendor payment due dates and customer payment due dates based on "Posting Dates" instead of "Document Dates". In our company with our vendor and customers we pay based on Posting Date not on Document date.  

Example: vendors submit invoices to us on 5 September 2016 for expenses that were incurred by our employees on month  July or August 2016. Same with our customers, we perform the work on Jan 2017 but can only invoice in Feb 2017. Customer payment due date is based on Feb 2017 + terms, not Jan 2017 + terms. 

Right now we set the document and posting date as the same dates. Which completely nullifies the purpose of having to date fields. Any help greatly appreciated.

*This post is locked for comments

  • Sumit Kalia Profile Picture
    Sumit Kalia on at
    RE: Posting Dates vs Document Dates = Due Dates

    Go to Accounts payable-->Setup--> Parameter-->Invoice Tab and disable the option "Update vendor accounting using the invoice date". Then it will post the voucher based on posting date.

  • Suggested answer
    Indikauk Profile Picture
    Indikauk 1,759 on at
    RE: Posting Dates vs Document Dates = Due Dates

    Hi  Survivor

    by default system calculate payment due date based on the Document Date but if you need to change it to posting Date i'm agree with Amol Salvi suggestion.

    Thanks

    Indika

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Posting Dates vs Document Dates = Due Dates

    by this advice

    it works. but after converting Sales Quote  >> Sales Order, "Due Date" on Sales Order does not exist. I have to change "Posting Date" on Sales Order so "Due Date" will be updated.

    How can I fix this?

    Thank you in advance

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Posting Dates vs Document Dates = Due Dates

    Hi

    In which screen you would like to import pictures ? It is possible to import pictures.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Posting Dates vs Document Dates = Due Dates

    Thanks to everyone for providing valued feedback to my question. The objective is to use the document date for the date work is completed (or date on document) and posting date for date the transaction hits the GL. On sales side the date between actual completion of work and invoicing can be months. When reporting need to be able to flip between document date and posting date financial reporting. Is it possible to import pictures here?

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: Posting Dates vs Document Dates = Due Dates

    Survivor ,

    Agreed with said by "Alexander Ermakov"

    If you worry about the Print (Print order) : just change the report also

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Posting Dates vs Document Dates = Due Dates

    By default, the due date is calculated from the Document date. If you want it to be calculated from the Posting date, you need to modify OnValidate trigger in the Payment Terms Code field in the Purchase/Sales Header Table.

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Posting Dates vs Document Dates = Due Dates

    By looking at your scenario you do not want to change document date but based on posting date you would like to calculate due date for payment.

    As default system calculates due date based on document date and if you would like to calculate due date based on posting date then you need to change the program for this

    Check the code on Payment terms code OnValidate trigger in Sales header table

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Posting Dates vs Document Dates = Due Dates

    Hi,

    In this case, what is the value date of your transaction, "Posting Date" or "Document Date"?

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: Posting Dates vs Document Dates = Due Dates

    Is this mainly effect you while generating Invoice / Printout

    or are you worrying about system details (data) also ? 

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