Financial reports year end

(0) Share

Report

Posted on by CapsLock

1,419

Hi there,

I have the following scenario I´m trying to find an explanation for:

I have run the year end close in a company in D365FO.

in the GL parameters, the checkbox "Create closing transactions during transfer" is set to "no". Therefore, the TB on the last day of the fiscal year being close, shows the amounts per PL main account.

The weird thing is that when going to Financial reports and extract a TB per month for the whole year being closed, the last month appears with empty PL accounts and the total of the PL in a single line at the bottom. I don´t see any settings on the column definition that controls this.

Anyone can share any insights of why this may be happening?

PL = profit and loss

Thanks!

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

is it because the whole amount is transferred to the "retained Earning" ? Can you please share the screen shot for the same?

Was this reply helpful? Yes No
CapsLock 1,419 on at

Like (0)

Report

Hi Saurabh,

Yes, the total amount is transferred to the retained earnings accounts but the posting for this happens on the opening transactions, this is first day of the new fiscal year. That is why the trial balance at the last day of the fiscal year we are closing has the PL amounts still split per main account. The problem is that there seems to be an inconsistency with Financial Reports in which PL accounts at the last month of the fiscal year are all to zero already.

It may be because the fiscal year close has been run many times and this has created bug/inconsistencies in the middle.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

would be ideal to undo close, clean and closing sheet and close again

Was this reply helpful? Yes No
CapsLock 1,419 on at

Like (0)

Report

HI Rahul, thanks for replying. What do you mean by "clean and closing sheet"? Thanks again!

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi CapsLock,

Can you share the financial report configuration that shows that the last period P&L transactions are all zero/empty?

Many thanks,

Ludwig

Was this reply helpful? Yes No
Verified answer

Rahul Mohta 21,032 on at

Like (1)

Report

sharing one of blog

community.dynamics.com/.../year-end-in-microsoft-dynamics-365-finance-and-operations

Closing sheet is a way to get all balances there, use some allocation and review which accounts would go to result (e.g. P&L) and which would go as it is (Balance sheet)''h

hope it helps

Was this reply helpful? Yes No