Microsoft Dynamics 365 | Integration, Dataverse...

VBA customization on RMStatementOnBlankPaper

(0) Share

Report

Posted on by williamhuang

We have VBA customization on RMStatementOnBlankPaper report, as we are planning to replace VBA, what are tools we could use to replace VBA?

thanks

All responses (6)

Answers (0)

williamhuang 5 on at

Like (0)

Report

RE: VBA customization on RMStatementOnBlankPaper

Thanks for your help,

I have modified the report in report writer, and deployed it. and had some VBA code on it to get some detail data from invoice table.

I am trying to replace the VBA code, wondering what are tool to use, what is your development environment setup? I tried Dynamic SDK, but couldn't find where to access the report and add code to it

Thanks, have a nice day
Almas Mahfooz 11,003 User Group Leader on at

Like (0)

Report

RE: VBA customization on RMStatementOnBlankPaper

As you mentioned you have modified the report in Dynamics.dic, I hope you have created it's chunk file to deploy on GP. In Dexterity development environment you need to add code for report by creating functions. What exactly your code is doing?? maybe you don't need to add code or just by creating some table relationship you can fetch data for your report.
williamhuang 5 on at

Like (0)

Report

RE: VBA customization on RMStatementOnBlankPaper

Thanks for your help, Almas

I have the report modified in the report writer, and deployed the dynamics.dic. I have some vba code to get some data for the report. I would like to replace the vba code, would you mind to let me know what would be options? as you said, how can I write my logic in sanscript?

Thanks in advance
Suggested answer

Almas Mahfooz 11,003 User Group Leader on at

Like (0)

Report

RE: VBA customization on RMStatementOnBlankPaper

William,

It would be a little difficult for anyone without previous dexterity experience.

You must know how to copy Dynamics.dic and open it in Dexterity and find the report in dictionary.

if there are cosmetic changes then do it.

As you mentioned you have vba code, then you have to write same logic in sanscript.

then create chunk to deploy report changes( similar as package)

Add in GP and mark alternate report to access the modified report.
williamhuang 5 on at

Like (0)

Report

RE: VBA customization on RMStatementOnBlankPaper

Thanks, Almas

could you advise how to use dexterity code?

thanks
Suggested answer

Almas Mahfooz 11,003 User Group Leader on at

Like (0)

Report

RE: VBA customization on RMStatementOnBlankPaper

Best option is to have report writer+ dexterity code to replace VBA.