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