Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Trial Balance

Posted on by 3,027

Hi

  How to generate Trial Balance using G/l Entry Table. I am using G/l Account & G/l Entry table but it is taking a long time. Nothing is in the code. Performance should be fast

Thanks

*This post is locked for comments

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Trial Balance

    You can put conditions for not showing zero value . Check for visibility property in RDLC layout and put expression for not showing zero value rows.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Trial Balance

    Dear Maneesha

    I dont want to have a detailed TB which shows complete COA. I just need to see the accounts with transactions Only.

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: Trial Balance

    hi ,

    i think on your requirement there is no need any customization

    there also some various trail balance report on following location

    Departments/Financial Management/General Ledger

    inside that you have total advance filter to filter anything to get the report

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Trial Balance

    Debit Amount field is not flowfield in GL Entry table. You need to add those fields which are flowfields

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Trial Balance

    Hi

     I have G/l Account , G/L Entry table as Dataitem. In G/L Entry Property i have entered Debit Amount , Credit Amount as Cacl fields . When i run it gives error The Debit Amount in the G/L entry table must be a FlowField.

    Thanks

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Trial Balance

    Check fields Balance,Balance At Date,Net Change,Debit Amount,Credit Amount

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Trial Balance

    which are the flow fields . Kindly guide

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Trial Balance

    In g/L account table required flow fields are there for Trial balance report  ,which are calculated from GL entry table.

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Trial Balance

    Hi

      I have to read G/L accounts and get data from G/L Entry. What is the best possible way so that Performance should be fast

    Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Trial Balance

    Hi,

    Do you know how to get the complete trial balance without ZERO figures?

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans