I use Excel spreadsheets to manage data relating to intercompany Balance Transfers.

In v25 this code worked just fine.

SELECT AUDIT_JOURNAL.RECORD_CREATE_DATE AS Posted,AUDIT_JOURNAL.TRAN_NUMBER, AUDIT_JOURNAL.TYPE, AUDIT_JOURNAL.DATE, AUDIT_JOURNAL.ACCOUNT_REF, AUDIT_JOURNAL.INV_REF, AUDIT_JOURNAL.DETAILS, AUDIT_JOURNAL.TAX_CODE, AUDIT_JOURNAL.AMOUNT
FROM AUDIT_JOURNAL AUDIT_JOURNAL
WHERE (AUDIT_JOURNAL.NOMINAL_CODE=1110)
and deleted_flag=0
ORDER BY AUDIT_JOURNAL.TRAN_NUMBER

however in 28.1 the query above returns no new records for the current year (2021-2022) on any of my 3 trading company Sage instances.

Its as if there is a cut off point at or around the 31st Mar 2022

I suspected that the cause was down to a change in Sage 28.1 and that perhaps the tables that I am querying via DSN have been changed or a different method has been introduced to provide the same information.

I have ensured that the DSN in use are 32bit and for v28.1 (although I don't think there is much difference between 28 and 28.1

is this a known issue?

thanks all,

jON