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 NAV (Archived) / Trial Balance column l...
Microsoft Dynamics NAV (Archived)

Trial Balance column layout

(0) ShareShare
ReportReport
Posted on by Dwumor 100

Hi Partners,

I am using account schedules to design Trial Balance Report and the following is what I indicated as columns

1.  column heading= Balance Debit and Credit

2. Column type  = net change

3. Amount type= Debit and Credit amount.

Yet the TB is not displaying well. Am I missing something. Many thanks in advance.

Regards

*This post is locked for comments

  • ManishS Profile Picture
    ManishS 78 on at
    RE: Trial Balance column layout

    Is this sorted out ? as i see it has been verified.

  • Dwumor Profile Picture
    Dwumor 100 on at
    RE: Trial Balance column layout

    Tatiana, I find it very hard to attach documents on this platform. When I upload I usually have a send error.

  • Suggested answer
    tpupko Profile Picture
    tpupko 2,048 on at
    RE: Trial Balance column layout

    Hi Richard,

    Could you attach please your screen with report please

  • Dwumor Profile Picture
    Dwumor 100 on at
    RE: Trial Balance column layout

    Hi Mahesh,

    When you click on the overview, you will see the same Debit amount appearing in the Credit column. That is what I mean. Is my row selections ok for trial balance:

    1.  column heading= Balance Debit and Credit

    2. Column type  = net change

    3. Amount type= Debit and Credit amount.

    Pls confirm

  • Dwumor Profile Picture
    Dwumor 100 on at
    RE: Trial Balance column layout

    Hi Tatiana,

    Have done that but the issue is the same. But is the row selections correct in the column layout:

    1.  column heading= Balance Debit and Credit

    2. Column type  = net change

    3. Amount type= Debit and Credit amount.

  • Suggested answer
    tpupko Profile Picture
    tpupko 2,048 on at
    RE: Trial Balance column layout

    Export-to-Excel.jpgHi Richard,

    It might be that you have problem with printer parameters. Please try to export report to excel

  • Dwumor Profile Picture
    Dwumor 100 on at
    RE: Trial Balance column layout

    Hi Tatiana,

    Thanks the response. Your submission is fine but what options do you select in the rows in the column layout to get this output. I have tried several if them but I see the debit amount appearing again in the credit column. What might I be missing. Thanks  

  • Verified answer
    tpupko Profile Picture
    tpupko 2,048 on at
    RE: Trial Balance column layout

    Hi, 

    You have to see 4 columns 

    Debit and Credit for Net Change

    Debit and Credit for Balance

    Trial-Balance.png

    Tatiana

  • mmv Profile Picture
    mmv 11,467 on at
    RE: Trial Balance column layout

    Hi,

    What you mean by TB is not displaying well?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans