3rd Party Integration
IMPORTANT
This article is currently being migrated and is NOT complete. Refer HERE for the complete information.
Subjects ▼
About ▲ ▼
What Is It? ▲ ▼
The swiftpos MS Dynamic GP export is a General Ledger interface that allows Venues to export Sales and Stock Movement data to their Microsoft Dynamics GP General Ledger.
What Is Required? ▲ ▼
- To make use of this feature, sites will need to be registered for the General Ledger MS Dynamics GP interface. This may incur an additional charge. To confirm charges, email registrations@swiftpos.com.au.
What To Consider? ▲ ▼
- All assigning tabs MUST HAVE Accounts assigned. Unassigned Accounts may cause errors.
- Stock transfers between Locations that exist in different Location Groups (Venues), is supported when exporting to a single MS Dynamics GP Company file. Obviously MS Dynamics GP Accounts will need to be configured for the Locations in question.
- For Location Groups (Venues) that have the Track Individual Location Costs option selected, transfers between Locations will be exported, with the value of the transfer calculated based on the cost of the Products in the From Location (at the time of the Transfer).
- GL Account Code Exported - The GL Account Code exported is sourced as follows:
- GL Account - These Accounts can be either added or imported into the Accounts tab. 4 characters in length. (Represented as AAAA in the example below). Once added/imported, these Accounts can then be used to ensure all assignments/mappings are completed in the Clearing Account, Sales Account, Inventory Accounts and Tax Accounts tabs to the right of the Accounts tab.
- Location/Site - This is configured HERE. 6 characters in length. (Represented as BBBBBB in the example below).
- Department - This is configured HERE. 3 characters in length. (Represented as CCC in the example below).
Department Override - To override the default Location specific Department, a Department override can be configured against Master Groups and will be used instead of the Location specific Department when exporting.
- Create a special Master Group (for example, Game Day), and specify an override Dept code (3 characters and represented as CCC in the example below) for it. The code specified here will be used to override the default Location's Department Code when generating the GL Account for export. Note : Override Dept Codes ONLY have to be configured for those Master Groups that require it. All other Master Groups can be left blank. In which case they will default to the Location specific Department.
- Create a special Product Group (for example, Game Day), to which specific Products can be assigned.
- Assign the specially created Product Group to the specially created Master Group.
- Assign (using the Report Group field) the required Products to the specially created Product Group.
- Example
- MS Dynamics GP Accounts - These are configured in the Data Portal > MS Dynamics GP > Settings > Accounts tab and can consist of one of the following:
- GL Account - These are the Accounts that are added form by importing the Chart of Accounts (COA). They are 4 characters in length and are then used as the first 4 characters of the GL Account generated when exported.
- MS Dynamics GP Accounts - These are configured in the Data Portal > MS Dynamics GP > Settings > Accounts tab and can consist of one of the following:
MS Dynamics GP Account | Location/Site | Department | GL Account Exported | Comments |
AAAA | BBBBBB | CCC | AAAABBBBBBCCC |
Where AAAA is the MS Dynamics GP Account from the COA Import. BBBBBB is the Location/Site value configured against each Location. CCC is the Department value configured against each Location. |
3161 | 003BGL | RES | 3161003BGLRES | |
31612 | 003BGL | RES | 31612003BGLRE |
Note : The GL Account will be generated for export, but will most probably cause an error when importing into MS Dynamics GP. |
3161 | 003BG | RES |
Note : The GL Account will not be generated for export in these two cases, as they do NOT comply with the GL Account Code Format. |
|
3161 | 003BGL | RE |
- GL Account Code Exported continued ...
- Department continued ...
- Example continued ...
- MS Dynamics GP Accounts continued ...
- Alternative Account - These Accounts are added (via the Accounts Tab) to ensure an alternate GL Account is generated when exporting. These Accounts can be one of the following lengths:
- MS Dynamics GP Accounts continued ...
- Example continued ...
- Department continued ...
Length | Format | Location/Site | Department | GL Account Exported | Comments |
4 | XXXX | BBBBBB | CCC | XXXXXBBBBBBCCC |
Where XXXX, XXXX-YYYYYY and/or XXXX-YYYYYY-CCC is the MS Dynamics GP Account added as an Alternative Account. Note : The hyphen characters must be included. These will be removed when generating the GL Account for export. BBBBBB is the Location/Site value configured against each Location. CCC is the Department value configured against each Location. |
11 | XXXX-YYYYYY | 003BGL | RES | XXXXYYYYYYRES | |
15 | XXXX-YYYYYY-ZZZ | 003BGL | RES | XXXXYYYYYYZZZ |
- GL Account Code Exported continued ...
- Example
Length | Alternate Account | Location/Site | Department | GL Account Exported | Comments |
4 | 8540 | 003BGL | RES | 8540003BGLRES |
Note : Once an Alternative Account has been added (via the Accounts Tab), they need to be assigned/mapped to the appropriate Accounts, that is via the Clearing Accounts, Sales Account, Inventory Accounts and Tax Accounts Tabs.
Also, A Product requiring Alternative Accounts to that of the Accounts currently assigned/mapped to the Product's Location/Master Group combinations (in the Tabs in the Settings screen), a separate Master Group will need to be created and the Product assigned to it. Also, once the Master Group has been created ensure the Alternative Account has been created and the Location/Master Group combinations (in the Tabs in the Settings screen) are correctly assigned/mapped. |
11 | 8540-045ENT | 003BGL | RES | 8540045ENTRES | |
15 | 8540-045ENT-ZZZ | 003BGL | GDY | 8540045ENTGDY |
- GL Account Code Format - The GL Account Code is based on the 3 sources and a GL Account Code Format value of XXXXXXXXXXXXX, will be exported as a 13-character field.
- If the GL Account Code Format value entered is more than 13 characters long, the GL Account Code will NOT be generated.
- If it is LESS than 13 characters, then only the number of characters specified in the GL Account Code Format will be generated. The remainder will be truncated.
- Any hyphen characters included in GL Account Code Format value entered will result in the GL Account Code NOT being generated.
What Is It Used? ▲ ▼
Used when Venues want to export swiftpos Sales and Stock Movement transactional data to Microsoft Dynamics GP. The MS Dynamic GP Export will export the following:
- Sales - All Sales, Refunds, Account Charges/Payments, etc. Note : With regards to Account related transactions, the MS Dynamics GP export does not export individual Account (Debtor) specific data, but rather exports data that can be imported into MS Dynamics GP in a single Debtors Account (and NOT into individual Debtor Accounts).
- Stock Movements - All Stock Adjustments, Damages, Receipts, Returns, Transfers, Wastage and Stocktake variances.
How To ▲ ▼
How To GET STARTED ▲ ▼
- In Back Office
-
- In Global Preferences, In the Other tab, ensure the GL Account Code Format is set. Refer HERE when specifying the value of the GL Account Code format.
- In Location Group Edit ensure the following:
- Ensure the drop-down Entity field is appropriately selected.
- Ensure that the MS Dynamics GP Data Export Path is configured for those Location Groups (Venues) from which transactions will be exported.
- In Location Full Edit ensure the following is configured for all Locations within each Location Group (Venue) from which data is to be exported:
- Ensure the Department field is configured appropriately. 3 characters in length. This field is mandatory.
- Ensure the Location/Site field is configured appropriately. 6 characters in length. This field is mandatory
- Ensure the Post Financial Data option is selected.
- In the Data Portal, ensure that the MS Dynamics GP Accounts are configured in the Accounts tab. Refer HERE for information on how the GL Account Code that is exported is sourced.
- In Member Classifications, if required set a Discount Expense Media against Member Classifications. This is optional and once set the Discount Expenses incurred in a sale will be exported using the GL Clearing Account the Discount Expense Media is mapped to.
- Venues that have multiple Location Groups (Venues) and transfer Inventory/Stock between Location Group (Venues), then it is advised that the following is configured:
- Ensure the Transfer Mapping option is set to Inventory<->Clearing Account in Administration > Global Preferences > Other tab > GL Account section.
- Ensure the Draw From, Transfer In and Transfer Out Media are mapped to an appropriate Clearing Account in the Clearing Accounts tab in Data Export > Data Portal > Microsoft Dynamics GP > Settings screen.
- Ensure MS Dynamics GP is backed up before importing from SwiftPOS. In the event something goes wrong, then at least the MS Dynamics GP data can be restored from the backup.
- It is recommended that all types of Transactions are tested and imported into MS Dynamics GP. It maybe necessary to enlist the assistance/expertise of an accountant to ensure that from the MS Dynamics GP end, all transactions are posted correctly.
- Once testing of all types of Transactions has completed, the Dynamics GP export can be optionally included as part of the End of Day process. Refer HERE for more information.
- In Back Office
- In Back Office> Data Export > Data Portal > MS Dynamics GP > Settings - Create/Import the MS Dynamics GP Accounts required to assign/map SwiftPOS combinations found in the tabs to the right. For example, Location/Media Clearing Accounts, Location/Master Group Sales Accounts, Location/Master Group Inventory Accounts, etc. The screenshot below provides an example of the basic Accounts required for an initial Export. Obviously this list can be customised and added to, to suit the requirements of individual sites and their corresponding MS Dynamics GP Account List (Chart of Accounts). Note : Account Codes added must comply with the GL Account Code Format as outlined in the Pre-requisites above. Duplicate Accounts are NOT accepted.
This tab is accessed from Back Office> Data Export > Data Portal > MS Dynamics GP > Settings.
- In Back Office> Data Export > Data Portal > MS Dynamics GP > Settings - Create/Import the MS Dynamics GP Accounts required to assign/map SwiftPOS combinations found in the tabs to the right. For example, Location/Media Clearing Accounts, Location/Master Group Sales Accounts, Location/Master Group Inventory Accounts, etc. The screenshot below provides an example of the basic Accounts required for an initial Export. Obviously this list can be customised and added to, to suit the requirements of individual sites and their corresponding MS Dynamics GP Account List (Chart of Accounts). Note : Account Codes added must comply with the GL Account Code Format as outlined in the Pre-requisites above. Duplicate Accounts are NOT accepted.
To be continued ...
Screens ▲ ▼
To be continued ...
End of article ▲