@IniNaadiJ 

Sorry -- it is a little difficult to understand issue based on information supplied. 

You mention preliminary year end -- so is 4/1/2022 1st period of the new year?   If so -- have you run the clear cost revenue? 

You mention:  Auditors found few vouchers which tallies to the difference amount --- assume these vouchers are posted to GL -- so not sure if they are really finding the difference.  

Have you run a query on GL voucher Rows for April to confirm net change equals balance analysis? 

You may need to log this as a support case so they can connect to the customer and review

Hi Nancy,

Thanks for your reply. Yes, I did all the testing as mentioned above and yes TB balance difference is derived from the system not from any other source. 

Yes we run the GL balance and voucher analysis and did the investigation too.

Even preliminary year end process runs smoothly but there is no error message appears but voucher is not generating.

Any other way we can check to eliminate this TB difference. From march 31st to 1st April 2022 closing and opening balances not tallying. 

Regards

Naadira

Hello, 
If April 1st, 2022 is first day of your accounting year 2022 and final year end was not done yet, you can do analysis per account number in Balance analysis window:

1. Do balance analysis by account only - for entire year 2021 - export to Excel. Check if total balance is zero
2. Do balance analysis by account only - for period 0 year 2022 - export to Excel. Total balance is not zero, as per your message

Now in Excel you can compare balances. Most probably you will find account with balance in 2021 missing in period 0 of 2022 - of account type Cost, Revenue or Statistic. 

If problem is in cost or Revenue account - redo of Clearing Revenue/Cost Balances procedure followed by preliminary year end process will do the job.

In case of Statistic account, you should reclassify the balance with manual voucher to Assets or Liabilities.

Dear Adam,

Thanks for the reply. Appreciate alot.

We did  this working and found out  2 bank Ac amounts not tallying. There is a difference between the Cash account balance analysis and GL balance analysis. So we investigated following things

• The vouchers in different payment date and voucher dates
• The doubtful vouchers correctly posted to the ledger.(Dr and Cr)
• Back end query executed for manual vouchers- It wont affect the difference
• No transactions in  hold table 
• Executed the preliminary year end and unable to complete it.
• Back end query executed for difference in the voucher date and payment date for the cash account balance report and the GL balance report.- No transactions could find which has gone to wrong GL account.
• Checked the summation of the GL balance analysis -Considered all the transaction types.

Any other thing you would suggest?

Hello, Nadira,
I am sorry, but from your explanation I am not sure now where the problem is.

Is it discrepancy between Subledger (cash book) and General Ledger only or in GL between Closing Balance of March and Opening balance of April?

In case of the first one - Cash book balance should match cash book transactions, and cash transactions (PP1 postings) should match GL - on cash account no other postings than PP1 are expected.  

If you know SQL - I have prepared queries once comparing cash book balance and cash book transactions, but in my IFS version 7.5 we have Indian local Pack installed, so tax deductions are considered in the query. 

Perhaps you will find them usable.

Dear Bereda,

Thank you for your reply. 

Yes there is a difference in TB ( Closing balance not tallying with opening balance) And  we found the reasons as cash book balance and GL balance difference. Executed the above mentioned SQL  quires as well. 

Still couldn't rectify and tally the TB and run the year end that is the main concern. This is IFS app 8.

Is there any bug which prevents from doing the preliminary year end and not generating and error message. 

Regards

Naadira

Can you share your problem details in e.g. a Word document attached? Showing the difference?  Preliminary Year end transfers only balances of Assets and liabilities, and does not report any error if they are not balancing - this is normal. 
 

Dear Bereda,

Attached herewith the workings document. Please advise.

Thanks for the support.

Hi,
If I understood your document correctly, your cash book matches GL voucher rows (transactions) but you have discrepancy inside GL - between accounting balances and voucher rows - some voucher rows (doubtful vouchers probably) are updated in GL on opposite side (debit entry updated credit balance nd vice versa). 
There’s nothing you can do with that by regular system functions - data repair would be necessary, changing data in accounting_balance_tab to match total of corresponding GL voucher rows.. 
It should be normally subject of support case.