This article reviews the GL Sales Export for R365 Accounting. Here, users can export posted GL Sales data formatted for import to R365.
Article Topics
Report Parameters
| Field | Description | |
 | Location Group | Location group with GL Sales data to be exported. Only one location group can be selected. |
 | Location Group Search | Click to search for a location group in the list |
 | Start Date | First date of GL Sales data included in the export |
 | End Date | Last date of GL Sales data included in the export |
 | Date Quick Pick | Click to populate the 'Start Date' and 'End Date' with the selected option |
 | Date Range Selector | Click to populate the 'Star Date' and 'End Date' with the selected date range |
 | Re-Export if checked | Check to re-export previously-exported dates for the selected location. If left unchecked, exports for previously-exported dates for the selected location group will contain no data. Learn more about export tracking below. |
 | Format | Export - Export is downloaded as a .csv file Email Export - Export is emailed to a manually-entered email address |
 | Run Export | Click to generate the export with the selected Step1, Step 2, and Step 3 settings. |
 | ERD Command String | Click to view the ERD Command String for the export |
 | API Instructions | Click to view the API Instructions for the export |
 | Click, then save the file below | Click the displayed file to download the generated export |
Report Columns
The Restaurant365 GL Sales Export has the following columns:
Column | Column Title | Description |
| A | JENumber | Journal entry number within Radar |
| B | Type | Journal entry type (will always be 'Standard') |
| C | Date | Date-of-business for the journal entry |
| D | Reversal Date | Date the journal entry was reversed in Radar |
| E | JEComment | Comment for the journal entry (will always be 'GL Sales Export') |
| F | JELocation | Location associated with the journal entry |
| G | Account | GL Account |
| H | Debit | Debit amount |
| I | Credit | Credit amount |
| J | DetailLocation | Location associated with GL Sales data |
| K | DetailComment | Name of the GL Account |
Export Tracking
When the Restaurant365 GL Sales Export is successfully generated for a selected location group and date-of-business, the following is tracked:
- Export date and time
- User who generated the export
This information can be viewed on the 'GL Status' page within the GL Sales Module.
To prevent GL Sales data from being accidentally exported multiple times for any location and date-of-business combination, the GL Sales Export will return a 'No Data' alert if it has been previously exported.
To export a previously-exported location and date-of-business combination, check the 'Re-Export if checked' option in the Step 3 settings.
