Troubleshoot

General

• How can I resolve Acctivate being blurry or text being small on certain monitors?
• Why will Acctivate will not maximize?
• Troubleshooting an "Either BOF or EOF is True..." error
• Why am I unable to scroll using the mouse wheel in Acctivate?
• What do I do if I am unable to start Acctivate?
• Resolving error “Component '…' or one of its dependencies not correctly registered: a file is missing or invalid.”
• How to resolve the "Cannot connect to server..." error when opening Acctivate.
• Resolving a "Side-by-Side" Error in Acctivate.
• Resolving “Unable to login to database server” on Workstations.
• Resolving "Acctivate is already running."
• Why do I get an "Out of Memory" error when opening multiple windows in Acctivate?
• Resolving run-time error "The network path was not found."
• What to do if I can't access my Acctivate user account?
• Resolving the "Acctivate Data Source Not Found" Error?
• Resolving the "Login failed for user 'sa'..." error.
• Why am I getting the error "The network name cannot be found"?
• Resolving the "Linked item is not in the database..." message when creating a new note.
• Resolving the "Unable to load database components" error on workstations.
• Resolving the "Connection to the server was lost" Error.
• What Do I Do if Workstations Are Not Able to Connect to the Database?
• What do I do If Help Is Not Displayed After Pressing F1 or Clicking the Help Menu?
• Why am I receiving "Could not connect to SQL" the first time I try and launch Acctivate?
• Unable to connect to Evaluation Environment.
• Resolving CYMA error "Could not find server '(server)' in sys.servers..."
• Resolving error “Class not registered. You need the following file to be installed on your machine.MSSTDFMT.DLL”
• Why Are Quick Filters Not Saving in Manager windows?
• Resolving the error "Execute with results failed for Database ‘Acctivate.'"
• “Cannot Open Databases for Company…” on CYMA workstation
• Resolving the "UFL 'u2lgl' that implements.." error?
• Why am I seeing strange symbols throughout the program or in emails?
• How to Enable or Disable the Icon Bar
• Why is Acctivate displaying in Foreign Characters?
• Resolving a 'Cannot find an unused ... Number' Error.
• Simplified Sales, Purchasing, and Packaging menus
• "View Product" button is missing
• User doesn't display in the Business Activity Time Employee list
• Removing a company name entry from the login window.
• Changing the height of the lookup window grids.

Installation

• Resolving "CYMAX.OCX" is not properly registered when opening the CYMA version of Acctivate.
• "Error connecting to Acctivate database: Provider cannot be found" during Mobile WMS installation
• Resolving "The previous installation has not completed yet" message when installing Acctivate.
• Resolving the "Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server ..." error
• Why Am I Getting The "Run-Time error – 2147024843 (80070035)" Error After Changing the Name of the Server?
• Resolving the Error "The user name or password is incorrect" when trying to login to a workstation
• Why can't I run the Acctivate installation file after downloading it?
• Resolving a "Permission denied" error when upgrading the database.
• Resolving the Microsoft Visual C++ Runtime Library error in Acctivate.
• Resolving installation error: "Please install a version of Microsoft SQL Server (2005 or later) that is supported on your operating system and run Acctivate setup again."
• "Unable to locate required IIS components" during Acctivate Mobile installation
• Error Code: 80091007 during install
• Resolving error code 80070005 when installing or updating Acctivate.
• Resolving error code 80070643 when installing or updating Acctivate.
• "Parser Returned Error 0x80004005" when trying to run Acctivate or update Acctivate
• Resolving "Run-time error '-2146232799 (80131621)': Could not create Acctivate business logic object: New ACCTivateApp.ComInterop Automation error when installing or updating Acctivate.
• Resolving 'Missing VIEW.DDF file' Message After Acctivate/ CYMA Migration
• Resolving error code 84BE0BC2 when installing Acctivate on a new server.
• Resolving error code 80070666 when installing or updating Acctivate.
• What do I do if I receive an installation error code that isn't documented in the knowledge base?
• Resolving error code 80070652 when installing or updating Acctivate
• Install error code 84BC06AA
• Resolving "Windows installer coordinator" hanging when trying to install or update Acctivate.
• Error Code 80072EE2 During Acctivate Installation
• Installation Error 80070002
• Installation Error Code: 00000646
• Anti-Virus realtime scanning causes performance issues
• Resolving error code 80070490 when installing Acctivate

Inventory

• Why am I unable to void an inventory session due to a closing date?
• Error 0x80131904: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
• Resolving "Posting a Landed Cost Transaction is not Allowed..."
• Fixing a posted Assembly with wrong quantity.
• Could not post Inventory Transaction: One or more locations are missing on the detail line.
• Why is my available quantity in the negative?
• Why does a product not show on an Inventory Count?
• Insufficient quantity on hand for component(s) error message
• There is not another Serial Number available to select.
• Receiving "A total of X rows cannot be loaded for reordering because: X are already pending for reorder." popup when using Create Reorders function
• Fixing an item that was received with the incorrect lot number.
• Find unposted transfers a product is linked to
• Find products with zero quantity on hand but having a remaining value
• Handling serial numbers with negative on hand quantity.
• "There are no products to be counted that match the selection" message trying to create an Inventory Count
• Why am I unable to mark a location as inactive?
• Why are products not included in the Export Product List utility?
• Changing Item Type for Product with Transactions.
• Handling a Product that has a Negative Quantity on Hand Prior to the Selected Transaction Date.
• Cannot change unit of measure because the product has inventory transactions.
• Why am I getting a message saying "Lot/Serial number "####" not found..."?
• Resolving Duplicate Products
• Troubleshooting Product Lookup Window Issues.
• Improving the Product Lookup performance.
• Where does my Alternate Product ID and Alternate Description come from during initial setup?

Purchasing

• Why am I getting a "Missing COGS account..." error when creating a PO Invoice?
• Why am I getting a warning that cost must be changed on receipt when invoicing a Purchase Order?
• Why are some items not showing on the Purchase Invoice window?
• Why do some PO Lines not appear on the Purchase Invoice?
• Why am I recieving “There were no posted transactions found…” when creating a Landed Cost session?
• Missing GL Expense Account on the Other Amounts tab when Invoicing a Purchase Order

Sales

• Class missing from Additional Info tab of Sales Order entry
• Why am I not able to pre-authorize/charge CC/E-Check payments?
• Why am I receiving "Invoice not released. Order has scheduled kits with components not stocked in the selected warehouse(s)?"
• Why is my Packing List blank?
• What do I do if I get the message "No Picklist Exists"?
• Why am I Getting Cost of Goods Sold Cannot be Calculated when Invoicing?
• The remote server returned an error: (400) Bad Request... when processing a credit card
• Why am I getting “Payment Amount must be zero if no payment type”
• What do I do if I get the "Order number is required" error when saving an order?
• Why am I experiencing skipped or missing Invoice numbers?
• How do I Resolve"Sales Class is not set up" when creating an Invoice?
• Why isn't back ordered quantity updated automatically on sales orders?
• Why is the Sales Order Locked?
• Resolving sales order error "Cannot determine Sales Class."
• Resolving "Invoice not released. Non-inventoried Cost Offset account not set." message when creating an invoice.
• Resolving “Invoice not released. Cannot determine Sales/COGS GL Account.” Error.
• Resolving “Could not get credit card authorization response” error when invoicing.
• Why is an order showing as on hold due to a customer over limit with no outstanding invoices or credits?
• Why does the payment tab on a sales order show "Payment not entered?"
• Resolving "Invoice not released. Shipping Cost Offset account not set" message when creating an invoice.
• Troubleshooting performance issues with Order Manager
• "View dropship/special order" button missing on sales order after updating to 12.2.
• Finding orders a lot or serial number is assigned to.
• A Contact ID is Required – Pop-Up in Edit Customer Window

Shipping

• Error returned from ShipStation: Invalid shipTo address, Acctivate Order Number: {OrderNumber}
• Error returned from ShipStation: Invalid carrierCode, Acctivate Order Number: {OrderNumber}
• "Unable to locate sales order lines for this shipment" when opening a shipment
• Why is my Endicia Post-Back Package not Coming into Acctivate?
• Resolving "Cannot Add Shipping Because Default Shipping Product is not a Charge."
• Why aren't my Tracking Numbers from Fedex or UPS appearing in Acctivate?
• What do I do if UPS Worldship isn't exporting data properly?
• Why isn't FedEx pulling order info in when I enter in the order number?
• Why am I unable to select a carrier in Package Manager?
• "Create Shipments'" is missing from the Packaging drop down menu
• Setting up Verbose logging for Shipstation.

QuickBooks Desktop

• Resolving "Not Responding" when I run a QuickBooks sync.
• Index of QuickBooks Sync Errors
• Resolving a QuickBooks Dividing Date Sync Error.
• Enabling verbose logging for the QuickBooks SDK.
• "New customer '...' already exists in QuickBooks and was merged. Please review this customer in Acctivate before the next sync."
• Resolving the Message "QuickBooks...is already running" while Syncing when QuickBooks is Open
• Resolving an "unexpected error" during a QuickBooks sync
• Resolving "The name _____ of the list element is already in use" sync error.
• Resolving a "Transaction not in balance" error in the sync.
• Resolving closing date sync errors
• Resolving Invalid Address sync errors.
• Resolving Duplicate Vendor Sync Errors.
• Resolving a "Query timeout expired" error during the vendor sync.
• Troubleshooting Sync Warnings "Invoice...has changed" in QuickBooks Desktop
• Resolving 'Could Not Find Link' Sync Error.
• Resolving a "Transaction could not be locked. It is in use by another user." Sync Error.
• Resolving the sync error: "Current QuickBooks user account does not have access to synchronize..."
• Resolving the "Error Occurred while creating the product class" sync error.
• Resolving the "Only one A/R or A/P account...." sync error.
• Resolving the "Error while creating bill" sync error.
• Resolving the "Provided edit sequence is out of date" sync error.
• Resolving duplicate invoices or credit memos in QuickBooks or Acctivate.
• Resolving the QuickBooks sync asking for Admin login.
• Resolving the "Invalid reference to a QuickBooks account" sync error.
• Resolving an "Employee cannot be deleted..." sync error.
• Resolving the "Internal error when processing the request" error mean?
• Resolving the “QuickBooks error message: Invalid argument. The specified record does not exist in the list.” Sync Error
• Resolving the "Invalid Reference To QuickBooks Item ... In The Invoice Line" when I Sync?
• Resolving Sync Errors After Deleting a Tax Category in QuickBooks.
• Resolving "Transaction Split Lines to Accounts Receivable Must Include a Customer on That Split Line." sync error.
• Resolving a missing journal entry in Quickbooks.
• Resolving customers getting recreated after merging in QuickBooks.
• Resolving duplicate payments showing up in QuickBooks or Acctivate.
• What do I do if I cannot Sync to QuickBooks if it's Closed but the Integrated Application Certificate is Set?
• Resolving “Missing Account” Journal sync error.
• Resolving "The invoice uses tax inclusive prices, but the 'Allow tax inclusive (gross) prices and costs to be entered' QuickBooks preference is not enabled" sync error.
• Resolving 'Could not determine which sales account to use... for tax rounding discrepancies. Please create in QuickBooks an Other Charge Item named “Tax Discrepancy” ' Sync Errors
• Resolving the 'Please create in QuickBooks an Other Charge Item named "Purchase Tax Discrepancy", then synchronize again.' Sync Error.
• Why aren't all customers syncing over to QuickBooks?
• Resolving an invalid certificate error when attempting a sync to QuickBooks.
• Invoice Sync Error: "Error: could not load string. Check status."
• "Error while connecting to QuickBooks Could not create QBFC Session Manager" when syncing
• Missing Invoice: Invoices Not Syncing from Acctivate to QuickBooks
• Resolving Product Class Sync Error: “Cannot use SalesOrPurchaseMod aggregate when the item is reimbursable”?

QuickBooks Online

• Index of QuickBooks Online Sync Errors
• "Could not find CreditMemo with ID" error when voiding a credit memo invoice
• Why are expenses on Vendor Bills being marked billable in QuickBooks?
• Troubleshooting Sync Warnings "Invoice...has changed" in QuickBooks Online
• Why does updating an invoice in Acctivate fail with a closed period error from QuickBooks Online?
• Error: The account period has closed and the account books cannot be updated through the QBO Services API
• Resolving Invalid Email Address Sync Errors: Error Email Address does not conform to the syntax rules of RFC 822
• Resolving the QuickBooks Online sync error "Do you also want to update existing sales transactions to use the new sales account?"
• QuickBooks Online Sync Error "BadRequest. Details: Duplicate Document Number Error : You must specify a different number. This number has already been used."
• Resolving Sync Error 'Element contains invalid characters'
• Duplicate Journal Matching in QuickBooks Online companies
• Resolving QuickBooks Online sync errors due to a Journal Number already being used.
• "You can only use one foreign currency per transaction." error when syncing with QuickBooks online.

Mobile WMS

• "Could not find product" error on Acctivate Mobile.
• How do I fix the "ACCTivatePath not set" error for Acctivate Mobile?
• "Access to the path....is Denied" is received whenever browsing to the Acctivate mobile webpage
• SSL Certification error with Acctivate Mobile WMS
• Why can't Acctivate Mobile WMS connect to the server?
• How do I Troubleshoot Error 500.19?
• Why is http://ServerName/ACCTHandheld defaulting to a Bing Search?
• Why am I getting "There was no endpoint listening at..." when printing from Mobile Device?
• How do I resolve "Generic Failure" error when trying to configure mobile printers
• Why is my new company not showing up on Acctivate Mobile?
• Resolving “HTTP 404.17 – Not Found”
• What to do if localhost/accthandheld is blank
• Why Do I Receive a Timeout Error When Attempting to Print Documents From Acctivate Mobile?
• HTTP Error 404.3 - Not Found error received loading Mobile webservice
• Why am I receiving an "Unable to locate required IIS components" error when installing Acctivate mobile?
• Troubleshooting Mobile Printing.
• Acctivate Mobile webservice returns an error stating Acct.ini does not exist
• Why am I getting an "ERR_NAME_NOT_RESOLVED"/"Name Resolution Failure" on Acctivate mobile for Android?
• "The network name cannot be found." when opening Acctivate Mobile
• 'Access to the path "\\SERVER\Acctivate\Data\_AcctQ.ini" is denied' when opening Acctivate Mobile
• "Could not write to file..." error during Windows Mobile device installation of Acctivate
• Internet Information Services (IIS) Manager: The process cannot access the file because it is being used by another process.
• Resolving the error "Could not load company data" when trying to access mobile.
• Testing barcodes for use in Acctivate Mobile.
• How can I fix an incorrect web service URL in the "Setup Mobile Device" menu?

Web Store Integration

• Why is Tax Not Coming in from the Web Store?
• Resolving "Unknown payment method..." on a web store import.
• My Webstore Has Different Fulfillment Channels, Xpaths And Other Common Webstore Issues
• Skipping web order number in the webstore import
• Resolving Webstore sync error: Webservice returned zero length data
• Resolving the "Access Denied" error when running the Magento webstore sync.
• Resolving the BigCommerce Shipment Export “Items” error.
• Resolving the Magento web store Shipment export error.
• Troubleshooting Web Store Sync Error “The underlying connection was closed: An unexpected error occurred on a send.”?
• Shopify returned exception: An item cannot be active at more than one location if one of them is a fulfillment service location.
• Disabling Business Alert warnings for web store.

EDI

• Why Can't I Find my EDI 850 Orders in the Process EDI Window?
• Why is Acctivate not creating the Advance Ship Notice - 856?
• Why is the FTP EDI Folder Not Importing in Transactions?
• What does the message "The given path's format is not supported" mean for my FTP EDI folder?
• "Cannot set workflow status to Shipped (S) due to the current order status of Completed (C)" when importing an EDI Shipment (945)
• Why am I receiving duplicate EDI 810 lines?

Reports

• Why is Acctivate crashing when printing sales order forms?
• "Unable to open a connection to the database to run the report." error when trying to run a report
• Why are graphs not appearing on Dashboard Reports?
• Why is my report printing random characters?
• What if Report headers are truncated when exporting to Excel?
• Why am I getting "The page size was not large enough" for reports?
• Why am I Prompted for a Password when I Preview a Custom Report in Acctivate?
• Why am I receiving the error from Crystal Reports: "Too many items have been given to this array"?
• Resolving a Custom Reports Error or Binding Error for CYMA?
• Resolving Page Size Issues on Reports
• Resolving error "No reports defined for document type 'Business Activity Form'."
• Resolving "Could not load file or assembly..." or "The type initializer for Crystal..." exceptions when running reports.
• Resolving a "Could not load file or assembly. Access is denied" exception
• Resolving "Invalid TLV Error" when Running Custom Reports.
• Error running report. Can't find u25total.dll file received when attempting to run a custom report.
• How to configure Acctivate to run an older version of Crystal Reports Runtime Engine
• Why isn't Crystal Reports Locating All Database Views or New Fields?
• Crystal Reports error "Page Header plus Page Footer is too large for the page"
• Resolving Long Report Preview Loading Times.
• How do I Enable Verbose Logging for Printer Issues?
• Redirect Printer is not appearing as a device on Remote Desktop Server
• Why are my barcodes printing text?
• How to resolve reports printing cut off?
• Why am I getting "printer - error" when printing from Acctivate?

Database

• What if I cannot find a Created ODBC Connection?
• Why does the SQL service not restart after rebooting even when set to automatically restart?
• Resolving error 'Restore failed for Server 'servername\instancename'.
• Resolving Error Running Database Update: "Create Failed for Index..."?
• What do I do if I get a "Could not allocate space" error when posting transactions?
• Resolving a "Backup Failed..." Sector Size Error.
• Why am I getting "Failed to connect to server {ServerComputerName}\{SQLServerInstance}" after restarting server?
• Resolving (80040CA9) error when backing up the Database.
• What are Common Causes for “Could Not Connect to SQL Server”?
• Why can't I create a new or test company in my RightNetworks environment?
• Why is My Database "Read-Only" After Moving to a New Driver Location?
• Resolving the message "This Backup File Contains 10 Backup Sets"
• Resolving the error: "Not enough storage is available to process this command"?
• Resolving "You must log in as an active user with SysAdmin permissions to upgrade the database."
• SQL Server user account locked out
• Troubleshooting performance problems.
• Reducing the size of a Database Transaction Log file.
• Accessing SQL Server Configuration Manager if it's not on the Computer.
• Resolving "The backup directory was not found on the server" when backing up Acctivate

Imports

• Why is the Inventory section missing when using the Import Data Utility?
• Why am I getting a "Product Class: Product Class is ambiguous" error?
• "Date must be formatted in the system's short date/time format" during an import
• Troubleshooting various Import data tool issues
• Why am I getting "file could not be loaded" when I import sales orders?
• Why am I getting "Cannot Open Spreadsheet" Error When Attempting to Import data from an Excel File?
• Why am I Getting "More than One Record Returns and Recordset was Not Opened in Batch Mode" on the Product Import?
• Resolving "Default Tax Code has not been set" message importing sales orders.
• "Too many field defined." when importing a spreadsheet
• "Check that the mapping for this import matches with the field names in the import file." during a sales order import.
• Provider cannot be found. It may not be properly installed. Error 3706 : 0xE7A
• Preventing Excel from removing leading zeros in product id or upc.

Email

• Resolving the 25 email limitation when using GoDaddy for sending email.
• Resolving "Failure sending mail" error when sending email from Acctivate using SMTP.
• Resolving the "Updating Microsoft Excel Connectivity" message.
• Resolving "The SMTP server requires a secure connection" Email Error.
• "This message cannot be sent because Acctivate's email settings have not been configured."
• Resolving Http 400 "Token has been expired or revoked" error when emailing through Acctivate
• Error sending message: Error sending message. MS365 returned status 403:
• Troubleshooting 'Error sending message. MS365 returned status 404: Resource could not be discovered.'
• Creating App Passwords for Microsoft 365 Email with Multi-Factor Authentication (MFA) enabled
• Locating temporary file location for email attachments.

Integrations

• Troubleshooting SmartVault File Attachment Issues
• Why did I Receive "Transactions of this market type cannot be processed on this system"?
• Common Errors Returned by Avalara.
• Why isn't CYMA opening from within Acctivate?
• Why am I Unable to Connect My Avalara Account with Acctivate?
• Resolving "Sales Tax Entity/Use Code is not set..." when saving a sales order with AvaTax.
• Error returned from ShipStation: Object reference not set to an instance of an object.
• SmartVault integration issues
• How to fix "Could not refresh OneDrive access token" error
• Deleting a file stored in OneDrive