Adept Export

 

Back Office > Data Export > Data Portal > Adept

 

Description

 

This feature is used to export Sales data to Adept Central Banking. Sales data will only be available for export once Terminal Cash Offs have been saved and committed.

 

Data exported can now be exported using 2 available format versions, namely Version 1 and 2. Samples of these formats can be found here.

 

To Be Considered

 

  1. To make use of any part of this feature, a General Ledger - Adept Registration will be required. This may incur an additional charge. To confirm charges, email registrations@swiftpos.com.au.

 


Settings

 

The settings tabs as depicted below will need to be configured when exporting using the Version 2 format.

 

 

  • Adept Code - Displays/Enter a unique Adept Code associated with each SwiftPOS Media. Note : If no code is specified, the Media Number will be used in the export.
  • Export Path - Displays/Select the folder into which the files generated by the Export, will be located.

 

 

  • Adept Code - Displays/Enter a unique Adept Code associated with each SwiftPOS Location. Note : If no code is specified, the Location Number will be used in the export.

 

 

  • Adept Code - Displays/Enter a unique Adept Code associated with each SwiftPOS Terminal. Note : If no code is specified, the Terminal ID will be used in the export.

 

 

  • Adept Code - Displays/Enter a unique Adept Code associated with each SwiftPOS Master Group. Note : If no code is specified, the Master Group Number will be used in the export.

 


Export

 

 

Export Adept Files

 

  • Export Version - Select from the drop down list one of the formats available.
  • Export Folder - Displays the folder set here.
  • Cash Off - Select from the drop down list of Terminal Cash Offs the Cash Off to be exported. Select the Refresh icon to refresh the drop down list.
  • Export - Select to Export the Cash Off related Sales data for the Cash Off selected. An export file will be generated and named depending on the Version selected:
    • Version 1 - The file generated will be named in the format T_YYMMDD_NN.csv (where T is the Terminal ID, and N is a sequence number).
    • Version 2 - The file generated will be named in the format TTT_YYMMDD_NN.csv (where T is the Terminal ID, and N is a Cash Off's Reset number).

 

  • Mark ALL as Exported - Select to ensure ALL Cash Offs in SwiftPOS are marked as exported. Note : This is usually recommended when initially configuring SwiftPOS to export to Adept for the first time, and there is a requirement that all previous Cash Offs are marked as Exported.
  • Cash Off - Select from the drop down list of Terminal Cash Offs the Cash Off to be reset. Select the Refresh icon to refresh the drop down list.
  • Reset - Select to ensure for the selected Cash Off, the related Sales data is reset and marked as NOT exported, so it can be exported again.

 


File Formats

 

Version 2

 

In this version Sales data is summarised by Master Group and exported as SS type Records.

 

Sample of the content of file 003_210901_01.csv

 

RH,RES,003,2,210901,SWIFTPOS
SS,FOOD,220.00,20.00
TS,C,110.00
TS,EFT,110.00
RF,RES,003,220.00,220.00

 

Version 1

 

In this version Sales data is summarised by Product Code and exported as SS type Records.

 

Sample of the content of file 3_210901_54.csv

 

RH,SBG003,3,654,210901,SWIFTPOS
SS,10130,75.00,6.82
SS,16001,60.00,5.45
SS,20110,85.00,7.73
TS,C,110.00
TS,SB,110.00
RF,SBG003,3,220.00,220.00

 


Related Topics

 

  1. Data Export
  2. Import/Export Overview