Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
Inventory Costing in Microsoft Dynamics AX 2009
Invoice Settlements/Discounts/Reversals
SSRS and SSAS Integration
Workflow
Dears,
One of our users accidently closed periods from GL --Setup --Periods -- until March, 2012... what is the possibility of reopening the closed transactions and if not, can we close year 2011?
Your help and assistance are highly appreciated.
Thank you
Suha
if you did not have run the Fiscal year close process then you can write the simple job to update the status of period to open.
table is LedgerPeriod, there should be PeriodStatus field that need to be updated.
Amirhttps://msdax.wordpress.com
Dear all,
I would really appreciate your suggestions and comments ... i have a situation where we cannot reverse or update entries prior to closing !!! what can we do ?
Thank you to let me know
Hi Suha,
Did you run the fiscal year closing process? what is the current status of the period in GL --Setup --Periods. Also let me know which AX version are you using
Regards,
Sundeep
Hi,
In fact, we did not run the fiscal year closing process for 2011... the current status of the periods is (closed) for each month prior to April, 2012.. We are using AX2009
Yes, i agree to Amir's suggestion. You may have to write a code to update the status as the form does not allow to change the status back to OPEN. I am not sure if it will work as desired as i have never faced this earlier.
You may also refer to an interesting article written by Sanam Khan:-
community.dynamics.com/.../why-the-fiscal-year-close-in-microsoft-dynamics-ax-2009-is-so-important-and-how-to-get-it-right.aspx
Dear Sundeep and Amir,
thank you so much for the info and support :) .. i will test updating the status on a testing environemnt and let you know the feedback..
It worked :). Thank you very much.
Truly appreciate your support
Hi there,
I'm facing with the same problem too. Would be appreciated if you could share with me the codes as I'm still new AX.
you may run a simple sql stat. to update the periodstatus from the table LedgerPeriod OR you can update manually .
Sorry, I still couldn't catch you. Could you please explain in step by steps? I have tried editing the periodstatus field directly from the table LedgerPeriod but system give me error message "A closed period cannot be reopened."
you can use below job to update periods status
LedgerPeriod period = LedgerPeriod::find(1\12\2010,PeriodCode::Regular);
;
ttsbegin;
period.selectForUpdate(true);
period.PeriodStatus = LedgerPeriodStatus::Open;
period.doupdate();
ttscommit;
I copy-and-paste your codes and it gives error message "***Error: -1, Syntax error."
show us the complete message, info message also . have you compiled after pasting the code in job ? is it compiling correctly.
Sharon,
Since you are new to coding, when you try to update directly from the table .. you will get a warning msg.. 'A closed period cannot be reopened." Just Double click the msg then comment the lines that appear in the code.
Good luck...