Hi @muthuEOL 

From your description, it would seem like you are having issues with certain records for the ReportingBalance view when connecting to Exact Online. Before looking further into this it is important to clarify what CData tool you are using along with your use case. With that in mind, are you perhaps using the Connect Cloud add-in to load data from the Exact Online connection into Excel? 

Returning to the issue you have reported, the Exact Online connector makes use of the Exact Online API and when loading data from the ReportingBalanaces view it would hit the ReportingBalance endpoint which would return the response data from the server. This means that the values returning for the Id column should be what the server is returning. The only reason why some record might be missing could be in case of a deleted record. However, in order to make sure if the server is returning the correct data or see if something might have changed you might want to enable logging in Connect Cloud or in any other CData product you might be using.

In case you are seeing any discrepancy in the logs feel free to reach out to the [email protected] and submit a support ticket so that our team can investigate further.

I checked that reporting balance row is deleted how to track this which row is deleted because I am syncing data from exact online to excel