Tips and Tricks

Tip: Do not purge the General Ledger Posting Journal. If the posted transaction file would become corrupted, FixIT Professional can recreate damaged or missing entries from the Posting Journal.

Tip: "Multiple Data Sets." Run FixIT Plus unattended on multiple applications at a time. FixIT Plus defaults to a "Specific Data Set" from the Start List. This option will allow selection of a specific Start List entry for verification and correction. Selecting "Multiple Data Sets" allows for selection of several specific Start List entries. No need to restart FixIT between applications. Simply select all of the applications using "Multiple Data Sets."

Tip: DOS products will interface with Sage Accpac ERP General Ledger. DOS Property Manager will create a Property Manager General Ledger Batch file which can be retrieved into Windows. A client can upgrade General Ledger to Windows and leave the other applications in ACCPAC Plus.

Trick: When trying to connect to our web site www.musick-int.com and the error message This Page Can Not Be Displayed try this number instead 207.92.197.21. Then please send us an email sales@musick-int.com or call us @ 800-760-6836 to let us know if this has solved the problem.

FixIT Plus Tip: When the GL is out of balance (debits do not equal credits), FixIT Plus may create a "FixIT FixIT" Account/Department to correct the out of balance.

2. Change the GL repair settings in FixIT Housekeeping/Profile and rerun FixIT. The default FixIT settings are for most frequent types of GL data corruption

Change these setting to "update to accounts" and "update current balance". Whichever combination of settings does not create the "FixIT FixIT" Account/Department is probably the most correct data repair.

Problem: FixIT Plus appears to correct data corruption, but the corruption remains.

Solution: Restart the network server or copy the data to a work station and run FixIT on the local data.

Cause: Installation of the US Payroll Tax Update for January 2002 over wrote. Reinstalling Direct Deposit will not correct.

Solution: Delete all the files that begin with prdd from the prasp directory and reinstall Direct Deposit.

1.) Load Windows Explorer and open the prasp directory on the drive ACCPAC is installed.

2.) Scroll through the files on the right side of the screen and delete the Prddinit.ld4, and Prddzrsc.ld4 files.

Tip: FixIT Professional includes a script that allows you to rebuild individual files. Simply click the DBR Tools button and select your company using the drop down. From the Scripts tab select the Rebuild script and click run. The Export/Import Table window displays. Select the Application and Table you want to rebuild, then click the Rebuild button.

Tip: FixIT Professional includes a script that allows you to change the status of any AP, AR, or GL batch.

Trick: Simply click the DBR Tools button and select your company using the drop down. From the Scripts tab select the Batch Status script and click run. The Reset Batch Status window displays allowing you to select the Application, Batch Type and Batch Number to reset.

Tip: Always run Verify, in Accpac's Database Setup, before starting a repair on a data set. This will inform you of problems with your DDF's and Datadict files that could shed light on the original data problems and help you determine the best course of action.

Trick: In most cases System Check within FixIT Professional will correct Verify errors and should be your first step in resolving these issues.

Trick: The options in the Settings button allow you to configure the way FixIT repairs the data. Check the FixIT Control Center Settings section in the Help button to learn more about what the settings are and how they work.

FixIT Control Center

AP Data Integrity Check

PROBLEM: No Restart records found.

CAUSE: Sage Accpac Accounts Payable Data Integrity Check error. Error occurs as soon as DIC starts.

SOLUTION: Change the Data Integrity Check options to "No Fix". Having this option set to "Fix" will generate this error.

FixIT Control Center

OE Invoice Already Exists

Problem: Post invoice in OE produces this error: "Invoice Already Exists".

Cause: IC Option Table "ICOPT.DAT" has wrong Trans Number field value.

Solution: Modify the ICOPT.DAT table and the TRANSNUM Field. Increment the value to a number greater than the DAYENDNUM (also index 3) field in OEINVH.DAT. The easiest way to determine the greatest value is to change to index 3 and go to the end of the table.

Cause: File type selected during import was CSV File, which expects two separate files. One for header and one for detail. Payroll Import for Windows creates a Single CSV File with header and detail in one file.