Direct to SQL Integration - Sage 200 on prem


Hey Everyone,

I've been looking at a site (Sage 200 on premise version 12.00) as a favour they are having issues with Sage financial reports not reconciling. The TB, Aged Creditors and VAT returns are in dispute.

I believe that a developer has written SQL directly to tables in their Purchase Ledger, firstly I suspect that this is the incorrect method? Could somebody confirm this?

Secondly is there any data integrity scripts we can run to highlight where this has caused issues in Sage?

Thirdly could anyone point me in the correct direction on how to integrate, I can't seem to find anything useful on Google.

Many thanks.