Sage Accpac Accounting Software Vancouver Blog – Unisoft

For personal use there are many solutions; I like www.dropbox.com.

Sage Accpac Data Backup Best Practices

Does your company backup its’ data on a daily basis?

Depending on the volume of data and the number of people working in the system you may want to backup on a daily basis. Some of our clients have even backup their  servers in real-time.

Is your data backup at offsite?

This is simple – don’t put all your eggs in one basket.  It is very important that a backup of your data be taken offsite. 

Test your restores at least once a year, Test your Data’s Integirty as often as possible!  

Always test your backups; often people setup their own backup and never actually test it. Make sure that restoring your data actually works!  Data integrity checks should also be done every time you backup, ideally on a weekley if not daily basis.  For more information on how to check your data’s integrity look here: Data Integrity Check in Sage Accpac ERP

Do it right the first Time, because you may not get a second chance…

Have a application specialist setup the backup for you. Even if you have a vanilla installation of your software there maybe integrations or customizations that you don’t know about. A trained IT speciallist will help to ensure all of your data is backup appropiratley.

Automated Offsite Daily, Weekley or Monthly Backups

Unisoft offers affordable automated offsite Daily, Weekly or Monthly backups with data integrity checks as well as other disaster recovery services. For more information please contact Scott@Unisoft.net or call 604-926-3398.

As the CoFK approaches 0, productivity goes negative as you pull OTHER people into chair-spinning contests.

Permanent link to this comic: http://xkcd.com/815/

Form xkcd.com, a webcomic of romance, sarcasm, math and language.

As of December 2010, we are pleased to announce that Sage ERP Accpac Version 5.6, Version 6.0 (upon general release) and Sage Accpac Intelligence will be compatible with 32-bit version of Microsoft Office 2010 (e.g. Excel 2010 and VBA Macros).

When Sage ERP Accpac Insight Version 6.0 is released with Sage ERP Accpac 6.0, it will also be compatible with 32-bit Microsoft Office 2010.  This version of the Insight module will be backward compatible with Sage ERP Accpac Versions 5.5 and 5.6.

Please refer to the following Knowledge Base article for more information: 31071

This is probably the most commor error that occurs in Sage Accpac ERP, “Control not properly installed” and occurs because you do not have sufficient rights on the workstation.

Solution:

1. Add the User to the Local “Power User” group for the computer
2. OR, Give specific permissions (Read and Write to the HKEY_LOCAL_MACHINE\SOFTWARE key, AND Grant Full Access to the program files folder usually C:\Program Files\Sage Software\Sage Accpac\)

Just a small bit of information that might help you out, it can be a difficult error to resolve unless you know the cause.

Using Excel to retrieve sales information from Sage Accpac is quite simple and powerful.  In both the Order Entry and Inventory Control Modules there is a table that includes sales statistics. ICSTATI is the name of the table that includes the sales details for the inventory module. Essentially this is is a table that includes records per accounting period for the quantity sold, sales amount, return amounts and cost of goods sold.  By importing this table into Excel you can easily create a pivot table/report that shows your net sales (sales – returns) for a range of periods and/or years as shown below.

Sales by Period for 2009/2010

Preparing such reports can be accomplished with the help of our consultants, 604-926-3398.

New Sage Accpac ERP and CRM webcasts were released on unisoft’s website. Unisoft will be adding more webcasts on an ongoing basis so make sure to check back often.  There will be webcasts focusing severa categories.  Current Sage Accpac ERP and CRM users will be provided with webcasts on tips and tricks on how to use more of their business software and accounting system. There will also be a section for users on the new features in each version to keep you up to date on the lastest product developments. Finally, there will be a general business level section for managers and desicion makers to see how ERP and CRM software systems can help advance their business.

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.