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

How to Change Last Modified date?

(0) ShareShare
ReportReport
Posted on by 45

Hi, I asked how to add items to the sales order list a few days ago.

Thank you for your answers.

pastedimage1635386824379v2.png

I have found a problem that sales order list cannot be filtered.

I have observed that it is because of the last modification date. Sales orders that have been modified after I added "item no."to sales order list can be filtered.

So I want to know how to modify the last modified date, or what I can do to make every The last modified date field of a sales order has a value. Thank you!!

pastedimage1635387224696v3.png

I have the same question (0)
  • HUNGXUAN Profile Picture
    45 on at
    RE: How to Change Last Modified date?

    Thanks for your reply!

    But I don’t know how to add this.

    The "修改時間" was added by the consultant of Business Central supplier for help.

  • HUNGXUAN Profile Picture
    45 on at
    RE: How to Change Last Modified date?

    OMG! This is very helpful to me, thank you!!

    In fact, I would like to use filtering in the sales order because there are many unused orders in the sales order, and I hope to hide the unwanted orders in the sales order through filtering.

    The sales line is a good tool for me, but it is very unfamiliar to other salesperson in the company. I don’t want to change the way they are used to using sales orders.

    Thank you very much!

  • Suggested answer
    YUN ZHU Profile Picture
    89,974 Super User 2025 Season 2 on at
    RE: How to Change Last Modified date?

    Hi, You can add code in the OnModify trigger of Sales Header to update this date.

    But is this 修改履历 added by you?

    Why not use system standard fields?

    pastedimage1635473327640v1.png

    Hope this will help.

    Thanks.

    ZHU

  • Suggested answer
    JAngle Profile Picture
    113 on at
    RE: How to Change Last Modified date?

    Take a second look:

    pastedimage1635415661974v1.png

    The "Show Document" button opens the Sales Order directly from the Sales Line list page. If you need other reference information from the header maybe add that as page fields (no filtering capability)

  • HUNGXUAN Profile Picture
    45 on at
    RE: How to Change Last Modified date?

    Thank you for your reply!

    I know that the way you mentioned can directly filter items, but this way cannot open sales order, so it is not suitable.  :(

  • Suggested answer
    JAngle Profile Picture
    113 on at
    RE: How to Change Last Modified date?

    I still think this is a bad design. I would make the sales line page available instead so the filtering is standard. I would also add a fact box view on the sales order list page.

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,737 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,577

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,251

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans