Dynamic GP Report writer

(0) Share

Report

Posted on by Community Member

Dear All,

Can i modify by adding new field to the below mentioned inbuilt report writer field(field2)?

8055.image_2D00_2.jpg

Actually i wanted to take the value of document number field from payable transaction entry table (see red color box on below image) and...

I need to display that document number in below mentioed red colored box in voucher (report writer- first image )wich is getting from edit paybles check.

is there any way to add this field (document number ) in that field2(first image)i RW ?? this field to is dispalying maultiple lines..or any other way?

Some body please help?

*This post is locked for comments

I have the same question (0)

All responses (19)

Answers (0)

Sort by

Suggested answer

soma 24,410 on at

Like (1)

Report
Copy link

Link copied!

In your RW function use the two input parameter(Document Type and Invoice/Voucher Number).

Create a RW function with two input parameter(Document Type and Invoice/Voucher Number) and get the document number from Payables table and return the same values through this function.

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Dear soma,

Thanks for your sudden response,

But, if you dont mind,Kindly give some more clarifications.

Do we need to create new RW function?

if so, please send me the details.

Thanks in advance

Belraj

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (1)

Report
Copy link

Link copied!

In Dexterity create a function name starting with "RW_" and the use this function in your Report writer calculated field.

The RW function use two input parameter and one output parameter.

in integer docType;

in string voucherNumber;

out string docNumber;

get the document number value from the AP tables and set the same value to docNumber this field.

Then create a chunk file and deploy it into GP. Now open the report in report writer and add a calculated field with your custom RW function and pass the input parameter values.

Now use the calculated field to report layout.

Hope this helps!!!

Was this reply helpful? Yes No
Justin Thorp 2,265 on at

Like (1)

Report
Copy link

Link copied!

Hi Belraj,

It looks like there is a KB article that details what you want: support.microsoft.com/.../912953

Thanks,

Justin

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you so much dear soma,

It will be appreciated if you sent the code too..

Thanks in advance

Belraj

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Dear Justin,

Thanks for your response.

That article is good ...but i need to show those all fields!!

Field9,Field2,Field3,Field4,Field5

and ....along with Field2

•Document Number too...

Thanks and Regards,

Belraj

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report
Copy link

Link copied!

I will create and test this on my environment and will send you.

:)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Dear soma.

Thank you very much.Awaiting for your response. :)

Thanks and regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Dear Mr.Soma,

Any Luck? Please update me..

Thanks in advance

Belraj

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

Like (1)

Report
Copy link

Link copied!

Hi,

I know Soma recognizes the report, but on my screen I cannot read the title. Which report is this?

Leslie

Was this reply helpful? Yes No