Connectwise to Sage 50 US FAQs
Item Class
Field: Exception, Error: An error occurred while importing!
This happened for Field Name: Item Class
This error happens when Zynk is trying to create or modify a ConnectWise Catalog Item in Sage, but it already exists in Sage with a different Item Class. You can't change the item class for an item once you have saved it. This error can be ignored and can be treated as a warning.
GL Account
Field: Exception, Error: An error occurred while importing!
This happened for Field Name: G/L Inventory Account
This error normally occurs if one or many Account References on the item are blank (Sales, COGS or Inventory Account References), usually adding the missing GL Accounts in ConnectWise against a related sub-category resolves this error. Within Zynk, we have also put in a condition to exclude those fields from the import but by doing so you are allowing Sage to use default GL codes in Sage.
Duplicate Number
A common error is caused when someone unbatched the Invoice or Procurement within ConnectWise to make small adjustments and hasn't been re-batched afterwards. This indicates that the document number (invoice number or purchase order number) has already been used in Sage. Please re-batch the invoice in ConnectWise.
Object reference not set to an instance of an object
The object reference is not set to an instance of an object on Import Invoices or Purchase Invoices. This error could refer to the Item ID being longer than 20 characters (including spaces) when trying to auto-create an item in Sage. The auto-create items function does not trip the product codes to 20 characters to avoid linking multiple ConnectWise items with similar product codes against a single Sage Item.
Creation
Unable to complete request at this time. at Interop.PeachwServer.IApplication.CreateImporter(PeachwIEObj eImpObj) at Zynk.ERP.Sage50USV2023_0.Tasks.BaseImportDocumentRuntime`2.AutoCreateInventoryItem(Line line, Boolean isSales) at Zynk.ERP.Sage50USV2023_0.Tasks.ImportSalesInvoicesRuntime.ProcessLine(SalesInvoice salesInvoice, SalesInvoiceLine salesInvoiceLine) at Zynk.ERP.Sage50USV2023_0.Tasks.ImportSalesInvoicesRuntime.ProcessRecord(SalesInvoice record) at Zynk.ERP.Sage50USV2023_0.Tasks.BaseImportRuntime`2.RunSageInternal[T](T task, IProgress progress, ILog log, ZynkObject input)
This error usually occurs when Zynk is trying to create a Customer or Product record in Sage but the AccountReference or Product Code end with space.