This article provides three possible solutions to resolve issues with unbalanced batches, incorrect period entries, or bad records in Access UBS. Follow the three solutions to troubleshoot and fix the issue effectively:
Solution 1: Run File Organization to remove null values.
Solution 2: Trace and correct unbalanced or wrongly keyed-in batch transactions.
Solution 3: Check and fix bad records from the database.
Solution 1: Run File Organization to remove null values.
Go to Housekeeping, File Organization.
Untick the 'Remove Null Value'
Click OK
Solution 2: Trace and correct unbalanced or wrongly keyed-in batch transactions.
Go to Transactions, Scan Batches to trace the balance status NO in the columns of BATCH BAL and PD BAL.
Go to Transactions, Print Batch Summary to check the balance of opening balance.
Go to Transactions, Print Batch of Transactions, select the related batch, and make the edition accordingly.
Example:
In the above scenario, please edit PD = Period in the transaction that was wrongly keyed in as 9 when the correct period was 8 for November transactions.
Solution 3: Check and fix bad records from the database.
Go to housekeeping, check the records in the file, and look for bad records.
Click check, click list to see the list of bad records.