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:
-
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?
-
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?