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
trepetti 12/26/2019 9:37:27 AM

Error 6149 from taPaProjects when creating new project in GP with SmartConnect

Working on a SmartConnect map that will create a new GP project  / project budget using a SQL table as a source.  I am in the testing phase, so prior to running the map I set the associated Contract status to 4 prior to execution.


The map fails with an eConnect error of 6149, "Invalid Project Number (PAPROJNUMBER) - Project Number already exists in the PA01201 Table".  But there is no existing project in the PA01201 with the same number.  I even rebuilt the indexes on PA01101 and PA01201 to see if the issue was with an indexed lookup.  


Anyone come across this before?

Version: GP 2015
Section: Dynamics GP, eConnect, SmartConnect

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