Duplicating Financial Dimension on Dialog box in GG > Reports > Transactions > Detailed Trial Balance

This question is answered
Hello Experts,
It's a default report.
I have one report "Detailed Trail Balance" for the first time when I click select for the General Journal Account Entry [and select Financial Dimension Branch = 01] and click ok than again click select for another time. The dialog box shows me two lines of Range although I have define only one range and the second line is duplicated. If I click ok and again click Select it shows me duplicate of last two line of range.
I am using MS Dynamics AX 2012 R2. 
Any help in this situation.
  • Any suggestion
  • Dear Experts,
    Is there any patch or hot fix from the Microsoft to resolve this issue.
  • Dear Experts,
    another problem which I forget to share with you, i.e. when I run the report it shows me the following error.
    Error executing code: The field with ID '0' does not exist in table 'LedgerTrialBalanceStagingTmp'.
    Stack trace
    (S)\Classes\LedgerTrialBalanceDP\populateTmpTransDetail - line 100
    (S)\Classes\LedgerTrialBalanceDP\processReportDetail - line 28
    (S)\Classes\LedgerTrialBalanceDP\processReport - line 32
    (S)\Classes\SrsReportRunRdpPreProcessService\executeWithContract - line 102
    (S)\Classes\SrsReportRunRdpPreProcessService\executeRDLClasses - line 38
    (C)\Classes\SrsReportRunService\preRunReport - line 26
    (C)\Classes\SrsReportRunImpl\preRunReport - line 12
    (C)\Classes\SrsReportRunController\runReport - line 42
    (C)\Classes\SrsReportRunController\run - line 6
    (C)\Classes\SysOperationController\startOperation - line 10
    (C)\Classes\SrsReportRunController\startOperation - line 12
    (C)\Classes\LedgerTrialBalanceController\main - line 9
  • Hi All,
    I also found a similar error.
    I've been trying to open a report in the General Ledger > Reports > Detailed trial balance. In the form, I input a parameter for Ledger account.MainAccount. When I click OK, I got an error
    Can anybody help me, how to open the report without getting this error?
    Thank you in advance,
  • Hi Ahmed.
    For the error "The field with ID '0' does not exist in table 'LedgerTrialBalanceStagingTmp'" you just need to change the RecordInsertList initialization:
    \Classes\LedgerTrialBalanceDP\populateTmpTransDetail, Line 64:
    Original line:
    recordInsertList = new RecordInsertList(tableNum(LedgerTrialBalanceTmp), true, true, true, true, true, _ledgerTrialBalanceStagingTmp);
    Change to:
    recordInsertList = new RecordInsertList(tableNum(LedgerTrialBalanceStagingTmp), true, true, true, true, true, _ledgerTrialBalanceStagingTmp);
    Compile forward, generate incremental CIL, and it's done.
  • Class_DimensionProvider.rar
    Hi Ahmed,
    About the duplicated ranges bug, the problem is in\Classes\DimensionProvider\addAttributeRangeToQuery method. I'm attaching a XPO with the code fixed.
  • Dear Fabio,
    Thanks for the advice. I have tried and have been successful.
    About duplicate existing range problem on\Classes\DimensionProvider\addAttributeRangeToQuery also been successful in fix


No comments:

Post a Comment

Note: Only a member of this blog may post a comment.