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 :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Reset to Zero Function
Small and medium business | Business Central, N...
Suggested Answer

Reset to Zero Function

(0) ShareShare
ReportReport
Posted on by Community Member

Hello Experts,

I am trying to import my GL Accounts opening balances into Business Central using Table 81, Gen.Journal Line. My question is that, once I have imported the data and if there is anything wrong in system after import, can I do any reset back to zero for GL Accounts?  Is there any out of the box functionality for rest to zero for GL Accounts? 

Thanks in advance for your valuable input.

Best Regards,

Ranjith 

  • Suggested answer
    JAngle Profile Picture
    JAngle 159 on at

    The g/l accounts are only impacted once the journal is posted. If you post and there is a mistake then you can reverse the journal from the g/l registers page

  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at

    There is no such function in the standard system.

    But it is a good advice to take a backup before you post the opening balance. And then you can restore the backup if you post something incorrectly.

    Could be either a database backup or you can copy the company before you star posting.

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 235 User Group Leader on at

    A simple solution is to copy your company before you post. If something goes wrong you can delete and create a new company from the copy.

  • Suggested answer
    Amit Profile Picture
    Amit 2,563 on at

    Hi,

    If you done wrong entry, Just Open the posted entry Use Reversal button for reverse the entry.

    Regards

    Amit Sharma

    www.erpconsultors.com

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 235 User Group Leader on at

    Amit has a option but I know if it's me, I don't want to see those entries and their reversals forever. I would rather have a good clean start.

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,306 Super User 2026 Season 1 on at

    Best practice is to copy the Company first before you insert any opening balances.

    When you have issue, you can copy it back from Copy Company.

    If everything is ok, you can remove the Copy Company.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 103,294 Super User 2026 Season 2 on at

    Hi, As mentioned by several experts above, there is no such zeroing feature in BC.

    You can re-import the reverse amount and post it so the total amount becomes 0. But this leaves historical data in BC.

    It is recommended that you test it in the Sandbox environment before importing it into the Production environment.

    Hope this helps.
    Thanks.

    ZHU

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 796 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 481 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 377 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans