Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

fiscal period for the posting date does not exist

Posted on by 155

Hi,

I am trying to post a second batch for the month in GP 10, it errors out stating "fiscal period for the posting date does not exist", I have validated in SY40100 and SY40101 there is a valid month and the dates on the batch is 11/30/2014, it was successfully posted first batch but errors on second batch. After the posting error I checked the transactions in PA10200, Posting date (PAPD) column in PA10200 is converted into 1900-01-01. When I posted the same batch in our QA in posts fine with out issue. Can some please help me on this.

*This post is locked for comments

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: fiscal period for the posting date does not exist

    Try running the Reconcile Utility on the Fiscal Periods table.  Administration>>Utilities>>Reconcile>>Period Setup.

  • Baradhi Profile Picture
    Baradhi 155 on at
    RE: fiscal period for the posting date does not exist

    Thank You Baskaran, The Import files were good.

    User messed up the Batch master import template on the Production server, the batch date mapping was empty, when the file is imported it was given a default date as 1900-01-01. Re mapped it and imported the file and posted, it worked perfectly.

    Thank You.

  • Suggested answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: fiscal period for the posting date does not exist
    As Bill says, when you're checking calendars it is best to check them through the Setup window in GP rather than looking on the database. If you're certain that the calendar is right, then Babu is probably on the right lines that their is an invalid date on the batch, transaction, in the Posting Date field.
  • Suggested answer
    RE: fiscal period for the posting date does not exist

    Hi Baradhi,

    This might be due to the batch doesn't have valid batch date and posting date coming from batch date.  Please try to change the setup-posting-posting-posting date from Transaction instead of batch and try again.

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: fiscal period for the posting date does not exist

    I am hoping that you have looked at Administration >> Setup >> Fiscal Period

    Not only to see that the fiscal year is there - but also that the period is complete.  I seen cases where someone tried to mannually enter the start and end dates for the Fiscal Periods and missed a day on one month - that is a problem - but not one that is easy to catch.

    When you have two environments, remember that they do not share the same configuration - might when youstart, but once you enter data into one and not the other or make a 'minior' change in one and not the other, they are no longer the same, so you can not always rely on what happens in one to be the same as in the other.

    Final thing to check is the Date / Time format on your computer - sure it is right - but hey try anything at this point.

    Good luck.  If this helps, let me know.

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans