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
DanielE 11/15/2007 10:49:18 AM

Invalid object name 'PA10601'

We are testing the intergration of a new Purchase Order and the error log is giving us the following error:

 

     11/08/2007 04:11:25 - SQL: Invalid object name 'PA10601'.

 

What is confusing is that the client does not have the Project Accounting module and we are not trying to pass an PA data on the line. Here's the sample PO doc we are testing with:

 

<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

  <POPTransactionType>

    <taPoLine_Items>

      <taPoLine>

        <PONUMBER>TEST09</PONUMBER>

        <VENDORID>ACC</VENDORID>

        <LOCNCODE>FACTORY</LOCNCODE>

        <VNDITNUM>X0355-1010518</VNDITNUM>

        <ITEMNMBR>X0355-1010518</ITEMNMBR>

        <QUANTITY>1</QUANTITY>

        <UOFM>CS5X</UOFM>

      <NONINVEN>1</NONINVEN>

 

      </taPoLine>

    </taPoLine_Items>

    <taPoHdr>

      <POTYPE>1</POTYPE>

        <PONUMBER>TEST09</PONUMBER>

        <VENDORID>ACC</VENDORID>

        <DOCDATE>11/7/2007</DOCDATE>

    </taPoHdr>

  </POPTransactionType>

</eConnect>

 

 

Version: Unknown or N/A
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