Export Reports from Sage 50 UK
This task will generate a report using a layout file in Sage 50. The report can be generated in PDF, HTML and other formats supported by the Report Designer.
Settings
Criteria
Optional
This should contain a list of variables with the criteria values to use when running the report. If the report you're running allows you to specify criteria, you can enter each value as a separate variable.
For example, if the report allows you to specify a particular sales order, you can enter this by creating a variable with the name 'ORDER_NUMBER', and setting the value to your chosen sales order number. Note that the variable name must be the ODBC field name.
This can be viewed from the Sage 50 Report Designer, under Variables > CRITERIA.If the criteria allows multiple values to be provided, these can be entered by selecting the 'List' data type for the variable value.
Output File
Required
The file to save the generated report to e.g. monthly_profit_and_loss.pdf
Output Type
Required
Choose an output format for the report from the list:
- XML
- HTML
- XLS
- XLSX
- TXT
- CSV
Printer
Optional
Printer to send the report to if printing is enabled. Leave empty to use the default printer.
Report File
Required
The actual Sage .REPORT/.LAYOUT file to use to generate the report or invoices e.g. C:\ProgramData\Sage\Accounts\2020\Company.000\Layouts\INVPRCA4.layout
Should Print
Required
Set to true if you would like the exported report to be printed.