Sage have recently updated the TransactionReference in Sales and Purchase Ledger from 20 chars to 40 chars, however, the BI database is still set to 20 characters, so it fails during the refresh if the char count is over 20: BI no longer works as ...