This article reviews the GL Sales Export for R365 Accounting. Here, users can export posted GL Sales data formatted for import to R365.
|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|
The Restaurant365 GL Sales Export has the following columns:
|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|
|J||DetailLocation||Location associated with GL Sales data|
|K||DetailComment||Name of the GL Account|
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
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.