During your sync operation, you receive an error showing ” No matching records found (ODBC -2028)” in SAP Business One

Cause

The dependent data present in your packet does not have matching counterpart in SAP B1. You must ensure the dependent data is created prior to this document creation.  For example, you might have chosen a customer for your order packet which is not present in SAP B1.

Resolution

You should always use Halt – Resume node to make sure dependent data is pushed before pushing the required data.

SAP Business One Query Generator helps the user to develop SQL Queries on the fly very easily. If you are using an older version of SAP Business One, then you may consider upgrading your SAP Business One to the latest version to avoid loopholes of the older versions.