Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Range of document date in orders(Similar to allow posting date in user setup)

(0) ShareShare
ReportReport
Posted on by 60

Hi all,

How can I add range of document date in user setup(Similar to posting dates). 

  • sha212 Profile Picture
    60 on at
    RE: Range of document date in orders(Similar to allow posting date in user setup)

    Thank you Dirk.

  • Suggested answer
    Dirk Profile Picture
    on at
    RE: Range of document date in orders(Similar to allow posting date in user setup)

    Like Binseh and Josh mentioned ... this is not possible in NAV / BC standard without a modification.
    They suggested some additions you can do.

    If you would like to see this kind of feature in the standard application ... on the long run ...

    Partners can log ideas on //aka.ms/bcideas  and will get feedback on this platform.
    Other partners can vote for your ideas and all ideas will get acknowledged within a few weeks or less.

     But please be aware that ideas are usually only taken into account for new major releases / future versions, not for NAV and early versions of Business Central

  • Suggested answer
    JAngle Profile Picture
    89 on at
    RE: Range of document date in orders(Similar to allow posting date in user setup)

    Similar in what way? User can only add to the "Document Date" field within a certain range?

    Would require new fields in the user setup table and then some revalidation on the sales/purchase header tables. With NAV2016 you have the v1 of events so there will probably be one you can latch onto and have a codeunit compute the new logic if you pass all the necessary parameters.

  • Verified answer
    Binesh Profile Picture
    7,885 on at
    RE: Range of document date in orders(Similar to allow posting date in user setup)

    Hello,

    If your requirement is similar to posting dates then

    Based on your needs,

     create 2 fields "From Document Date" & "To Document Date" in the sales Setup (Application Level) or in the User Setup (User Level)

    Write the validation on Document date field, and raise the error if the date is beyond "From Document Date" & "To Document Date".

    for reference

    IF (DocumentDate < AllowDocumentFrom) OR (DocumentDate > AllowDocumentTo) then Error('Document Date not in the range!');

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
YUN ZHU Profile Picture

YUN ZHU 592 Super User 2025 Season 1

#2
Mansi Soni Profile Picture

Mansi Soni 453

#3
Sagar Dangar, MCP Profile Picture

Sagar Dangar, MCP 391

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans