196
when cost changes and trigger auto cost adjustment trx (doctype 101,103 etc), we notice it will post through to GL even the period is closed.
anybody face similar issue before?
thanks.
Hello-
My apologies for any confusion. The transaction will still get created to a GL batch but should NOT post to the history year if the Financial Series is closed for that period in the Fiscal Period window. It could still post to the history year if the Inventory Series was marked as closed though. If you do replicate this posting through GL even if the Financial Series Fiscal period was marked as closed, please open a support case as this would be unexpected.
Adam G.
>>Transactions can be posted to the most recent history year regardless if the fiscal period was marked as closed or not. <<
Are you saying that if allow posting to history is marked in Financial Setup, then even if the fiscal period is closed, then transactions can still be posted to the closed fiscal period ???
e.g.: year 2019 is history year and fiscal period dec/2019 is closed, user can still post to dec/2019??
in my testing, with allow posting to history marked, year 2019 is history, and period dec/2019 is closed for all modules, I am not able to post to dec/2019, unless I open dec/2019.
please confirm.
Yes, if you are seeing a transaction post to a historical year, it means that the Allow Posting to History option is getting marked under: Microsoft Dynamics GP Under: Financial >> Setup >> Financial >> General Ledger(GL). Unmark this option going forward to prevent the transaction from posting to a closed year. This is separate from the fiscal periods getting closed. Transactions can be posted to the most recent history year regardless if the fiscal period was marked as closed or not.
Hi,
thanks for reply with clear explanation.
That's not my question as I probably not making it clear enough.
the issue here is, for example:
* inventory posting is post through GL
* year 2019 is closed (hence history year)
* all fiscal period for 2019 is marked closed (finance, sales, purchasing, inventory...)
then user reported the brought forward figure 2020 and 2019 year end was changed, after checking, it was caused by inventory auto cost adjustment (doctype 101).
so, we just wonder will inventory auto cost adjustment transaction post to GL even the fiscal period is closed?
of course, user 'swear' they did not open the affected closed period ...
Hello-
Thank you for posting your question on the Forums. Did the entry post to a closed year or a closed period in the current open fiscal year? If it posted to a closed year, this should be controlled by the Allow Posting to History option getting marked under: Microsoft Dynamics GP Under: Financial >> Setup >> Financial >> General Ledger(GL). The GL entry can still post to a closed period in the current open fiscal year for any submodule transaction. Was the Financial Series closed for the period in the Fiscal Period setup window as well?
If you have your posting settings to "Post Through GL" for Purchasing Invoice entries, then this is likely working as designed in GP. Microsoft Dynamics GP is designed to create cost adjustments in the period where the receipt transaction was posted.
In order to post the cost adjustments to the same date as the invoice, the only workaround is to pull up the Journal Entry and edit the transaction date to the same date as the invoice. You need to make sure you are only set up to Post To in the Posting Setup for the Purchasing Invoice Entry so that the batch is not automatically posted; and you can pull it up and edit the date.
I hope this information is helpful. Have a great day!
Adam G.
Microsoft Dynamics GP
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,387
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
