web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) get Createdby name fro...

Microsoft Dynamics AX (Archived)

get Createdby name from table to Report

(0) Share

Report

Report

Posted on by Community Member

i have to show who created the Record in a table to show in my report.

Table: VendReceiptsListJour

i tried:

in processreport:

myTmp.CreatedName = this.getName(vendReceiptsListJour.createdBy);

getName Method:

public Name getName(NetworkAlias _alias)
{
UserInfo userInfo;

select * from userInfo where userInfo.networkAlias == _alias;

return UserInfo.name;
}

it didn't work, can you help me, thanks.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (3)

Suggested answer

Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

where userInfo.id== _vendReceiptsListJour.createdBy;

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi RenSonozaki,

Go to the table properties and change CreatedBy to yes.

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

also kindly remove * from your query.

you can specify filed name after select such as select FieldName from TableName;

this has nothing to do with your question but it will result in better processing.

Was this reply helpful? Yes No
Verified answer

Kanagaraj A 1,254 on at

Like (0)

Report
Copy link

Link copied!

try this,

This may help you before testing this ensure Createdby property should be YES in your table property.

UserInfo userInfo;

select networkAlias,name from UserInfo

where userInfo.id == purchtable::find("000043").createdBy;

info(strFmt("Name %1 Network alias-%2 Created by : %3", UserInfo.name,UserInfo.networkAlias,purchtable::find("000043").createdBy));

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#2

Alexey Lekanov 2

#2

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans