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

This question is answered
Ahmed Muhammad Alam
POSTED BY 
ON 17 FEB 2013 3:11 AM
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.
Regards,
Ahmed
  • Ahmed Muhammad Alam
    POSTED BY 
    ON 26 FEB 2013 5:03 AM
    Any suggestion
  • Ahmed Muhammad Alam
    POSTED BY 
    ON 26 MAR 2013 3:34 AM
    Dear Experts,
    Is there any patch or hot fix from the Microsoft to resolve this issue.
    Regards,
    Ahmed
  • Ahmed Muhammad Alam
    POSTED BY 
    ON 8 APR 2013 4:21 AM
    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\RecordInsertList\add
    (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
  • bsugitayasa
    POSTED BY 
    ON 7 MAY 2013 3:48 AM
    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,
    bsugitayasa
    DYNAMICS AX 2012 TRIAL BALANCE REPORT DETAIL BUG
  • Fabio
    POSTED BY 
    ON 8 MAY 2013 4:01 AM
    SUGGESTED ANSWER
    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.
    Cheers
    DYNAMICS AX 2012 TRIAL BALANCE REPORT DETAIL BUG
  • Fabio
    POSTED BY 
    ON 8 MAY 2013 8:08 PM 
    VERIFIED ANSWER
    VERIFIED BY 
    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.
    Cheers
    DYNAMICS AX 2012 TRIAL BALANCE REPORT BUG RANGE
  • bsugitayasa
    POSTED BY 
    ON 13 MAY 2013 9:47 PM 
    VERIFIED ANSWER
    VERIFIED BY 
    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

    Cheers

No comments:

Post a Comment

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

Subscribe to: Post Comments (Atom)