Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Change posting date on...
Finance forum
Unanswered

Change posting date on subledger transaction

Posted on by 11
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... 290,115 Super User 2024 Season 2 on at
    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 11 on at
    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 20,669 Super User 2024 Season 2 on at
    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... 3,807 Super User 2024 Season 2 on at
    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.

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,115 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,971 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans