Microsoft Dynamics AX (Archived)

Transaction Date 28 feb 2019 not in a closing period

(0) Share

Report

Posted on by Vinesh Tandel

580

Hi All,

i have a issue.

As per MSDN blog closing adjustment should be done for a particular ledger (say : 12345) to transfer the balance during month closing for jan. if we missed. Next option is to pass adjustment entry in Feb month closing. so from below blog tried to do closing entry but getting a error "Transaction Date 28 feb 2019 not in a closing period".

https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/make-closing-adjustments-in-the-closing-sheet

Kindly provide some insights to resolve this issue, thanks in advance.

Kind regards,

Vinesh Tandel

*This post is locked for comments

All responses (13)

Answers (0)

Klaas Deforche 2,431 on at

Like (1)

Report

RE: Transaction Date 28 feb 2019 not in a closing period

Hi Ludwig,

In my case rebuilding the financial dimension set balances solved the issue.

My theory is that the dimension set was changed (adding a new dimension or something), which causes duplicate lines in the trial balance.

These dissapear after rebuilding.

Best regards,

Klaas.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: Transaction Date 28 feb 2019 not in a closing period

Hello Vinesh Tandel,

I see.

If this is a data related issue then the following things should fix this:

1. Reset your usage data and

2. Clear, rebuild and update the financial dimension set balances. This can be achieved in the financial dimension sets form in GL.

Would be great if you could check this and let us know the outcome.

Many thanks,

Ludwig
Vinesh Tandel 580 on at

Like (0)

Report

RE: Transaction Date 28 feb 2019 not in a closing period

Thank you very much Mr Reinhard for your valuable feedback much appreciated. We have reviewed but i think it is a data related issue.

As trial balance summary report runs correctly if we run it with all Financial dimension in report parameter.It is a issue only when we run

with "Main account". However for ledger account apart from "812101" report runs fine and data after posting it does not create any second line.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Transaction Date 28 feb 2019 not in a closing period

Hi,

I think that you should have a developer taking a look at that. There seems to be something 'defect'.

Best regards,

Ludwig
Vinesh Tandel 580 on at

Like (0)

Report

RE: Transaction Date 28 feb 2019 not in a closing period

Getting to basics of the issue.

Issue :

After posting manual Journal Entry to offset balance of GL#812101,
the posted amount didn’t show on Summary Trial Balance.

Above is the screen shot
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Transaction Date 28 feb 2019 not in a closing period

Hello Vinesh Tandel,

Have you made any progress here and found a fix for the problem?

Best regards,

Ludwig
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Transaction Date 28 feb 2019 not in a closing period

Hi,

The trial balance form looks indeed strange.

Have you tried selecting a financial dimension set other than 'main account set'?

If you have to use this financial dimension set, can you try recalculating/update the balances?

In addition, can you clear your usage data and ensure that the report is not run with any additional (hidden) filter to ensure that filtering the main account is not the underlying issue.

Do you only see this strange behavior or all system users?

Best regards,

Ludwig
Vinesh Tandel 580 on at

Like (0)

Report

RE: Transaction Date 28 feb 2019 not in a closing period
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Transaction Date 28 feb 2019 not in a closing period

Hi,

Right below the box where you enter a text, you can select 'use rich formatting'. This opens up a new screen where you can upload screenshots.

Best regards

Ludwig
Vinesh Tandel 580 on at

Like (0)

Report

RE: Transaction Date 28 feb 2019 not in a closing period

I am not able to attach screenshot here i cannot find any option.