Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Identify fields for op...
Microsoft Dynamics AX (Archived)

Identify fields for opening and closing in trial balance

(0) ShareShare
ReportReport
Posted on by Bhavesh Gohel 115

For Trail balance, I am using LedgerTrans for generating report as it has voucher, journal num etc. But which fields can be consider for opening balance & closing balance?

ACCOUNTNUM
TRANSDATE
VOUCHER
TXT
AMOUNTMST
AMOUNTCUR
CURRENCYCODE
TRANSTYPE
DIMENSION
DIMENSION2_
DIMENSION3_
QTY
DOCUMENTDATE
JOURNALNUM
JOURNALIZESEQNUM
ALLOCATELEVEL
POSTING
CORRECT
CREDITING
DOCUMENTNUM
PAYMREFERENCE
PERIODCODE
OPERATIONSTAX
THIRDPARTYBANKACCOUNTID
COMPANYBANKACCOUNTID
PAYMMODE
JOURNALIZENUM
FURTHERPOSTINGTYPE
LEDGERPOSTINGJOURNALID
CONSOLIDATEDCOMPANY
REASONREFRECID
MODIFIEDDATETIME
MODIFIEDBY
CREATEDDATETIME
DEL_CREATEDTIME
CREATEDBY
CREATEDTRANSACTIONID
DATAAREAID
RECVERSION
RECID
DEL_PURCHLEDGERID
AMOUNTMSTSECOND
EUROTRIANGULATION
TAXREFID
DEL_LEDGERTRANSREPORTTYPE
DEL_VOUCHERSEQUENCECODE
DEL_LEDGERPOSTINGJOURNALREGI36
ACKNOWLEDGEMENTDATE

Above is the fields of LedgerTrans table. But not able to find the field to bifurcate the opening and closing balance. Can you please help me to identify the columns?

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Identify fields for opening and closing in trial balance

    Hi Bhavesh Gohel,

    Why you try to develop that improved report?

    Have you already checked the additional standard tools especially the management reporter that is available in AX2009 CU5?

    In addition, there are a couple of standard cubes that can give you all the information you look out for.

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Identify fields for opening and closing in trial balance

    Hi Bhavesh,

    Do you need more information from us? I don't know what you intended to say with your last comment.

  • Bhavesh Gohel Profile Picture
    Bhavesh Gohel 115 on at
    RE: Identify fields for opening and closing in trial balance

    Yes, Correct.

    And So, I need each and every information in details.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Identify fields for opening and closing in trial balance

    Hi,

    Do I understand you correctly that you want to create a new / better / improved trial balance report?

    Best regards,

    Ludwig

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Identify fields for opening and closing in trial balance

    Hi Bhavesh,

    AX2009 has been a long time ago for me. I thought that the PeriodCode field indicates if it is posted in a normal, closing or opening period.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans