web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

how to reverse a prepayment schedule in general ledger

(0) ShareShare
ReportReport
Posted on by 67

we use ledger accruals for setting up prepayment schedules in the GL module.  For example, a 12 mth prepayment schedule to release cost over a year.  We are updating our chart of accounts and using new cost centres and we need to reverse the some future dated transactions.  

pastedimage1592931659937v1.png

When trying to do this, we are told we cannot reverse for the account.  However when we post a single journal line to this account and then reverse, we can do so fine so I do not think the message below is do with the GL account but an issue with it being related to a ledger accrual.  

pastedimage1592932055391v2.png

Can someone advise? many thanks

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi,

    Can't you simply post a correction of the transaction with the old cost center?

    Something like:

    DR: account & new cost center

    CR: account & old cost center

    If many transactions are affected you can possibly upload the corrections via Excel or alternatively use ledger allocation rules to achieve this corrective posting between the old and new cost centers.

    Best regards,

    Ludwig

  • jerhsysacct Profile Picture
    67 on at

    Hi Ludwig

    Thanks for the reply.  Yes we could do either of those.  Is the cause of not being able to reverse each transaction related to the journals being posted from the ledger accruals functionality or something else?  There are a number of transactions and I think it might be quicker to reverse them and then set new ledger accrual postings on the new cost centres.

    Thanks

    Joe

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Joe,

    I think the problem is the complexity of the ledger accrual function and that one single journal line creates multiple 'derived' lines - in future periods - that are created and posted at the time the journal is posted originally.

    The reversal feature does not work everywhere and if it does not work for you there might be no other option available than making use of one of the workarounds.

    Best regards,

    Ludwig

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 689

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 606 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 356

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans