Prerequisite
this guide is aimed at SecuTix clients having ordered a specific accounting export.
It considers that an accounting interface has been delivered during on boarding or through a service.
Behavior of accounting exports
Content of the exports
Accounting exports are executed through schedules, which can be launched manually or automatically.
The execution of a schedule contains all accounting data (orders, payments...) situated between T1 and T2 (seel below) according the following filter:
- Data related to cashdesks financially closed between T1 and T2 if those cashdesks are related to an operator.
- Data related to orders closed between T1 and T2 when they related to sales channels without operators (online sales, resellers...)
Computing T1 and T2
T1 is the date of the last successful execution of the same schedule OR to the field Date from defined in the screen, brought to midnight (1)
T2 is the date of the current execution OR to the field Date to defined in the screen, brought to midnight (1)
(1) more precisely, brought the day start time of the organization.
Exemples :
Accounting export is executed the 23 jan 2018, 07:22. Last successful export occurred the 16 jan 2018, 07:18.
→ T1 = 16 jan 2018 00:00, T2 = 23 jan 2018 00:00
Accounting export is executed the 23 jan 2018, 07:22. Last successful export occurred the 16 jan 2018, 07:18. Field Date from has been set to 01/01/18 00:00.
→ T1 = 01 jan 2018 00:00, T2 = 23 jan 2018 00:00
How to set up the interface
- Go in External interfaces. Create a new interface of type "Export", subtype "Files". (it may already exist by default, named "Accounting export" in that case reuse it)
- Setup the SFTP server to which the accounting data will be published.
- Create/update a schedule (as detailed below).
Fields of schedule screen
Accounting data exports are done from module tools / list of interfaces in context organization.
- Frequency. Recommended: 24 hours OR 1 week.
- Date of first export. This is not the field Date from mentioned above.
- Time of the exports. SecuTix tries its best to stick to this precise time. Recommended: 1 am.
- Date from. This is the field mentioned above. Format : dd/mm/yy hh:mm Exemple 01/02/18 00:00. By default, leave empty to have a delta export.
- Date to. This is the date mentioned above to compute T2. Format : dd/mm/yy hh:mm Exemple 05/02/18 12:00. By default, leave empty to have a delta export.
- Query used for export. By default, use SIMPLE to receive the data formatted in the default format. If you need a custom format, please contact SecuTix' service team.
- Naming format of the produced file.
- File encoding (see FAQ)
- End of line characters for file. Possible values : Unix, Windows
- Field separator. Do not modify.
- With headers. Self explaining.
- Zip the file : if checked, a zipped file will be produced.
- Fields delimiter. Do not modify.
- List of emails separated by semicolumns, which will received the produced file.
FAQ
Accounting data are missing
Are all you cash desks financially closed ? If yes, do not forget that the data will appear in the export the day after financial closure.
I receive no file on my server
Open the log of the last execution. It is probably failing.
If it indicates a communication error with the server, contact the company managing the server. If they don't find any information, open a support ticket.
If the log indicates a missing accounting code, please fill it.
If the log indicates another error message, please do an excel export of the log an attach it to a support ticket.
The file I receive contains data that I already received
Do the data that you received come from the same schedule ? (See above : SecuTix computes the delta based on a given schedule)
If yes, open the schedule screen and check if Date from (number 4, above) has been set. If yes, empty it.
My accounting code are false, missing. I must change them.
Open the mappings screen related to your interface.
I executed an export the 23 jan. Last export ocurred on 18 jan. But my files contains data related to the 7 jan. Why ?
You probably financially closed a cashdesk between the 18 and the 23.
Accented letters are garbled in my accounting software
Check with your software provider and ask him the file encoding that he expects. Set it in field 7.
