Sorry I am not sure is it the right forumn to ask , but I am having an issue on Simply Accounting Pro 2010.
I finsih all the invoice posting and reconciliations for 2023, I am able to run the reports but it just not allow me to start the new year 2024.
When I check the error log after I ran the Advanced Database Check. Seems there are Historical data issue. I am able to use the dbeaver to link with the database , but without the table schema, there is no way for me to fix it ?
Not sure does any one encounter the similar issue before and able to give me some hints ?
Thanks in advance.
Caleb
********** BEGIN: Verifying Historical data integrity **********
# HISTORICAL DATA PROBLEM: The historical table entries in the datadict table are not sequential - tGMscH
# HISTORICAL DATA PROBLEM: The historical table entries in the datadict table are not sequential - tJEAH
# HISTORICAL DATA PROBLEM: The historical table entries in the datadict table are not sequential - tJEH
# HISTORICAL DATA PROBLEM: The historical table entries in the datadict table are not sequential - tJEPH
# HISTORICAL DATA PROBLEM: The historical table entries in the datadict table are not sequential - tJEPHH
# HISTORICAL DATA PROBLEM: The historical table entries in the datadict table are not sequential - tJETH
# HISTORICAL DATA PROBLEM: This historical table exists in the database, but is not in the datadict table - tjeh01
# HISTORICAL DATA PROBLEM: The number of tables in the datadict for financial history is not in sync with tCompOth.nActHistSt or not in sync with the number of entries in tActHDat
# HISTORICAL DATA PROBLEM: The number of entries in the simplygrouppriv table do not match tCompOth.nActHistSt or there are entries for that table that exceed tCompOth.nActHistSt - tGMscH
# HISTORICAL DATA PROBLEM: The number of entries in the simplygrouppriv table do not match tCompOth.nActHistSt or there are entries for that table that exceed tCompOth.nActHistSt - tJEAH
# HISTORICAL DATA PROBLEM: The number of entries in the simplygrouppriv table do not match tCompOth.nActHistSt or there are entries for that table that exceed tCompOth.nActHistSt - tJEH
# HISTORICAL DATA PROBLEM: The number of entries in the simplygrouppriv table do not match tCompOth.nActHistSt or there are entries for that table that exceed tCompOth.nActHistSt - tJEPH
# HISTORICAL DATA PROBLEM: The number of entries in the simplygrouppriv table do not match tCompOth.nActHistSt or there are entries for that table that exceed tCompOth.nActHistSt - tJEPHH
# HISTORICAL DATA PROBLEM: The number of entries in the simplygrouppriv table do not match tCompOth.nActHistSt or there are entries for that table that exceed tCompOth.nActHistSt - tJETH
# HISTORICAL DATA PROBLEM: The number of historical sets do not match tCompOth.nActHistSt - tActHInf
# HISTORICAL DATA PROBLEM: The number of historical sets do not match tCompOth.nActHistSt - tActHRel
# HISTORICAL DATA PROBLEM: The number of historical sets do not match tCompOth.nActHistSt - tActHRng
# HISTORICAL DATA PROBLEM: Journal entries in this historical table are outside the fiscal start or end date - tJEH02
# HISTORICAL DATA PROBLEM: Journal entries in this historical table are outside the fiscal start or end date - tJEH03
# HISTORICAL DATA PROBLEM: Journal entries in this historical table are outside the fiscal start or end date - tJEH04
********** END: Verifying Historical data integrity **********