How to change date for a fiscal year in Ax 2012

(0) Share

Report

Posted on by Community Member

Hi All,

While creating periods for a fiscal year 2016 by mistake i inputted incorrect date i.e 30/12/2016 (actually should be 31/12/2016).

Already few transaction have been posted in this fiscal year & not allowing me to delete current year & now I want to update the date.

Could you please suggest me correct way of doing this.

Thank you very much in advance.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Rohit113,

Is it right that you want to record already some transactions for 31 December 2016?

Can you provide some additional information on what transactions have already been entered? (GL journals, AP invoice journals, Sales order invoices, ...)?

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Ludwig

Thank you very much for your reply,

Yes , We have invoiced some SO & PO with yesterday's date including some GL journal entries.

Also, there is only 1 Quarter selected for the whole year.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Rohit1103,

Depending on the number of records that have been entered, I believe that correcting the GL journals manually is the fastest and easiest solution.

If there are lot of transactions recorded you can probably make use of the Excel-Add-in or the DataImportExportFramework to extract, correct, import and post those transactions correctly.

When it comes to SO and POs things get more complex.

If only some packing slips are recorded you can try correcting them via the standard packing slip correction function.

If also invoices have been posted try to get them corrected by opening and cancelling the transactions via the customer/vendor master posting form. Please note that this might not be possible in each and every case. If it cannot be done with the standard "invoice cancel" features I would talk to the accountants first if they can do a manual correction at the ledger account level only without touching the AP/Sales subledgers. If this is not feasible in your case, you probably need the help of a developer to get things corrected.

All the best,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Ludwig.

I appreciate your quick reply.

But Do I need to cancel all the transaction & then delete the fiscal year & need to create it again?

Or I can just update the related tables

1) FiscalCalendarPeriod

2) FiscalCalendarYear

to update the date from 30/12/2016 to 31/12/2016/

OR there is another way if transactions are too many?

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

Like (0)

Report

Hello Rohit1103,

Ok. The issue is the following:

If you posted something wrong let's say on 30 December instead of 31 December and need the a posting date 31 December, then the only way is to correct the transactions recorded. There is no other way as AX saves transactions by a (trans-) date.

If your only issue is that the accounting periods have been setup incorrectly then you can always do this correction without the requirement of canceling and posting transactions again. One way of doing that is Setting up a new fiscal calender with the correct Separation of the accounting periods, allocating this calendar in the leder window in GL and then selecting recalculate periods. Depending on the number of Transactions that you have this might take some time but is actually not an issue for AX as it saves the transactions not by period but by date. Some additional Information on this can be found here: technet.microsoft.com/.../hh227379.aspx, msdax12.blogspot.de/.../fiscal-calendar-fiscal-year-and-periods.html

Hope it helps,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Ludwig,

Yes, I also came across same solution of creating new Fiscal Calendar.

But as we were using the same Fiscal calendars from last 4 years, I was worried to do so just for the small case where I need to add one more day in the year.

That's the reason I was thinking to update the date from back-end but not sure if it is going to update it properly or not.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Rohit1103,

I see. If you already use the fiscal calendar for 4 years then recalculation might take long. I am not sure whether the change you mention from back-end works as fiscal calendars are share among companies and I am not sure what might happen in the other companies you are using. Probably the only way to find out is testing this in a demo environment copied from your live system.

Regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you very much Ludwig for your kind support.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Does any one has views on what will be the impact if I will change the date directly from backend???

I have tested at test environment but till now not faced any issue.

Was this reply helpful? Yes No
Suggested answer

Chandu Naresh 982 on at

Like (0)

Report

Hi Rohit,

Create a new Fiscal calendar (with the required Fiscal Year) and change the organizational calendar to the new Fiscal Calendar under the Ledger setup of the legal entity (GL> Setup > Ledger)

Now, you can modify the current Fiscal year manually. Once modified, revert the Fiscal calendar to the old Fiscal calendar.

Once you are done, you may wish to delete the newly created Fiscal Calendar.

recommended once you are done with this process, click on the Recalculate ledger periods button

Was this reply helpful? Yes No