It depends on how the report has been made, i'm assuming its a custom report?  There may be a filter on the report/sections that is overriding the include Records with no Transactions.  It could also be conditional formatting.

Hi Gary, it is a custom report but as far as I can see there isn't a filter or conditional format that will override the "Include Records with no transactions".

Hi Ben

Change the join between the account table and the transactional table for both inner options to parent outer. If still an issue then you could send it in as a report design request via Ask Sage article 40232 or if your a Business Partner raise a ticket via Incident Manager and upload a copy of the report.

I hope you found a solution? Add the PLSupplierAccounts table again as a STATIC table and default alias name PLSuollierAccounts1

Use the PLSupplierAcccoints1, PLSupplierAccounrNo as a section group header/footer ....  Adding the new STATIC table and setting the original supplier table with a parent outer join will ensure ALL suppliers are reported back regardless of existing transactions..

Update - Setting the join to Parent Outer is only half the solution.  When using the criteria to select BETWEEN two transaction dates the report will automatically be filtered to only INCLUDE suppliers with WITH transactions between the date range,

The Transaction Date range criteria needs to be set as transient - The FROM and TO dates held in this criteria then need to be used to report back the selected transactions and ignore those outside the date range.  A bit complex but you can find a working example at https://www.rich-reports.co.uk/financials-2/notes-purchase/report-190