This article describes the setup needed to produce the accounting file to Great Plains V3 (version 3) and its structure.
Background
Adonis introduced several format files to Great Plains system as different customers presented different requirements to the accounting files that they submit to GP system.
Setup
Plugin
The enable the export to accounting system Great Plains V3 (of version 3 in Adonis), a respective plug-in needs to installed. More details on how to Install APM Plugin here.
The plugin works with APM v.2020.30.6.1 and above.
GL Accounts and Cost Dimensions
The detailed instructions on how to perform setup of GL Accounts and Cost Dimension for accounting report is given in article Accounting in Adonis.
Cost Dimensions for GP V3 file are:
- Department Code - DIM3
- Department Name - DIM4
- Payroll Category - DIM5
- Payroll Entry Code Number - DIM6
- Payroll Entry Code Name (defined directly in the file through DIM6)
How to export the file
As described in Accounting in Adonis chapter 4, the file to accounting system is exported from Accounting Voucher report located under Payroll > Current/Historical Period Reports > By Dimensions tab.
Select export category 025 Great Plains V3 and path to export the file, the path will be remembered by the system.
File format and structure
File is saved in .csv format, no headers.
| Spec of data included | Hardcode value "2" | DIM3 (department code) | GL account (debit/credit) | DIM6 (EC number) | Selected Payroll Period end date (Current Client) Date in format of server where APM is installed | Amount When credit add "-" calc sign in front | PU-MM/DD/YY (Selected Payroll Period end date) | DIM5 (Payroll category) | EC name - fetch according DIM6=EC number | DIM4 (Department name) |
| Sample data | 2 | 101 | 3510161 | 1 | 07-31-20 | 19768.39 | PU-07/31/20 | Basic Wage | Basic Wage | Deck |