Calculate the opening balance

Finance and Operations/AX Developer Forum
1

Hi every one,

I have requirement to get opening balance in report.

i need to get the opening balance for one ledger. how do i achieve it…?

GL > Chart of Accounts > Select One Ledger > Click Balance Button > Setup > Enter From Date,To Date > so it will show the opening balance of all ledger in the grid…, i need to print the opening balance for one ledger.

Thanks in advance,

Saju.K

2

Having created the opening balance the day before transactions just run a TB for that date.

3

Hi adam,

i got it…

static void OpeningBal(Args _args)
{
LedgerBalanceSum_CurrentMST ledgerBalance ;
dimensionCriteria dimensionCriteria;
// Transdate balanceFromDate = “1/1/2010”;
// Transdate balanceToDate = today();
OperationsTax balanceOperationsTax;
Transdate balanceFiscalYear;
real balance;
;

ledgerBalance = new LedgerBalanceSum_CurrentMST(mkdate(7,11,2010),
today(),
dimensionCriteria,
NoYes::Yes,
balanceFiscalYear ? NoYes::Yes : NoYes::No,
NoYes::Yes, // Calculate closing post.
balanceOperationsTax,
DebCredProposal::None,
NoYes::Yes,
NoYes::Yes,
balanceFiscalYear ? NoYes::Yes : NoYes::No);

balance = ledgerBalance.balance(“1000000”);
print balance ;
pause;

}

4

The from Date should be the start of Fiscal/Financial year to get the Opening Balance.