Skip to main content
Post a question

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Change posting date on subledger transaction

Like (1) ShareShare
ReportReport
Posted on 6 Aug 2024 10:47:06 by 13
Hi all,
 
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?
  • AndrĂ© Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,791 Super User 2024 Season 2 on 08 Aug 2024 at 21:55:23
    Change posting date on subledger transaction
    Hi,
     
    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.
  • Robert Reid Profile Picture
    Robert Reid 13 on 08 Aug 2024 at 08:06:04
    Change posting date on subledger transaction
    Apologies for the confusion. The subledger transactions have not posted and are stuck in subledger journal entries not yet transferred
  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 22,295 Most Valuable Professional on 07 Aug 2024 at 10:59:25
    Change posting date on subledger transaction
    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.
     
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,226 Super User 2024 Season 2 on 06 Aug 2024 at 17:51:48
    Change posting date on subledger transaction
    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.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,488 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans