Great Plains accounting file (V3)

Owned by Valentyna Plokhykh
Last updated: Feb 25, 2022 by Halvard Meijer
2 min read



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