web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Trail balance ListPage...
Microsoft Dynamics AX (Archived)

Trail balance ListPage is not showing Ledger Account Name

(0) ShareShare
ReportReport
Posted on by gsbsrk b 692

Hi Techies,

In AX 2012 R2 Trail balance list page is not showing ledger account (Main account ) name in List page.

But this name or Description is showoing in AX 2012 R2 CU7 and AX 2012 R3 CU8.

I want to implement same in  Microsoft Dynamics AX 2012 R2.

Does any one did this.

Captureeee.JPG

 

Can any one give me some techinical guidence how to acheive this

 

Thanks,

Krishna

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Krishna,

    Have you personalized the form so that the name does not show up?

    Probably reset you personalizations for that form.

    If this does not work can you check then whether you can add the LedgerTrialBalanceTmp.Description field to the LedgerTrialBalanceListPage form grid? This should be possible by dragging and dropping the description field from the datasource to the grid section if it is missing there.

    Best regards,

    Ludwig

  • gsbsrk b Profile Picture
    gsbsrk b 692 on at

    Dear Ludwig,

    Thanks fou your prompt reply.

    In Microsoft Dynamics AX 2012 R2 CU1 Version Decription column is not available.

    Later versioins they implemented (It's available in Microsoft Dynamics AX 2012 R2 CU7).

    For this i wrote display method in datasource level.

    Thanks,

    Krishna

  • Verified answer
    gsbsrk b Profile Picture
    gsbsrk b 692 on at

    display Str1260 dimValueDescription(LedgerTrialBalanceListPageTmp _ledgerTrialBalanceTmp)

    {

       GeneralJournalAccountEntry          generalJournalAccountEntry;

       DimensionAttributeLevelValueAllView dimAttrView;

       DimensionAttribute                  dimAttr;

       OMOperatingUnit                     OMOperatingUnit1,OMOperatingUnit2;

       str                                 MAName,BUName,CCName,workerName;

       Str1260                             description;

       while select DisplayValue from dimAttrView where dimAttrView.ValueCombinationRecId == _ledgerTrialBalanceTmp.LedgerDimension

               join BackingEntityType from dimAttr where dimAttr.RecId == dimAttrView.DimensionAttribute

       {

           switch (dimAttr.BackingEntityType)

           {

               case tableNum(DimAttributeMainAccount):

                   MAName = MainAccount::findByMainAccountId(dimAttrView.DisplayValue).Name;

                   break;

               case tableNum(DimAttributeOMBusinessUnit):

                   select firstonly OMOperatingUnit1 where OMOperatingUnit1.OMOperatingUnitNumber == dimAttrView.DisplayValue;

                   BUName = OMOperatingUnit1.Name;

                   break;

               case tableNum(DimAttributeOMCostCenter):

                   select firstonly OMOperatingUnit2 where OMOperatingUnit2.OMOperatingUnitNumber == dimAttrView.DisplayValue;

                   CCName = OMOperatingUnit2.Name;

                   break;

               case tableNum(DimAttributeHcmWorker):

                   workerName = HcmWorker::findByPersonnelNumber(dimAttrView.DisplayValue).name();

                   break;

           }

       }

       if(MAName)

           description = MAName;

       if(BUName != "")

           description += "-" + BUName;

       if(CCName != "" )

           description += "-" + CCName;

       if(workerName != "")

           description += "-" + workerName;

       return description;

    }

    My Ledger dimension is combination with Main Account,businesunit,costcenter

    Ex: 68810-0102-402

    Main Account: 68810 (Rounding account)

    Busines Unit: 0102 (Bio science)

    Cost center: 402   (India)

    Desired OutPut : Rounding account-Bio science - India

    Thanks

    Krishna

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans