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

Report G/L Account Sheet with Balance Account Info

(2) Share

Report

Posted on by DM-22010721-0

Dear Community, I need to modify the report G/L Account Sheet with Balance Account Info (SRGLAAccSheetBalAccount.rdlc) in order to have in column Bal. Acc. and Bal. Acc. Description the Vendor number and Vendor name. Same thing for table G/L Entry (17) add two columns showing the same. I attached below an example. Anyone can help me telling wich fields, table and logic I have to use in order to achive my scope? I'am not an expert I just start to understand development.

Thank you
Davide

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Pallavi Phade 3,041 on at

Like (0)

Report

Report G/L Account Sheet with Balance Account Info

Namaste @DM-22010721-0

Seems above Report is custom Report , we could not see in Exsiting Reports . You can customize the layout or replace the layout in Report layouts section

And for GL Entry you can see columns

You can add in layout . If you still need help please let me know

Warm Regards

Pallavi Phade

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 14,364 Super User 2025 Season 2 on at

Like (1)

Report

Report G/L Account Sheet with Balance Account Info

Hello,

To show Vendor No. and Vendor Name in the G/L Account Sheet with Balance Account Info report and G/L Entry view, you need to use Bal. Account Type and Bal. Account No. from G/L Entry (Table 17), and when the type is Vendor, fetch details from Vendor (Table 23) using Bal. Account No. as the key; then extend the report dataset with two new fields (VendorNo, VendorName) and update the RDLC layout, and for G/L Entry either create a table extension with calculated fields or a query/page extension to display these columns.

2 people found this reply helpful.

Was this reply helpful? Yes No