web
You’re offline. This is a read only version of the page.
close
Skip to main content
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). 

I have the same question (0)
  • 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
    119 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

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,132

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,615

#3
Sumit Singh Profile Picture

Sumit Singh 2,912

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans