Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Financial reports - Trail balance

(0) ShareShare
ReportReport
Posted on by 15

Hi,

I am stuck building the trail balance for a client.

I want to build a trail balance with;

Opening balance (always locked on the 20xx-01-01 for the year of the report date)

Debet (from 20xx-01-01 to report date)

Credit  (from 20xx-01-01 to report date)

Accumulated debet and credit

Closing balance (sum of opening balance + accumulated of debet/credit) (on report date)

With my setup, se below, i have the following problems:

1. My numbers always change to the month of report date. 

 If I choose YTD in debet and credit I get wrong numbers, I also get my year end closing transactions.

2. If report date is January, my sum of opening balance disappears which gets me the wrong number when I sum closing balance.

4428.image.png

pastedimage1675259652236v1.png

rapport.png

  • IvyYY Profile Picture
    IvyYY 130 on at
    RE: Financial reports - Trail balance

    Hi Nijo,

    Maybe double check your Base period, Base year and Report date setup. We are in Feb, so perhaps your Date info should be as follows for S-1, Report date: 31/01/2023, Base period: 1, Base year: 01/01/2023 - 31/12/2023. 

    Thanks

  • Nijo Profile Picture
    Nijo 15 on at
    RE: Financial reports - Trail balance

    S is not a choosable option from my list and when I write it manually I get at message that "S is not a valid standard base period option for this company".

    Is that something I can add somewhere?

  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 16,620 Most Valuable Professional on at
    RE: Financial reports - Trail balance

    Hi,

    Did you try to change the standard base period to S?

  • Nijo Profile Picture
    Nijo 15 on at
    RE: Financial reports - Trail balance

    Thanks for the replys.

    My base period always become 1 month.

    So when I do the report for the  Jan 31 I get opening balance for Jan 1 and closing balance for Jan 31.

    When I do the report for Feb 28 I get opening balance for Feb 1 and closing balance for Deb 28, and so on.

    I tried to change base period in report definition but it always change back to base period 1.

    I want to have my base period to change depending on my report date. So if I choose report date Feb 28 I want opening balance for Jan 1 and closing balance for feb 28, and so on. 

    Is this possible in any way?

  • IvyYY Profile Picture
    IvyYY 130 on at
    RE: Financial reports - Trail balance

    Hi Nijo,

    For troubleshooting, I would recommend you create debit and credit columns for every month (you may choose not to print them), and then calculate your accumulative amount. A bit tedious, I know... but it may help you identify the issues faster. Hope this helps!

  • Morgan Bazin Profile Picture
    Morgan Bazin 44 on at
    RE: Financial reports - Trail balance

    I would recommend reviewing the default building blocks described in this article: Trial balance financial reports - Finance | Dynamics 365 | Microsoft Learn

    This may help in identifying what needs to be changed in your column definitions.

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…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,966 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans