Occasionally, you may want to remove a warehouse on a product. This does not remove any historical transactions, or delete the warehouse from the database. Removing the warehouse from a product hides the warehouse only for the product you are…
Articles
Product Class: Product Class is ambiguous
As your business grows and you have the need for more and more product classes, the list can grow to a point that you may have accidentally created a duplicate Product Class. The database must have a unique identifier to…
Deleting Customers from Acctivate
You have old, inactive or duplicate customer records, now you want to delete them. Acctivate does not allow users to delete customers once a record has been created. While it may sound like a simple click of the mouse or…
Migrating data from one Acctivate company file to another company file
For some users with multiple Acctivate Companies, there may come a time when you would like to migrate the data in one of the companies into the other. This can be due to a merger or a variety of other…
Stop Excel from Changing Numbers to Dates or Scientific Notations
We all know that Excel can be a powerful tool, however in an effort to anticipate the need of a user, Excel can also make it difficult to create spreadsheets for importing data into Acctivate. You may have entered a…
Posted in Database, Import Data
Acctivate Database Backup Prompt
In newer versions of Acctivate, there is a prompt upon exiting the application to create a backup if a SQL backup has not been run in the last 7 days. This prompt will show for all users until the backup…
Posted in Database, Technology
Restore Acctivate Database in SQL Server Management Studio
If you are unable to restore your database file in AcctivateDBMaint or you are wanting to restore it to a different location than where Acctivate is installed then you may want to use SQL Server Management Studio to restore it.…
Posted in Database
“Cannot Open Databases for Company…” on CYMA workstation
Cannot open databases for company _________. This error comes from the configuration of PSQL in the Acctivate sources. First you need to know if you are using a PSQL Server license or a PSQL Workgroup license to run CYMA with.…
Posted in Database
Can’t Find Voided Transactions?
Unlike voided invoices or canceled orders, voided transfers, receipts, or other transactions voided through the Void Inventory Session tool are not able to be recalled and viewed again after being voided. This can understandably be confusing for users at times.…
