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 thingsThe 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?
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. RegardsNaadira
Dear Bereda, We did a data repair & did some testing by changing the dates- Invoice and voucher dates ( All possible scenarios- future date/same date& back date etc) and executed the current voucher date process as you mentioned( Customer invoice with errors process).But now following error populates. Any suggestions?ORA-20105: Invoice.ACCERROR1: Error (Current Due Date cannot be less than Pay Term Base Date.) occurred while booking Invoice CD 202200054. Really appreciate your feedback and support. RegardsNaadira
Hi Brereda,Thanks for the explanation. Yes Invoice is in printed status and error appears and auto voucher can not be created. How do we set the dates if we are to rectify this through data repair?
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.