how to get Closing balance in X++ Code

(2) Share

Report

Posted on by Ali AbdAlNasser

Hello everyone,
I have a scenario that requires me to display the closing balance for the employee.
I want to obtain the closing balance for each employee through the main account

Best regards.

Categories:

Dynamics 365 Finance

All responses (4)

Answers (1)

André Arnaud de Cal... on at

Like (0)

Report

how to get Closing balance in X++ Code

Hi Ali,

Can you please elaborate on your question? What is exactly your definition of "the closing balance for the employee"?
Ali AbdAlNasser on at

Like (0)

Report

how to get Closing balance in X++ Code

Hi @André Arnaud de Calavon.
I want to retrieve the Closing balance value from the Trial balance screen.
However, this screen has a temporary table that stores data when the calculate button is clicked.
André Arnaud de Cal... on at

Like (0)

Report

how to get Closing balance in X++ Code

Hi Ali,

Note that the screen and a trial balance report are both using a single data provider. You can run the same data provider as being used on the Trial balance screen to get the details in a temporary table. Then you can query the temporary table for closing balances.
Verified answer

Ali AbdAlNasser on at

Like (1)

Report
how to get Closing balance in X++ Code

Hi André Arnaud.

I solved my problem by using the same code found in the Calculate button on the Trial Balance screen.

ledgerTrialBalanceTmp::calculateBalances_V2(ledgerTrialBalanceTmp, dimensionHierarchyName,systemDateGet(),systemDateGet(), false,false,false,postingLayer);

Join the conversation

Community site session details

how to get Closing balance in X++ Code

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates