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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Relation Between MainA...
Microsoft Dynamics AX (Archived)

Relation Between MainAccount Table And GeneralJournalAccountEntry

(0) ShareShare
ReportReport
Posted on by Community Member

Hi ,

I need to make ssrs report by x++ code , insert main Account Id and Interval From Date and To Date 

The result is TransactionCurrencyAmount for every transaction 

any help to bind tables 

Thanks .

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Andrew Xu Profile Picture
    Andrew Xu 3,877 on at
    RE: Relation Between MainAccount Table And GeneralJournalAccountEntry

    Hi momenmagdi,

    You might want to check out the report 'Detailed trial balance' which already has the information you need. It's at general ledger->reports->transactions

  • Community Member Profile Picture
    Community Member on at
    RE: Relation Between MainAccount Table And GeneralJournalAccountEntry

    Hi  Andrew Xu ,

    But in this report must choose Financial Dimension Set I need To insert Main Account Number

  • Suggested answer
    Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at
    RE: Relation Between MainAccount Table And GeneralJournalAccountEntry

    Hi,

    Please use the following code/job which provides relation between main account and GeneralJournalAccountEntry

    static void MainLedgerAccount(Args _args)
{
    DimensionAttributeValueCombination  attributeValueCombination;
    DimensionHierarchyLevel             hierarchyLevel;
    GeneralJournalEntry                 generalJournalEntry;
    GeneralJournalAccountEntry          journalAccountEntry;
    DimensionAttribute                  dimensionAttribute;
    DataAreaId                          companyId = curext();

    while select journalAccountEntry
        join generalJournalEntry
            where ((generalJournalEntry.RecId == journalAccountEntry.GeneralJournalEntry)
                && (generalJournalEntry.SubledgerVoucherDataAreaId == companyId))
        join DisplayValue, RecId from attributeValueCombination
            where attributeValueCombination.RecId == journalAccountEntry.LedgerDimension
        join hierarchyLevel
          where (hierarchyLevel.DimensionHierarchy == attributeValueCombination.AccountStructure)
            && hierarchyLevel.Level == 1
        join dimensionAttribute
            where (dimensionAttribute.RecId == hierarchyLevel.DimensionAttribute)
                      
    {
        info(strFmt("Name: %1, value: %2", dimensionAttribute.Name, attributeValueCombination.DisplayValue));
    }
}
  • Suggested answer
    Andrew Xu Profile Picture
    Andrew Xu 3,877 on at
    RE: Relation Between MainAccount Table And GeneralJournalAccountEntry

    Do you have a dimension set only contains ledger account? If not, you'd better to add one. And then you can put your main account number as a criterion in the query.

  • Community Member Profile Picture
    Community Member on at
    RE: Relation Between MainAccount Table And GeneralJournalAccountEntry

    Hi Chaitanya Golla  ,

    But I need To Insert  Account Number Id And Filter All Data By Acc. No. And Date

  • Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at
    RE: Relation Between MainAccount Table And GeneralJournalAccountEntry

    Hi,

    Can you provide the details of the data you want to extract by passing this values.

  • Community Member Profile Picture
    Community Member on at
    RE: Relation Between MainAccount Table And GeneralJournalAccountEntry

    I need Opening balance , Debit  And credit

  • Community Member Profile Picture
    Community Member on at
    RE: Relation Between MainAccount Table And GeneralJournalAccountEntry

    Hi Sukrut Parab ,

    OperationsTax::Current   Operand types are not compatible with the operator.

  • Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at
    RE: Relation Between MainAccount Table And GeneralJournalAccountEntry

    I feel that information is available on TrailBalance form, are you looking for X++ code which provides this details.

    Path: General ledger/Common/Trial balance

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
NNaumenko Profile Picture

NNaumenko 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans