Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Sorry, cannot post to a closed peroid

Posted on by Microsoft Employee

Dynamics GP 10 SP5

Example:

Received an "itemA" in November with a cost of "110.00"

In November "Item A" was sold.

In January we received the invoice for "Item A" with a cost of "120.00"

When we  go to Transactions->Purchasing->Enter/Martch Invoice

The General Posting Jounalreports , for the cost difference of "10.00" , posting back to November (period closed) fails,  with the error message "Sorry, cannot post to a closed period".

Last month we had over 1,000 transactions with this type of error.

Scourered over every blog and forum, can anyone help.

Manually fixing each transaction at the end of the month is killing our finance department.

Thank you

Peter

*This post is locked for comments

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Sorry, cannot post to a closed peroid

    Tristan, in theory that would work.  However, few companies would want to go back and restate previous month financials because of a system-based adjustment.

  • Suggested answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at
    RE: Sorry, cannot post to a closed peroid

    Hi Peter,

    Just go to the Fiscal Period Setup window (MDGP | Tools | Setup | Company | Fiscal Periods), pull up the year and then UNMARK the November period for Financials.  Save the settings.

    Once done, pull up your batch in GL (Transactions | Financial | Batches) and then print the Edit List.  The error should now be gone.  Post the batch.

    Please let me know if you have further questions.

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Sorry, cannot post to a closed peroid

    Peter, I'll bet you have 'Revalue Inventory for Cost Variance' checked in your Item Classes and Item Purchasing Options.  Read my blog post about this here - gp2themax.blogspot.com/.../gptip42day-revalue-inventory-for-cost.html.

    When this box is checked, Purchase Receipt costs are updated during the Invoice match process, updating the unit cost on the receipt layer.  If that receipt layer has been sold, GP adjusts COGS for previously sold items from the layer in the period in which the item was sold.

    Uncheck the box in your Item Classes, roll the changes down to the items, and that should resolve the issue.

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans