ConnectWise 'CreateBatch' returned an error: System.Data.Syntax.ErrorException: Missing Operand after 'S' operator. at

An error results in ConnectWise where a Packing SlipID or an Inventory Adjustment ID includes the character '.



As the ' is used to define a string in the batch, the use of this character breaks the operation of the batch create process, resulting in a big red error.



To fix the issue:


1. Identify the Offending Record via the Accounting Interface > Unposted Procurements

  • If the record is a Purchase Order - Packing SlipID: Simply open the PO and Items, to remove the ' from the packing SlipID
  • If the record is an Inventory Adjustment - A support ticket needs to be opened to request that the ' is removed from the record as this cannot be done through the UI.
    Have ConnectWise support refer to Ticket Reference: 5594498 for process and actions required.
P
Paul is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.