web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / OlisterR's NAV/BC blog / Exposing Dimension and Dime...

Exposing Dimension and Dimension Values in General Ledger Entries

Views (705)
Olister Rumao Profile Picture Olister Rumao 3,967

 

Introduction:

Ever felt a need to expose Dimensions on G/L Entries? Wouldn't it be simple to check-in G/L Entries or perform a Pivot in Excel directly?
Well, that is exactly what I'm planning for.

Use Case: Add the 2 Global Dimension  & 6 Shortcut Dimension to G/L Entries Table in Business Central. These fields should be downloadable in Edit in Excel.

Pre-requisites:

  • Microsoft Dynamics 365 Business Central
  • VS Code
  • AL Language Extension

Procedure:

1. Adding fields to the Page:
I will be creating 8 variables on the G/L Entry Page of the Type Code[30] and add the variables as fields to the page.
Fields to G/L Entry Page
Fields to G/L Entry Page

2. Adding Logic to fetch data into the fields:
The fields that were recently created needs to be filled in with values for each and every record.
Dimension Set Entries table consist of Dimension Set ID (Integer) and Dimension Code which will be getting from General Ledger Setup. 

Logic to fetch the Dimension value
Fetch the Dimension Value


Output:

Dimension in G/L Entries 


Exporting to Excel:

Edit in Excel with Dimensions


Conclusion:

I hope this helps you in generating some sort of reporting & analysis directly through G/L.
Possible use of this could be using this page through WebService to generate Data for PowerBI.

Comments

*This post is locked for comments