Using Report Designer you can add multiple joins and their conditions into the join editor as a batch by using the raw text editor. This saves you having to set up individual joins and join types.
Cause
Resolution
Select the document you want to amend, then click Edit.
Click Report, then click Joins.
Click use raw text editor.
Select the existing code and press delete.
Enter or paste in the new code, then click OK.
On the menu bar click File, then click Save As.
Enter a new file name then click Save.
On the menu bar click File, then click Exit.
Can't find the report you're looking for?
Our reporting team offer a bespoke report design service for Sage 50 Accounts and Payroll. Book a consultation today!. Find out more >