I've recently joined a new company that had a discrepancy from 2022 on their supplier to ledger reconciliation report. After much investigation I found that the two transactions had Invoice matched to purchase orders and posted, however the subledger transactions never followed. They are sat in the 'subledger journal entries not yet posted' form. On our test system, I opened the period in question from 2022 and manually transferred the transactions. This resolved the reconciliation problem.
I've suggested this is the resolution to the user, however they are very reluctant to open the period from 2022, as obviously these years have now passed and we shouldn't be posting any further transactions. Is there any way to influence the posting date of the subledger journal transactions to post in the current period?
TL;DR - Customer posted purchase invoice in 2022. Subledger transactions have been stuck there ever since. Can we change the subledger transactions to post in current period?
There is no functional support to change the posting date if the pending entries are not yet transferred as the source document itself is already in a posted state with the original posted date. I wonder how the year has been closed where not all transactions were transferred.
I think the safe way is to post is to open the periods.
Because if you even try to keep those by using manual entry, who knows if MS bring a feature which will allow system to post in next open period if the period is on hold for previous years/months.
The subledger transactions are already posted, right? You can't edit a posted transaction's posting date. However, the users could create a reversing journal transaction, posted on the 2022 posting date and reversing in the current period, to allow posting in 2022 with no GL impact.
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.