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

Missing Column Data in G/L Register

(0) Share

Report

Posted on by E.Spross

Hi,

I am attempting to create a custom G/L Register excel layout, but I am struggling with two columns that are not populating in our company's BC account. When I export the data for the G/L Register report in Excel using the "Data Only" option, I see two columns that are blank: GLAcc_Name and SourceName. When I export this same report from the sample Cronus company, these columns have data. What do I need to do to have the data appear in these columns in the G/L Register report for my company? It would be incredibly helpful to be able to see the account names and Source Names (Vendor names) in our G/L Register reports.

Thanks!

Erin

All responses (3)

Answers (0)

E.Spross 5 on at

Like (1)

Report

RE: Missing Column Data in G/L Register

Hi All!

I was able to find the solution to my problem: When downloading the G/L Register, you have to make sure "Include Acct Descriptions" is selected first. This will then populate the two columns GLAcc_Name and Source Name in the far right.
E.Spross 5 on at

Like (0)

Report

RE: Missing Column Data in G/L Register

Hello Zhu!

Thank you for your response. We do have Names in all of the G/L Accounts. As you said above, I don't think it's possible to not have names!
Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

RE: Missing Column Data in G/L Register

Hi, Indeed there are values in the standard database.

I checked the standard code of GLAcc_Name, it just displays the Name in the G/L Account, is the Name in your G/L Account also empty? (Although I don't think it's possible....)

Hopefully other experts can give you better advice.

Thanks

ZHU