Enter transactions in a closed fiscal year?

(0) Share

Report

Posted on by Oceanfish26

606

D365 - Is it possible to reverse a transaction in a prior year once I have executed the GL > Fiscal Year Close process (assuming the ledger calendar periods are still Open)?

Categories:

Financial Management

All responses (6)

Answers (0)

Suggested answer

Ties Philippi 960 on at

Like (0)

Report

RE: Enter transactions in a closed fiscal year?

Hi Ludwig,

I completely agree with you in regard to the GL parameter 'delete close-of-year-transaction during transfer'.

However I was talking about the undo parameter when you run a year end close. In older versions this was called Reset I believe.

The GL parameter does not affect this, just to be sure I tested it in a Contoso company (10.0.4 / PU28).

Tests with parameter set to Yes:

Transactions Before:

Transactions after running the job with Undo set to yes:

Transactions after running the job with the Undo set to no:

After this I changed the GL parameter back to No, and performing the Undo gave the same result:

Best regards,

Ties Philippi
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (2)

Report

RE: Enter transactions in a closed fiscal year?

Hi,

I think the second option "2. Undo the earlier FYC process, reverse the transaction and redo the FYC process" is not supported out of the box.

One can always re-run the year end closing and D365FO either (a) deletes the prior FYC voucher and creates a new one or (b) it creates an adjustment closing voucher.

Whether D365FO uses (a) or (b) depends on the GL parameter setting 'delete close-of-year-transaction during transfer'.

I would recommend not to activate this parameter because many companies use 3rd party datawarehouse systems for analyzing their data. Deleting a transaction might thus result in reconciliation and data analysis issues with those systems. In addition, the deletion of a voucher is not allowed according to most accounting standards.

Best regards,

Ludwig
Oceanfish26 606 on at

Like (0)

Report

RE: Enter transactions in a closed fiscal year?

Thanks. That's what I understood as well, but of course limited documentation to get that kind of summary.
Ties Philippi 960 on at

Like (1)

Report

RE: Enter transactions in a closed fiscal year?

When you run a FYC two things are done:

* all balance transactions get summarized depending on dimension setup in the FYC and transfered to the opening balance

* all P&L transactions get summarized to the retained earnings.

If you try to run a transaction reversal this would mean creating inconsistency in the earlier transfered FYC transactions.

You can do two things:

1. Enter the correction as a seperate G/L entry without reversing the original transaction and run the FYC process again in which the end result would be that you have an original voucher for the first FYC process and a seperate one for the second correction FYC.

2. Undo the ealier FYC process, reverse the transaction and redo the FYC process. This would result into having just one new FYC voucher.

Best regards,

Ties
Oceanfish26 606 on at

Like (0)

Report

RE: D365 - Enter transactions in a closed fiscal year?

Hmm. Thanks. But with the FYC completed (See screenshot), I receive the following error, "The ledger transaction type Ledger journal for account 11-43020-1-00000- cannot be reversed". When I undo the FYC, I can reverse again. What do you think is causing this?
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: D365 - Enter transactions in a closed fiscal year?

Hi Oceanfish26,

Of course.

As long as the periods are still open you can make adjustments in the previous year.

The only thing to look out for is that you run the fiscal year closing process once again after you recorded your adjustment to ensure that opening balances are ok.

Best regards,

Ludwig