• PMCONTS Table vs ARIBD Table

    I’m exploring the Acc-Pac DB tables and I noticed in the PM… (or Project and Job Costing) table the CONTRACT value is always stored without a decimal. e.g. 10042, 51891, 31311 . Within the AR… (or Account Receivable) tables the CONTRACT value is stored…
  • GLJED CompanyID field with incorrect company ID

    We have noticed that the CompanyID field in the GLJED table does not tie up with the actual company AUDTORG field. The bulk of the record have the correct company ID, however many have either blanks or random company ID's I have checked this at several…
  • SQL Database corruption

    While trying to restore a SQL server backup for one of our Sage databases, the process returned a restore error. Upon research i found out that the DB may have been corrupted. What can be done to recover from this? Priti