web

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

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to see function de...

Finance | Project Operations, Human Resources, ...

Suggested Answer

How to see function definition of Report Writer user defined function

(0) Share

Report

Report

Posted on by CU27040904-9

Greetings,

I want to see the Sql(or however result is getting produced) behind a user defined Report writer function. I have a function declared in a report for a calculated field as given below -

RW_T_HOG_Claimed_By_Roll'( 'T_Tax_Roll_Certificate_HDR_TEMP'.'D_Roll #''T_Tax_Roll_SETUP'.'D_Taxation Year' )

Due to some reason its not giving the expected output and I want to see how the result is getting calculated so i can troubleshoot it , but I am not sure how to see RW_T_HOG_Claimed_By_Roll function's definition.

Any help will be great. Please let me know if you need further info.

Thanks in advance

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

David Musgrave MVP ... 14,151 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I am not sure what product dictionary the RW_T_HOG_Claimed_By_Roll() report writer function is from. It is not in the core Dynamics GP modules I have loaded.

Anyhow, you can get the parameter list from the SDK (if it is included) or using GP Power Tools (on a system where it is installed).

You probably can work out the parameters from the example call you have already.

As for what it is doing, you would only be able to get an idea of the tables it accesses by using logging. With GP Power Tools we could enable logging for ONLY the period when that function is being executed. if the script makes a direct SQL call, we would be able to see that, otherwise we can see which tables it accesses, but not what it does with the data retrieved.

The only way to see exactly what the code is doing is if you had access to the source code. Once we identify which product it is from, we can see if viewing the source is possible. Some Microsoft published dictionaries are included in a source code program and so it is possible to check the source code. If the function is in a custom dictionary or ISV product, you would need to discuss with the developer responsible.

Good luck

David

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

It's not necessary that sql code run behind this function, may be the code is written in dexterity.

You can check it by running sql profiler while printing the report so it will show sql code if there is any.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 797

#2

André Arnaud de Cal... 610 Super User 2026 Season 1

#3

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans