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
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
airtech 1/27/2014 4:27:35 PM

taPOLine Project Accounting returns 20158 "Segment Override Account does not exist"

Work In Progress GL Account: 15000

Default WIP Posting Account: 15000-C (Tools->Setup->Posting->Posting Accounts [under Projects/PM/Work In Progress TM])

Project Sub Account Override Segment ID: S

eConnect Error Code: taPoLine(20158): Segment Override Account does not exist   

Using the eConnect stored procedures directly I am able to build a POP transaction with taxes and header.  It works swimmingly until I include a Project's Sub Account Overrides.

In a Time & Materials-When Billed typed Project the TM: Work In Progress check box is active indicating that GP should apply costs to our Service department's WIP account ("15000-S").  Again, the default Posting Account is "15000-C"  and it works fine when the Sub Account Overrides are not defined.  When the segment Id is defined as "S" or "C" they continue to output the eConnect error above.  Peculiar behavior since "15000-C" is the same account the Posting Accounts have set as the default.

In a Fixed Price-Cost to Cost typed Project the FP: Work In Progress check box is active and the POP transaction succeeds and the line items display the correct "15000-S" account.

I have looked at the Posting Accounts and both the 15000 account exists for both 15000-C and 15000-S.  Additionally, using the native GP interface, there are no problems submitting the exact same entries.

For the record, I am not an accountant in any way, shape, and/or form.  Any hints, suggestions, or clues as to how one may tackle this issue??

Thanks in advance!                                                    

Version: GP 2010
Section: Dynamics GP, eConnect, SQL Scripts








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