Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

How to change Year in Fiscal period setup

(1) ShareShare
ReportReport
Posted on by 1,771

Hi,

We are using June to July fiscal calendar year in GP.  Now we want to change to Jan to Dec fiscal calendar year.  I tried to change current year fiscal period setup(Year 2018) to July 2017 to Dec 2017 for 6 months and created new fiscal period setup (Year 2019) for Jan 2018 to Dec 2018.  Run year-end for  June to July fiscal calendar year, it is working. But one issue is, the year of calendar is 2019 but it contain Jan 2018 and Dec 2018.

Please let me know how to change year from 2019 to 2018 and again 2018 is existing so system will not allow, other option to change 2018 to some old year like 2000 which was not in fiscal calendar year. and change 2019 to 2018

I changed year from back-end by using below scripts and run financial reconciliation but the it is giving error and not matching the TB.

UPDATE SY40101

SET YEAR1 = 2018

where YEAR1 = 2019

Kindly provide solution for this issue.  Please find screen-shots for your reference.

8228.a2.png

6136.a1.png

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to change Year in Fiscal period setup

    [quote user=""P"][/quote]

    Hi,

    We are using June to July fiscal calendar year in GP.  Now we want to change to Jan to Dec fiscal calendar year.  I tried to change current year fiscal period setup(Year 2018) to July 2017 to Dec 2017 for 6 months and created new fiscal period setup (Year 2019) for Jan 2018 to Dec 2018.  Run year-end for  June to July fiscal calendar year, it is working. But one issue is, the year of calendar is 2019 but it contain Jan 2018 and Dec 2018.

    Please let me know how to change year from 2019 to 2018 and again 2018 is existing so system will not allow, other option to change 2018 to some old year like 2000 which was not in fiscal calendar year. and change 2019 to 2018

    I changed year from back-end by using below scripts and run financial reconciliation but the it is giving error and not matching the TB.

    UPDATE SY40101

    SET YEAR1 = 2018

    where YEAR1 = 2019

    Kindly provide solution for this issue.  Please find screen-shots for your reference website.

    6136.a1.png

    6136.a1.png

    1. Use the appropriate method: ...
    2. Click to select the year check box, and then click the earliest year in the list.
    3. Click Reconcile.
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to change Year in Fiscal period setup

    In the Fiscal Periods Setup window, click the current year in the Year list. In the Number of Periods field, type the number of periods for the fiscal year.

    To do this, follow these steps:

    Use the appropriate method:

    Click here to select the Year check box, and then click the earliest year in the list.

    Click here Reconcile.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans