The Microsoft Query Wizard is an easier way to quickly create a Microsoft Query right from Excel. The basic steps to setup a Microsoft Query using the Query Wizard are below, these may vary slightly depending on your version of Microsoft…
The Microsoft Query Wizard is an easier way to quickly create a Microsoft Query right from Excel. The basic steps to setup a Microsoft Query using the Query Wizard are below, these may vary slightly depending on your version of Microsoft…
This message appears when you don’t have a data source with the name of “Acctivate” in Acctivate database maintenance. Acctivate allows for multiple data sources to be configured in database maintenance (or the acct.ini) but at least one of these…
Users may upload and attach files to a record in Acctivate, using notes. Users may create notes and upload attachments on the following windows. Activity Customer Account Customer Credit Customer Location Sales Order Sales Invoice Purchase Order Purchase Invoice Product…
TLS 1.0 is a protocol used to provide privacy and data integrity between two communicating computer applications. The following “Unable to login to database server” message could occur if TLS 1.0 is disabled. In order to check to see if…
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…
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…
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…
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…
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…