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

Report G/L Account Sheet with Balance Account Info

(7) 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 (7)

Answers (0)

Suggested answer

Pallavi Phade 3,721 on at

Like (3)

Report

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 15,627 Super User 2025 Season 2 on at

Like (1)

Report

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
DM-22010721-0 44 on at

Like (4)

Report

Dear Jainam, thank you appreciated, how can you relate "Bal. Account No." (table17) with table (23)?
Or better when I click on table 17 "Find Entries" and then I choose "Vendor Ledger Entries" I have the fields I want: Vendor no, Vendor name and Description. Which key can I use to bring these fields on table 17?
I hope I have been clear
Thank you

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 5,066 on at

Like (3)

Report

Hello,

To show Vendor No. and Vendor Name on the G/L Account Sheet with Balance Account Info report, you don’t need to change table 17.

Just use the G/L Entry.Source Type and Source No. fields:

If Source Type = Vendor

Then Source No. = Vendor No.

Look up the Vendor record to get Vendor Name.

Add these two values in a reportextension as calculated columns, then use them in the RDLC.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,307 Super User 2025 Season 2 on at

Like (1)

Report

Hi, If Bal. Acc has no value in your data, it won't be displayed when printed.
If you want to display the Vendor no., you can try the following method.

Dynamics 365 Business Central: Display Customer Name and Vendor Name (Source Name) in General Ledger Entries

https://yzhums.com/13226/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,262 Super User 2025 Season 2 on at

Like (2)

Report

Agreed with OussamaSabbouh, you can use the Source Type and Source No. fields in the G/L Entry table. No need to add custom fields if the system already has functionality for what you're looking for.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,627 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

There’s no direct key between Table 17 (G/L Entry) and Table 23 (Vendor Ledger Entry), but they can be related through the Transaction No., which is common across all entries in the same posting.

Alternatively, you can use Document No. + Posting Date as a composite link. To bring fields like Vendor No., Vendor Name, and Description into Table 17, you can create FlowFields in AL that look up values from Table 23 using Transaction No. as the filter.

This is the most reliable way to connect these tables for reporting or display purposes.

1 people found this reply helpful.

Was this reply helpful? Yes No