Simple Excel Query using Query Wizard

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

Posted in Database, Reports

“Length of NEW column color cannot be zero” error when creating new sales order

With the latest Windows 10 update (version 1809), it has been reported that opening existing sales orders or creating new orders in Acctivate leads to the following error:  “Length of NEW column color cannot be zero” It’s likely that the

Posted in Sales, Uncategorized

Partially Invoice a Sales Order

Acctivate allows users to choose which products to include on a sales invoice. Rather than invoicing the entire order at once, users can select to exclude products from the invoice by using the “Backordered Quantity” field.

Posted in Sales

Order Manager Inventory Allocation when Scheduling

In Acctivate, inventory will not be allocated to booked or back-ordered orders automatically.  Those orders need to have inventory scheduled manually, even if there is now a sufficient quantity in your warehouse(s).  Of course, it’s not always practical to manage

Posted in Uncategorized

Pending Amazon Orders and ChannelAdvisor

Acctivate integrates with the web store ChannelAdvisor, which can act as a web platform that consolidates orders and inventory quantities for other web shopping carts such as Amazon.  Acctivate will import in orders from ChannelAdvisor based on the ordered date

Tagged with:
Posted in Uncategorized

How to Batch Update Workflow Statuses

In this video, we walk through how to use the order manager to batch update workflow statuses on sales orders. For more information on the order manager, check out the overview here.

Posted in Uncategorized

How to void a receipt

In this video, we go over the steps for voiding an inventory transaction. As an example, we void an inventory receipt. For documented steps, see the full guide here.

Posted in Uncategorized

Create Additional Warehouses

Occasionally our customers have the need to create a new Acctivate warehouse in configuration manager.  This new warehouse may be a new physical warehouse location or a virtual warehouse location either way the setup process is exactly the same.  Additional

Posted in Configuration, Inventory

Voiding an Invoice

Check out the video below for step by step instructions on how to void an invoice: For more instructions, click here.

Posted in Uncategorized

Error from Crystal Reports: Too many items have been given to this array.

If attempting to print over 1,000 records (invoices, orders, pick tickets, etc.), you will receive the following message:   Error from Crystal Reports: Too many items have been given to this array. Acctivate passes the records to Crystal Reports in

Posted in Reports
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.