SBX - Search With Button

SBX - Forum Post Title

eConnect: Invalid Object

Microsoft Dynamics GP Forum

Jen Lao asked a question on 19 Oct 2010 11:15 AM

Question Status

Suggested Answer

When I tried to run a mapping using SmartConnect with the taPoLine and taPoHdr, i received this error, "Invalid Object name 'PA01901'".  I know that this table is related to Project Accounting but we don't license for Project Accounting that is why we didn't install it our server.  Should I need to install the PA module?

Reply
Emily Halvorson responded on 21 Oct 2010 8:21 AM
My Badges
Suggested Answer

Hello,

This issue is caused by PR 60024, which is currently scheduled to be fixed in year end releases of GP 10.0 and GP 2010.

The Work Around - is to script the table create from Fabrikam/TWO database.  

Go to SQL Server Management Studio, expand out TWO and Tables, right click on PA01901 and Script Table As > Create to > New Query.  

Change the USE statement to your company database instead of TWO.

Add the following line to the end of the script:

grant all on PA01901 to DYNGRP

Click Execute

Reply
Emily Halvorson responded on 21 Oct 2010 8:21 AM
My Badges
Suggested Answer

Hello,

This issue is caused by PR 60024, which is currently scheduled to be fixed in year end releases of GP 10.0 and GP 2010.

The Work Around - is to script the table create from Fabrikam/TWO database.  

Go to SQL Server Management Studio, expand out TWO and Tables, right click on PA01901 and Script Table As > Create to > New Query.  

Change the USE statement to your company database instead of TWO.

Add the following line to the end of the script:

grant all on PA01901 to DYNGRP

Click Execute

Reply

SBX - Two Col Forum

SBX - Migrated JS