Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Points: 50375

9/20/2012 5:58:25 PM

eConnect - PM Transaction with Analytical Accounting

* This article, and all our great eConnect documentation, Is available on the eConnect menu

I've been coding eConnect for a while, and this one was hard. I wanted to be sure to save this for future use.

Because of its 'bolted on' nature, Analytical Accounting is often not straight forward.

This is a complete working example of a PM Transaction that uses AA.


Not every line in the distribution needs AA; the AA lines need their own counter for that reason.

The DocType here for the AA is 0, not 1. That's in the documentation

Some errors that I got along the way:

An item with the same key has already been added

There are no distribution accounts linked to an Accounting Class.

The example below fixes those issues
Version: GP 10,GP 2010
Section: eConnect

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables