Finance | Project Operations, Human Resources, ...

Change posting date on subledger transaction

(1) Share

Report

Posted on by Robert Reid

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?

All responses (4)

Answers (0)

Sort by

Suggested answer

Frank Hamelly | MVP... 46,633 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.
Suggested answer

Ramit Paul 22,809 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.
Robert Reid 42 on at

Like (0)

Report
Copy link

Link copied!

Apologies for the confusion. The subledger transactions have not posted and are stuck in subledger journal entries not yet transferred
André Arnaud de Cal... 307,704 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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.