which regular table "endingbalance" calculated for per month in the Trial Balance form

Finance and Operations/AX Developer Forum
1

Hi All,

I want to know which regular table ending balance is calculated “Permonth” from the trial balance form.

Please see the below screenshots for your reference.

TrialBalanceForm.png
TrialBalanceForm.png1340×635 96.7 KB

ParameterForm.png
ParameterForm.png1191×640 71.4 KB

generaljournalaccountentry table is store “AccountingCurrencyAmount” sum of the this “AccountingCurrencyAmount” is display in the ending balance of “LedgerTrialBalanceListPageTmp” table.I want to know from which regular table ending balance coming for this temp table “LedgerTrialBalanceListPageTmp”.

2

I think it is from \Data Dictionary\Tables\DimensionFocusBalance

Try debugging for mode details, \Data Dictionary\Tables\LedgerTrialBalanceListPageTmp\Methods\constructBalances

3

Hi kranthi

I am not able to debug this method.debugger is not hitting this method.

when this method will be hit.

4

Have you tried by opening the list page after adding the breakpoint?

The method runs on the server. Have you enabled the server side debugging?

5

Yes…I have enabled the debugger on the server.

Now debugger is hitting.

For this table “DimensionFocusBalance” record is not selected

6

what do you mean by that?

I think the code uses a set based operation to insert the records into temp table from DimensoinFocusBalance

7

Hi Kranthi,

while debugging not seen any buffer for the “DimenionFocusBalance” table.

Can you tell me the relation to retrieve cost for the “DimensionFocusBalance” table

8

Have you looked at \Classes\LedgerTrialBalanceDP\populateTmpTransSummary?

9

Hi Kranthi,

I have debugged above method not getting any before record for this table “LedgerTrialBalanceStagingTmp”.

10

What does that mean? The method uses insert_recorset to insert records into LedgerTrialBalanceStagingTmp table,so you wont see any value on that buffer while debugging.