News and Announcements icon

Dynamics 365 CommunityForums 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) Share

Report

Report

Posted on by joshtechsolutions

4,841

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!

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 82,745 Super User 2025 Season 1 on at

Like (0)

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

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

Helpful resources

Quick Links

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

#1

YUN ZHU 446 Super User 2025 Season 1

#2

Sagar Dangar, MCP 347

#3

Mansi Soni 327

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans