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 / Small and medium business | Business Central, N... / [JET Report] Where can...
Small and medium business | Business Central, N...
Suggested Answer

[JET Report] Where can I pull out the salesman information other that Salesmancode?

(0) ShareShare
ReportReport
Posted on by joshtechsolutions 4,979

Hi Community,

May I know if I want to create a Jet report that shows who created the sales order.

Where can I pull out the information other that Salesmancode?

Salesman code is not a must to input and sometimes salesman may forget.

I also tried to pull from Change logs, but it doesn't seems able to work.

Thank you!

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,679 Super User 2025 Season 2 on at

    Hi, Data audit system fields are added to every table in Dynamics 365 Business Central 2020 Release Wave 2 (BC17).

    More details: https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave2/smb/dynamics365-business-central/data-audit-system-fields-are-added-every-table

    Four new system fields are added to all tables:

    • SystemLastModifiedOn
    • SystemLastModifiedBy
    • SystemCreatedBy
    • SystemCreatedOn

    So unfortunately, in NAV and early BC, this feature is not available and needs to be customized if needed.

    Hope this helps.

    Thanks.

    ZHU

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,577

#2
YUN ZHU Profile Picture

YUN ZHU 888 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 778 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans