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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Trial Balance column layout

(0) ShareShare
ReportReport
Posted on by 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

I have the same question (0)
  • mmv Profile Picture
    11,471 on at

    Hi,

    What you mean by TB is not displaying well?

  • Verified answer
    tpupko Profile Picture
    2,048 on at

    Hi, 

    You have to see 4 columns 

    Debit and Credit for Net Change

    Debit and Credit for Balance

    Trial-Balance.png

    Tatiana

  • Dwumor Profile Picture
    100 on at

    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  

  • Suggested answer
    tpupko Profile Picture
    2,048 on at

    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
    100 on at

    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.

  • Dwumor Profile Picture
    100 on at

    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

  • Suggested answer
    tpupko Profile Picture
    2,048 on at

    Hi Richard,

    Could you attach please your screen with report please

  • Dwumor Profile Picture
    100 on at

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

  • ManishS Profile Picture
    86 on at

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

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…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans