Skip to main content

I am using CDATA Cloud with a virtual SQL server to connect to Exact Online. I have two requirements related to data tracking and retrieval:

  1. Tracking Classification Code Changes:
    I need to track any changes or modifications made to the Classification Codes in Exact Online. Specifically, I want to retrieve all rows where changes have occurred in the Classification Codes.

    Request: Could you provide a SQL query to fetch rows with any modifications or changes in the Classification Codes?

  2. Retrieving Division-Associated GL Account Codes:
    I need to retrieve the GL Account Codes associated with each Division in Exact Online.

    Request: Could you provide a SQL query to fetch the Division-associated GL Account Codes?

Hi Muthu!

Based on what you described, it sounds like you’re using the CData Connect Cloud tool. If that’s the case, then you should be able to use the built in query builder to query the data you’re looking for instead of specific SQL statements.

As for the data you’re looking for itself, you should be able to find the relevant GL Account Codes data on the GLAccounts table: https://cdn.cdata.com/help/DYJ/cloud/default.htm#pg_table-glaccounts

...and the Classification Codes should be available on the GLAccountClassificationMappings table: https://cdn.cdata.com/help/DYJ/cloud/default.htm#pg_table-glaccounts

The data model documentation covers everything that the tool has access to, so I’d highly recommend making use of it in regards to any questions as to what data is accessible.