Small and medium business | Business Central, N...

Report Extension

(0) Share

Report

Posted on by Community Member

Hello Experts,

I am trying to do sales invoice report extension to bring "GST Regiatration No." value in to the Report layout.

I could to map the corresponding "GST Registration No" field in the XML Mapping for the custom report word layout. But the data is not populating for the "GST Registration No" when running the report.

I am using IN Localization.

Relevant screen shot's are attached for reference.

Thank you for sharing your inputs to solve this issue.

Regards,

Ranjith

I have the same question (0)

All responses (5)

Answers (0)

Sort by

matthias_rabus 160 on at

Like (0)

Report
Copy link

Link copied!

Hi Ranjith,

please check if the Get was successful. Use the debugger and see if the variable is filled or run the request page and use "Send to" => Microsoft Excel (data), then check how the data is present

Was this reply helpful? Yes No
Suggested answer

JAngle 159 on at

Like (0)

Report
Copy link

Link copied!

GET requires the primary key values of the table to be passed. Is there a value from the header dataitem you can use? I would you onaftergetrecord as the trigger in that case

Was this reply helpful? Yes No
matthias_rabus 160 on at

Like (0)

Report
Copy link

Link copied!

Get would use default values for missing parameters, so in this case it will use empty string

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Matthias Rabus,

Thank you for your input .

Appreciate if you can elaborate it.

Regards,

Ranjith

Was this reply helpful? Yes No
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

In line 18 where you write GSTRegistrationNo.Get(); you need to change that so you tell BC what primary key you want to run get on

GSTRegistrationNo.Get(ValueOfPK);

If there is several fields in the PK of the table you need to seperate the values with a comma.

Was this reply helpful? Yes No