web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / posting date
Microsoft Dynamics NAV (Archived)

posting date

(0) ShareShare
ReportReport
Posted on by onetwo 3,285

hello

 

when we enter an order, it generates the posting date of the date we enter an order. but lets say 2 weeks later i want to post the order , it posts with the date i entered the order. so when i go to ledger entries it shos posting date 2 weeks ago but i really posted today. why is that happening. it should be the day i post. 

 

 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    You are supposed to update the posting date when you post. 

    Or if you batch post you can set the date on the request form.

    You could on the Sales Header form add:
    OnAfterGetCurrRecord<>
    If "Posting Date" <> TODAY then "Posting Date" := Today;

    This will keep you posting dates current everytime you look at the order.
    Today can be replaced with WORKDATE if you wish.

    Another way would be to blank out the posting date on order creation - therefore forcing you to enter it before posting.
    but we've been using the code below for years - works fine.  Note you should also be setting Posting Date Ranges in user or G/L Setup too as extra protection.  Each month we change the allowable posting dates to the month we're in. This stops accidental posts into past months or even years.

    If "Posting Date" <> TODAY then "Posting Date" := Today

  • onetwo Profile Picture
    onetwo 3,285 on at

     dam i dont have developer license so i cant do it right?

    i was going to ask you so GL data range i need to update every month? because it gives me beginig and ending dates. from the administator section?

  • Community Member Profile Picture
    Community Member on at

    Hi George,

    Yes this requires a development license but it's a very minor mod.

    The date range is set in the User Setp form Administration -> Application setup -> Users -> User Setup. Also it's a good idea to set the general ledger setup as well.

  • Sanjeev Motiyani Profile Picture
    Sanjeev Motiyani 20 on at

    Work date and posting dates are different.Microsoft Dynamics goes on posting date and not work date.

  • Community Member Profile Picture
    Community Member on at

    [quote user="Sanjeev Motiyani"]

    Work date and posting dates are different.Microsoft Dynamics goes on posting date and not work date.

    [/quote]

    that is company policy specific. 
    in ours our posting date is always on the day we post (TODAY)  and our workdate is also the same.
    different companies might do it different for differnet reasons.  I find it rare when we actualy alter the WORKDATE from equaling TODAY

  • onetwo Profile Picture
    onetwo 3,285 on at

    fine i can have it modified. but like i said in the general ledger setup or user setup it asks for specirfic dates. how about if i put 6-1-09 to 6-30-09. the next month i need to go and change it to 7-1-09 to 7-31-09?

     

    and one thing i dont understand still. you enter 100 orders in 10 days . and you want to invoice. how in the world would the posting date stay the date you entered the order. it doesnt make sense. the posting date shows when it was invoiced and when it was shipped. so why would it stay the order date you entered. euufff

  • Alex Chow Profile Picture
    Alex Chow 4,481 on at

    You can default the posting date to blank if you're using version 5.0SP1 and NAV2009. This way, the user will need to specify the posting date during posting.

    For allow posting to, I usually recommend clients to set it 2- 3 months ahead.

  • Community Member Profile Picture
    Community Member on at

    [quote user="onetwo"]

    and one thing i dont understand still. you enter 100 orders in 10 days . and you want to invoice. how in the world would the posting date stay the date you entered the order. it doesnt make sense. the posting date shows when it was invoiced and when it was shipped. so why would it stay the order date you entered. euufff

    [/quote]

    If you are doing a number of shipment/invoices together then use the "Post Batch" option which allows you to replace the posting date for the batch

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans