By default, only exceptions are written to the Acctivate exception log when opening or refreshing EDI. This minimizes the amount of data written to the log. However, users may want to increase the level of logging if you are troubleshooting a warning…
Articles
Modify The EDI Exported Filename Structure
Your EDI VAN or Trading Partner may request a modification to the EDI filename structure when you are in the process of setting up a new EDI Trading Partner. Modifying the filename structure can be accomplished relatively easily by modifying the Trading…
Posted in EDI
Required Data for AvaTax Calculations
Acctivate users that have enabled the Avalara module and are using the AvaTax service to calculate sales tax, questions may arise regarding the fields and the data necessary for AvaTax to calculate tax properly. When creating new Sales Orders or modifying…
BigCommerce Shipment Export “Items” error
When using the Acctivate webstore module for importing and exporting BigCommerce order information, users may receive the following error in the Shipment Export section of the webstore synchronization. Status returned from web server: 400 / Message: The required field ‘items’ was…
Posted in Web Store Integration
Export EDI Invoices for EDI Orders Only
When using EDI functions in Acctivate, users may need to consider the EDI Invoice export options for each EDI Trading Partner. The InvoiceSelection option for EDI Invoices can be set to two different selections. Option 1. EDI Only will prompt Acctivate…
Posted in EDI
Anti-Virus realtime scanning causes performance issues
Acctivate users may experience performance issues if their anti-virus uses a realtime scanning function. Realtime scanning may constantly scan all SQL Server activity, which can be an extensive amount of data flowing between the Acctivate server and the workstations. This can…
“Missing Account” Journal synchronization error
During a synchronization with QuickBooks, Acctivate users may receive messages similar to: Error Journal SubmitGLJournalBatch: error while creating journal entry ‘somejournalID’: There was an error when saving a General Journal transaction. QuickBooks error message: Missing account. This error is typically…
Posted in Configuration, QuickBooks and Sync
Handling Inventory Counts with Multiple Users
Although the inventory count process is often a group effort, each count sheet can only be entered by one user in Acctivate. If more than one user attempts to open the same count session number in the Enter Count screen, the following…
Posted in Inventory
Backup fails after moving Acctivate to a new server
Users may receive the following error when backing up Acctivate. Cannot use the backup file ‘C:\Program Files (x86)\Acctivate\..\Backup\ACCTivate$Demo.bkf’ because it was originally formatted with sector size 512 and is now on a device with sector size 4096. BACKUP DATABASE is terminating…
Posted in Database, Installation
Duplicate Vendor Synchronization Errors
The following error may be received if a vendor has been deleted from QuickBooks or if a QuickBooks rebuild recreated the related Vendor record, assigning a new internal ID to the vendor. Error Vendor [SynchronizeQBVendors]Microsoft OLE DB Provider for SQL Server (-2147217873) The…
Posted in QuickBooks and Sync
