Reversing the Bank Reconciliation in Sage X3

Reversing the Bank Reconciliation in Sage X3

Reversing the Bank Reconciliation in Sage X3

Reversing the Bank Reconciliation in Sage X3

You were reconciling your bank account when the keyboard malfunctioned and cleared the transactions, closing the bank reconciliation.
Unfortunately, the correct transactions were not cleared out, resulting in a variance that needs to be addressed. The option to reopen the transactions is currently unavailable. We need to find a way to reverse this situation and correct the errors. Let’s explore our options and come up with a solution.
Reversing the Bank Reconciliation in Sage X3 Image 1

It can be tempting to use the DEPOINTAGE function for Reconciliation Reversal. However, it’s important to note that this function only works with the RAPBAN (Bank Statement Reconciliation) and POINTAGE (Reconciliation) functions for bank statement reconciliation. If you accidentally use DEPOINTAGE with BANREC, the Mark will be removed from the transaction lines. If you attempt to clear the transaction in the future, you will receive an error message stating that the transaction already exists. This error will reference the Key, which is the ID number for the line, and the Table BANKRECD.

Reversing the Bank Reconciliation in Sage X3 Image 2
If you did use DEPOINTAGE, you may have to contact your Sage-certified business for assistance in correcting this situation.
To correct a BANREC, manual reversal is required. To initiate the correction process, you will need to reopen the statement. If the Reopen option is greyed out, you can proceed to the Setup section, navigate to Users, and select the Users (GESAUS) option. From there, locate the User code for the person authorized to reopen the BANREC statements. Under the Parameters tab, select Chapter TRS/Group AUZ, and change the Value for Parameter REOPENREC to “Yes.” Click OK and Save. After making the necessary changes, log out of X3 before returning to the Bank Reconciliation.
You may want to return the parameter to “No” for internal control. Reopening previous statements can affect subsequent statements and alter balances and cleared items.
Reversing the Bank Reconciliation in Sage X3 Image 3
The Reopen option in the right box will now be available.
Reversing the Bank Reconciliation in Sage X3 Image 4
Click Reopen to change the Status to “Open.” Now, proceed to the Details grid to continue reconciliation.
Reversing the Bank Reconciliation in Sage X3 Image 5

Removing the Mark from each line can seem daunting, but there’s an easier way. Click on the Action icon (three vertical dots) located to the left of the Mark column. This will reveal a drop-down menu with “Yes to all the rest” or “No to all the rest.” These options allow you to clear multiple transactions simultaneously, depending on where you start. So, there is no need to worry about removing the Mark from each line anymore.

Reversing the Bank Reconciliation in Sage X3 Image 6
With this information, you can finish your bank reconciliation.

About Us:

Greytrix Middle East Subsidiary of Greytrix India Pvt Ltd, Headquartered in Mumbai. It is a leading Sage business partner and ISV Partner offering Consulting, Implementation, and development services for Sage X3, Sage 300 People (HRMS), and Sage Intacct, which covers Dubai, Saudi Arabia, and Qatar region.

Our methodology involves a techno-functional expert team to analyze the client’s business processes, workflow, current system situation, and plans. Then, based on the analysis, we propose solutions that meet their requirement regarding the product consideration. In addition, we ensure to serve our clients with robust, future-proof, business-critical solutions that deliver best practices, processes, and functionality designed specifically for the business and its people.

We offer professional services such as Implementation and Configuration, Business Process Analysis, Project Management, Integrations and Migrations, and Technical & Functional Support, along with enhancements within Sage X3, Sage 300 People (HRMS), and Sage Intacct across various industry verticals like Process Manufacturing (Food & Beverages, Chemical), Discrete manufacturing (Automotive, Textile & Apparel), Non-Profit, Health-care Industry and Services Industry (Financial, Software & Engineering), Distribution (Transportation & Logistics).

Our Partnerships

Our Partners

Get In Touch

Why us

Thank you for contacting us.

Be ready to explore some leading business management solutions that will help shape the future of your business!

Our team will get in touch with you shortly.