You may want to split the company data at the end of the current financial year or at the beginning of the next financial year, when the data size becomes huge. While splitting the data based on financial years, the feature Verify Company Data automatically detects possible errors in the data. You can manually correct them and then split the data.
Verify Company Data detects the following possible errors:
● Voucher has bank allocation details in non-banking ledgers
● Non-banking ledger has bank reconciliation details
● Voucher has duplicate bank allocation details
● Incorrect ledger was selected in Bank allocation
● Incorrect Units of measurements for an Item
● Cost Centre does not belong to the Category
● Cost Break-up total does not match
● Service tax (ST) category does not exist
Verify the data before splitting,
1. Go to Gateway of Tally > F3 : Cmp Info. > Split Company Data > Verify Company Data .
2. Select the required company. The List of Possible Errors screen appears, if there are any errors.
This will list the vouchers in which bank allocation exists in non-banking ledgers.
1. Select Voucher has bank allocation details in non-banking ledgers , and press Enter .
The Voucher has bank allocation details in non-banking ledgers screen appears as shown below:
2. Select the required ledger and press Enter .
3. Press Alt+A to auto correct the ledger.
4. Press Enter to proceed.
This will list the non-banking ledgers for which opening bank reconciliation details are carried forward from the previous financial year. To resolve this error:
1. Select Non-banking ledger has bank reconciliation details , and press Enter .
The Non-banking ledger has bank reconciliation details screen appears as shown below:
2. Select the required ledger and press Enter .
3. Press Alt+A to auto correct the ledger.
4. Press Enter to proceed.
This will list the vouchers updated with duplicate bank details. To resolve this error:
1. Select Voucher has duplicate bank allocation details , and press Enter .
The Voucher has duplicate bank allocation details screen appears as shown below:
2. Select the required ledger and press Enter .
3. Press Alt+A to auto correct the ledger.
4. Press Enter to proceed.
1. Select Units of Measure Incorrect for the Item , and press Enter .
The Unit of Measure Incorrect screen for an item appears as shown below:
2. Select the required Voucher and press Enter . The Accounting Voucher Alteration appears as shown below:
3. Select End of List in Name of Item .
4. Re-select the item shown earlier in Name of Item .
5. Enter the correct amount in the Amount column.
6. Accept the voucher to resolve this issue.
To resolve the error using the Helper
1. Select Cost Centre does not belong to the Category , and press Enter .
The Cost Category Mismatch vouchers appear as shown below:
2. Click L: Helper or press Ctrl + L . The Cost Category Mismatch Helper screen appears as shown below:
3. Click A : Auto Fill to automatically fill in the cost centres.
4. Accept to save.
To resolve the error without using the Helper
1. Select Cost Centre does not belong to the Category from the List of Possible Errors .
The Cost Category Mismatch screen appears as shown below:
2. Select the required voucher
3. S elect End of List i n the Sales Voucher.
4. Select the Cost Centre for the Category correctly.
5. Accept the voucher to resolve the issue.
To resolve the error
1. Select No Accounting Allocations , and press Enter.
The No Accounting Allocation screen appears as shown below:
2. Select the required Ledger.
3. In the Ledger Alteration screen set Inventory Values are affected? to Yes .
4. Accept the changes made.
To resolve the error
1. Select Voucher Total Mismatch , and press Enter.
The Voucher Total Mismatch screen appears as shown below:
2. Select the required voucher.
3. In the Accounting Voucher Alteration screen re-accept the entries and save the voucher.
The error message incorrect ledger allocations was being displayed when splitting data of Release 4.8 to 4.92 in Release 4.93 onwards. The error message was displayed when:
● A payment/receipt/journal/contra voucher was duplicated and altered in Release 4.8 to 4.92.
● The above vouchers were duplicated with multiple ledgers.
1. Select Incorrect ledger(s) in bank allocation , and press Enter.
The Incorrect ledgers in bank allocation screen appears as shown below:
2. Drill down to the voucher and reaccept the voucher.
Or
Press Alt + A to auto correct the vouchers with single party.
3. Enable Auto correct . Voucher starts altering as shown below:
Once the alteration is complete, you can start splitting your company data.
This error occurs if cost centre allocation total does not match with the ledger amount total. To resolve the error:
1. Select Cost Break-up total does not match , and press Enter . The list of vouchers with mismatched cost category allocations appears as shown below:
2. Select the required voucher.
3. Enter the correct amount in the Amount column in Cost Allocations screen or Create a new Cost Centre and enter the difference amount in Amount column in the selected voucher alteration screen.
4. Accept the voucher to resolve the issue.
To resolve the error:
1. Select Service tax category does not exist , and press Enter . The list of masters appears as shown below:
2. Click A : Auto Correct .
The following message appears:
3. Press Enter to continue.