User needs to add custom table fields in Report Writer

(0) Share

Report

Posted on by Community Member

The user has a custom table which contains additional information about standard inventory items. They need to include this information on their invoices and packing slips. Is there a way to include non GP tables in Report writer?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (3)

Verified answer

coquisalsa 2,725 on at

Like (0)

Report

You can achieve this by using Report Writer: Microsoft Dynamics GP > Tools > Customize > Report Writer.

There is no need for VBA, SQL queries neither Dexterity. Just create a calculated field using the function rw_TableLineString.

In the 'Calculated Field Definition' window of the report writer chick on ‘User-Defined’, select Core ‘System’, select Function = rw_TableLineString and the build your expression.

Was this reply helpful? Yes No
Verified answer

Andrew Hall 190 on at

Like (0)

Report

Yes it is possible

You create calculated fields in report writer and then attach VBA to the report that runs a sql query to go and grab the data from the custom table and then uses that to populate the calculated fields in report writer. if you do this though it wont surface in the web client as you cant use vba with that deployment method.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

you can write a custom Report Writer function in dexterity and use a calculated field in report writer by calling the custom function to pull the data on the report. The problem is that a custom Report Writer function that you create in your dictionary is only visible from reports in your dictionary.
Refer the link:
blogs.msdn.com/.../getting-data-from-isv-tables-onto-reports-without-needing-to-create-alternate-reports.aspx

Was this reply helpful? Yes No
Deb Landon 45 on at

Like (0)

Report

Hi Jorge, this function is new to me. Are you saying that I do not need to use VBA at all (you said that VBA is not supported in GP2015). I have created a calculated field using the rw_TableLineString function and I have used a constant of String to type my query "SELECT CHEKBKID FROM CM00100 WHERE CURNCYID = " and then added the Currency ID from the RM_Open_Temp table. Is this how this function works? Thanks for your help.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi,

VBA does work in GP2015, it just doesn't work for the Web Client, never did.

Kind regards,

Leslie

Was this reply helpful? Yes No
Tanner 360 on at

Like (0)

Report

Deb,

Were you able to get an answer on this? I am unclear how this would work as well and would like to avoid using VBA or dexterity customization. I just need to pull the Project Name from the PA module onto the customer statement from the RM module. They want to see the project name next to the open invoices so the customer can avoid cross-referencing on their side.

Thanks.

Was this reply helpful? Yes No
Deb@PA on at

Like (0)

Report

Hi Tanner

Unfortunately this was so long ago I cannot remember if it ended up using this or VBA. Sorry.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

Tanner,

Refer to the link provided by Shan above:

blogs.msdn.com/.../getting-data-from-isv-tables-onto-reports-without-needing-to-create-alternate-reports.aspx

That blog article and the docs it links to should set you to use VBA to pluck the value you need out of the table.

Was this reply helpful? Yes No