How to re-create fiscal periods in Microsoft Dynamics GP

Note  Before you follow the instructions, make sure that you maintain transaction history and that you have maintained transaction history in the past. If you have not maintained transaction history and you run a reconcile, the summary information may be lost. During a reconcile, the summary information is reconciled to the detail transaction information. If there is no detail for the summary with which to reconcile and you continue with the reconcile, any summary information that you had will be lost. The only way to restore information is from a backup. We recommend that you have a valid backup before you re-create fiscal periods or before you continue with the reconcile. 

Note When you re-create fiscal periods, the period description is reset. For example, if you enter period descriptions, such as period 1 for January, these descriptions are reset.

 To re-create fiscal periods, follow these steps.

Note You cannot change fiscal periods if they are historical.
  1. Print the fiscal period report. You will need this detail later to setup the same fiscal periods again. To do this, follow these steps:
    1. Click Reports, point to Company, and then click Setup.
    2. In the Reports list, click Fiscal Periods.
    3. Click New to create a new report option.
    4. In the Company Setup Report Options window, enter a name (of your choice) for the report in the Optionfield.
    5. Click Print. Click OK.
    6. To determine which years are historical, go to Tools under Microsoft Dynamics GP, point to Setup, point to Company, and click Fiscal Periods. Select each Year and note if the Historical Year checkbox is marked. If the Historical Year checkbox is unmarked, the year has not been closed
  2. Run the following statement against the company database.
  • delete SY40100
  • delete SY40101
  1. Follow the appropriate step:
    • In Microsoft Dynamics GP 10.0, point to Tools on the Microsoft Dynamics GP menu, point to Setup, point to Company, and then click Fiscal Periods.
    • In Microsoft Dynamics GP 9.0 and in earlier versions, point to Setup on the Tools menu, point to Company, and then click Fiscal Periods.
  2. Set up each fiscal period to match the fiscal periods in the report that you printed in step 1. To do this, follow these steps:
    1. In the Year list, click a year.
    2. In the First Day field, type a first day for the fiscal period.
    3. In the Last Day field, type a last day for the fiscal period.
    4. In the Number of Periods field, type the number of periods for the fiscal year.
    5. Make sure that you click to select the Historical Year check box if it was a historical year in the report that you printed in step 1.
    6. Click Calculate.
    7. Repeat step 4a through step 4f for each year in the report.
  3. After you set up all the fiscal periods, click OK.
  4. Follow the appropriate step:
    • In Microsoft Dynamics GP 10.0, point to Tools on the Microsoft Dynamics GP menu, point to Utilities, point to Financial, and then click Reconcile.
    • In Microsoft Dynamics GP 9.0 and in earlier versions, point to Utilities on the Tools menu, point to Financial, and then click Reconcile.
  5. Click to select the Year check box.
  6. If you have historical years in the fiscal periods, click History. Start with the oldest history year first. For example, if the historical years are 2004, 2005, and 2006, start with 2004. If you have no historical years, start with the oldest open year.
  7. Click Reconcile. Microsoft Dynamics GP now processes all general ledger accounts and reconciles the account summary information to the account detail.
  8. Repeat step 6 through step 9 until you have processed all historical years and open years in the correct order.
https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;871789

Comments

Post a Comment

Popular posts from this blog

AOS machines application ( events )

Here are some events from the AOS machines application event that can be useful when managing an AOS: Event Log Entries How to Troubleshoot Event ID 149. Object Server 01: Ready for operation Use this to verify the AOS build/version information from the kernel build section. Event ID 172. Use this to verify the .Net Business Connector build. This is helpful if you think the issue is related to components not being on the same build. Event ID 1000 Use this information along with any Event Id’s of 1001 to confirm the times when the AOS crashes. Event ID 1001 This indicates that they have the option marked to send mini memory dumps to the Watson site. Pass the contents of this event on to your Escalation Engineer so they can review it to see if there is information that points to the issue. Object Server 01: RPC error: RPC exception 1726 occurred in session X This means that the AOS had data to send back to the client but the client was no longer available.
Read more

Critical Hot fixes ( AX 2009 )

Critical Hot fixes The Dynamics AX kernel hotfixes are cumulative fixes that address issues in the executable and dll files for Dynamics AX. These hotfixes do not modify any X++ code, therefore they do not require full X++ code review when deploying to your environment. The kernel fixes are designed to address stability, performance, and compatibility with other software applications. When you apply a kernel hotfix you do want to do testing and the key areas to focus on are printing, pdf functionality, and integration points. When you apply a kernel hotfix you want to be sure that it is applied on all machines that have a Dynamics AX component, such as the client, AOS, or .Net business connector. If you do run into any issues with the Kernel hotfix you can safely remove the hotfix from the Programs and Features area of the Control Panel. It is recommended that you consider regular installation of Kernel rollups in your Microsoft Dynamics AX environments. We find that many times w
Read more

This transaction has been marked for settlement by another user in AX 2009 / 2012

Image
“I need to settle a customer (or vendor) transaction but when I go to the ‘Settle open transactions’ form for the customer (or vendor), I cannot mark the transaction. There is a red icon in the ‘Is marked’ field and I receive an error if I try to mark. I’ve looked all over and I cannot find where to unmark it." Solution When this happens, the user has generally already done their due diligence and checked the likely places to find where the transaction may be marked – in other journals of the same type, in the Settle open transactions form, etc. and still cannot find where it is mysteriously marked. To find where the transaction is marked, take the following steps: 1. Go to Accounts receivable-> Common-> Customers-> All customers-> highlight customer-> Collect tab-> Settle open transactions (similar path for Vendor transactions). Normally you will see the transaction still has the red icon indicating the transaction is still marked elsewhere. 2. Highlight the rec
Read more