Finance | Project Operations, Human Resources, ...

Financial reports - Trail balance

(0) Share

Report

Posted on by Nijo

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

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Morgan Bazin 95 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
IvyYY 175 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Nijo 15 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 20,717 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi,

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

Was this reply helpful? Yes No
Nijo 15 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
IvyYY 175 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No