Details Report Overview
The Details Report, found within the Accounts Mode > Accounts General Ledger > Accounts General Ledger Reports, offers a range of reports that can be generated using various methods for your General Ledger accounts within your SapphireOne data file.
Upon selecting the Details Report from the General Ledger Reports Menu, SapphireOne will display a standard Print dialog screen. This screen enables the user to choose and customize the criteria and data they wish to include in the Details Report.
The user can select from the Share Destination, Report Type and Report Sort Order drop-down menus to determine their preferred Details Report layout. Reports are created using a combination of the selected metrics. The user also has the option to create custom reports using SapphireOne Quick Reports or Custom Reports.
Share Destination Menu (Details Report)
The Share Destination Menu allows the user to choose the destination for the Report, and select from the options which are as follows:
| Printer | Selecting the Printer option from the default Share Destination menu and subsequently clicking the Process button, will instruct SapphireOne to send the report directly to the designated printer. |
| Custom Report | Alternatively, when the Custom Report option is chosen, SapphireOne immediately requests the location of an existing Custom Report to be used as a template when the Process button is is activated. SapphireOne then generates the report, incorporating the selected Custom Report as the template. |
| Quick Report | Selecting this option and then clicking the Process button will prompt SapphireOne to display the Quick Report screen, allowing the user to set up a quick report. For detailed instructions on setting up this report, please follow the link to the article on Quick Reports. |
| CSV | Selecting the CSV option within the Share Destination menu and then clicking the  Print button, will prompt SapphireOne to display a Select Report Range alert. You can find documentation for this alert immediately below. |
When you select the Share Destination option as CSV, please note that the Share Destination option for CSV differs from other areas of Sapphire One. Upon clicking the Print button, a Select Report Range alert will appear. Within this form, at the bottom, you will find a toggle button that allows you to switch between a period-based report and a date-based report.
- Period – If you opt for the default period-based report, you can use the mouse to select the periods that you want the report to encompass. It should be noted that provision has been made for the years to select from up to 30. Within your data file if required.
- Date – However, if you choose the date-based report, you will be presented with the option to enter a start date and an ending date for the report. This flexibility allows you to customize your report generation based on your specific requirements.
Report Type menu (Details Report)
Selecting the Report Type option will enable the user to print different layout styles of the Details Report.
| One Liner: | This report supplies data similar to chart of accounts on a single line. |
| Two Liner: | This report supplies the alternate coding as well as above data in the One Liner Report. |
| Four Liner: | This report prints full specifications about each account excluding balances. |
| Audits Base Style: | This option enables the user to generate a Basic Audit report for the General Ledger. During the process the user will be asked if instead of printing it, SapphireOne will generate a CSV file which may be opened with any spreadsheet program. Documentation later in this section. |
| Audits Full Style: | This option enables the user to generate a Full Audit report for the General Ledger. During the process the user will be asked if instead of printing it, SapphireOne will generate a CSV file which may be opened with any spreadsheet program. |
| Audits Old Full Style | This option enables the user to generate a Full Audit report for the General Ledger with legacy styling. During the process the user will be asked if instead of printing it, SapphireOne will generate a CSV file which may be opened with any spreadsheet program. |
Report Sort Order menu (Details Report)
The Report Sort Order Menu allows the user to select from various sorting methods and criteria to organise data in different sequences while still maintaining the same fundamental report format. The user can sort data by:
| No Sort: | No sorting performed, the report is printed as it is in the list on screen. |
| By Account ID: | Sorted and totaled by each General Ledger Account ID. |
| By UDF-1: | Sorted and totaled by UDF-1. |
| By Alternate ID: | Sorted and totaled by Alternate ID. |
| By Class: | Sorted and totaled by Class. |
| By Department: | Sorted and totaled by Department. |
Report Selection menu (Details Report)
The Report Selection Menu allows for additional sorting of report criteria.
| All Records | This will display all General Ledger items, including inactive items. |
| Current Selection | This will display the current selection only |
Report Selection options
In SapphireOne, consistency in layout is maintained across all print dialog screens, ensuring users do not need to constantly adapt to varying layouts. However, it is important to note that the Report Selection options differ across print dialog screens.
For additional filtering of reports using criteria from cells within related tables, refer to the following details.
- Once users enter data into either the third or fourth data entry field below, the ‘Selected Records’ radio button will become active, indicating that additional filtering is being applied to the report.
- Directly beneath the Report Selection label, you’ll find two rows where you can establish additional selection criteria for your report. These rows consist of two drop-down menus and two data entry fields for user input. In each row, the first drop-down menu allows users to select from various cells within related tables in the data file.
- These options in the first drop-down menu may or may not pertain to the same cells in the same table in the second row. To access the available options in these two drop-down menus, simply click on the respective item to display the drop-down menu and make your selections as required.
- The second drop-down menu in both rows enables users to choose a mathematical option for each row. In this case, the available options are consistent and include the operators: Equals, Not equal to, Less than, Greater than, Between, Contains, and Does not contain. The last two columns in each row are where users input the data required for the mathematical calculations mentioned earlier.
- Typically, data is entered into the first data entry field. However, when selecting the Between option, data must be entered into both columns. This allows SapphireOne to filter the data based on the range defined by the user’s input in these two data entry fields.
Report Buttons
| Process | This Process button will take the user to your operating platforms Print dialog screen. |
| Cancel | This button will cancel the current procedure. |
| Record List | Selecting this button brings up a list of all General Ledger items within the users SapphireOne data file. The user can then use the ‘command/F’ and ‘ctrl/F’ search function to search for the inventory item to be printed. |
| Options Button | The Options Button will be displayed and active when the relevant options have been selected. Otherwise the user will find that it is greyed out and so unusable. |
| Queue | This button places the report on a queue to the printer. It will be displayed and active when relevant. |
| Background | This tells SapphireOne to print this job as a separate task in the background as time permits. It lowers the printing priority for the operating platform. This button will be displayed and active when relevant. |
Report Example (Details Report)
