Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Unable to reverse Fixed assets journal (Open balances)

(2) ShareShare
ReportReport
Posted on by 87
Hello Pioneers,
 
I need to reverse posted Fixed asset journals, means Open balances. Here, the issue is we have a large amount of lines in each journal posted in 30-Aug-2024.
 
I am trying to reverse the FA journal by going FA>Journal entries > FA journal > "Reverse entire journal" then immediately there is warning message says "A batch process will be used due to the number of lines being reversed" then I have initiated reversal using batch processing but system failed to reverse journals & throws an error as below.
 
Voucher FAJCA000002 in journal JBN000001945 could not be reversed (attached screen shot).
 
Kindly advise me on this, If I am missing any configuration prior to this.
 
 
Regards,
Durgarao.
Categories:
  • Durga Rao P Profile Picture
    87 on at
    Unable to reverse Fixed assets journal (Open balances)
    Hi Bharath & Frank,
     
    Thank you so much for your valuable inputs, let me test in lower environment and come back with results.
     
     
     
     
    Regards,
    Durgarao.
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,510 Super User 2025 Season 1 on at
    Unable to reverse Fixed assets journal (Open balances)
    Theoretically, yes, Durga, that should work.  I would test it on one asset before proceeding with all of them.  And apply Bharath's suggestion as well.
  • Verified answer
    Bharath jain Profile Picture
    1,069 Super User 2025 Season 1 on at
    Unable to reverse Fixed assets journal (Open balances)
    Hi Durga,
     
    Since the volume is large, use acquisition adjustment and depreciation adjustment journal. Acquisition will be on debit and acquisition adjustment will be on credit in this way you can net off. 
     
    Regards,
    Bharath Jain
  • Durga Rao P Profile Picture
    87 on at
    Unable to reverse Fixed assets journal (Open balances)
    Dear Frank Hamelly,
     
    Thank you so much for your valuable response!!
     
    If I understood correctly, FA journal reversal can't be done in bulk using batch, as it must be done one at a time for each Asset in FA book manually is it?
     
    If Yes - could you pls confirm me   what If I create and post new FA journal with negative balances, like If it is Acquisition journal then I put negative value in Debit field or positive value in Credit field.. similarly for Depreciation journal I put negative value in Credit side or positive value in Debit side.. will it work or not.
     
    Kindly confirm me If this approach works for my issue since I must deal with large number of lines (above 5k lines)
     
     
    Appreciate your valuable response.
     
    Regards,
    Durgarao. 
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,510 Super User 2025 Season 1 on at
    Unable to reverse Fixed assets journal (Open balances)
    You have to reverse Fixed asset transactions within the Fixed asset book.  It can't be done using standard Journal reversal process.
     
    Unfortunately, there's no way to reverse FA book transactions in bulk.  They must be done one at a time, per each FA.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,459 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,066 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans