Sage Accpac Accounting Software Vancouver Blog – Unisoft

Sage Accpac ERP, Microsoft Networking and Accpac Data Repair

Errors in the Sage Accpac Data Integrity Check Tool

I wrote an article a while back about how to use the Sage Accpac data integrity check tool but did not include anything about how to analyze the reports generated from the data integrity check. As a consultant I have been asked many times from very worried customers why their data integrity check report is showing errors. In data integrity checks reports their are two different types of errors:

  • Type 1 errors are data errors and need to be dealt with immediately as the represent damage or corrupted data. An example would be an corrupted data file that can’t be accessed by your data engine.
  • Type 2 errors are accounting errors and can be quite normal but you should pay attention to these types of errors. An example of a type 2 error would be missing item number or order number.

It should be quite obvious to tell the difference between the two.  Again type 1 are almost alyways serious and should be dealt with immediately while type 2 can be serious but most times can be left alone or attended to at a later date. At Unisoft, we find it good practice to run the data integrity check once a month and try to fix any errors on an ongoing basis. 

Bookmark Us:
  • Twitter
  • LinkedIn
  • Facebook
  • Digg
  • del.icio.us
  • Technorati
  • Google Bookmarks

2 Responses to “Errors in the Sage Accpac Data Integrity Check Tool”

  1. Suzy Lee Says:

    Yes, I have a lot of error message in inventory control like:
    Transfer Detail: 5761, 1000
    E: Invalid input. From location is not active.
    E: Invalid input. To location is not active.
    Transfer Detail: 5825, 1000
    E: Invalid input. From location is not active.
    E: Invalid input. To location is not active.

    I also have a lot of error message in PO like:
    Invalid input. RCP0005354 fiscal period 10 for fiscal year 2010 is locked.
    acrually, all uncompleted receipts have this error message. How could I fix it?

    Thanks

    Suzy

  2. Scott Smith Says:

    Hi Suzy,

    We will contact you by email to discuss. Thanks!

Leave a Reply