web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Sorry, cannot post to a closed peroid

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,633 Moderator on at

    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.

  • Suggested answer
    Tristan Clores Profile Picture
    2,812 on at

    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.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,633 Moderator on at

    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.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans