DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
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

Archives

 
Data Access 101 - getting a dataset using UserInfoGet

In Microsoft Dynamics GP 10.0, new connection objects were added to the VBA code. These new connection objects replace the RetrieveGlobals.dll and RetrieveGlobals9.dll files in Microsoft Dynamics GP. This new VBA code lets you create an active connection based off the username and password of the user who is currently logged into Microsoft Dynamics GP. This new connection object is named UserInfoGet. This UserInfoGet connection object enables you to use the following properties and methods:

  • The CompanyName property
  • The CreateADOConnection method  
  • The IntercompanyID property  
  • The UserDate property  
  • The UserID property  
  • The UserName property 

Code sample:

 
How to pass xml to eConnect using SSIS

I have an OLE DB connection that executes a SQL command that generates xml to pass to eConnect.

I don't quite understand how the xml is passed to eConnect or how to ensure I have it formatted correctly. I've looked through the documentation over & over & my xml appears correct - as in it matches the end result shown. Is there a sample VB.NET script that is available that would show how to push a batch file (multiple invoices, in this case) ?

And can someone explain serialization? If this what pieces the header & the lines together?

 Any help is greatly appreciated.

 
How to tell if sales invoice is paid via web service

Hello,

I need to be able to figure out how to tell if a sales invoice has been fully paid via the GP web service. Currently, I am just comparing the SalesInvoice object's PaymentAmount value and the TotalAmount value. PaymentAmount only has a value when a payment is applied to the invoice in the Sales Transaction Entry screen.

I want to be able to post the invoice, then come back and apply a cash receipt to it later and then post that receipt. When I run through that workflow, the PaymentAmount on the SalesInvoice object is still 0. Where can I find the payment that has been applied to the invoice using the web service?

If this is not the proper forum for this question, please let me know.

Thanks!
SOP and Customer ID Field

Hello all, I am trying to auto-populate a sales order.

I have my customer id code and line item codes but I can't get em stuck in the form. )))))

I have an application that pools all the necessary data from our data base for a sales order and I would like to create an integration to fill a sales order with that data. It sounds really basic to me but I am having trouble getting traction on it.

I am sure that I don't understand the process of what methods to call in order to access a field and have them populate.

Can anyone help me out? How do I work around not having direct access to the customer id field?

Do I have to use the Customer ID field in order to have a sales order correctly filled out or can I just use the available fields like Customer Name, address 1, etc?

 

Thanks for any help you can provide.

keith

eConnect outgoing service problem

Hi,

 

I'm trying to install the GP Dynamics 2010 SP1 eConnect 11.0 outgoing service in an Enterprise Windows 2008 R2 server without success. I'm using Fabricam to test it by changing the customer data. The triggers are present in table RM00101, and the changes have been posted to the eConnect_Out table. However when the eConnect outgoing service connects to the SQL Server 2008 R2  TWO database, it gives me the following information in the eConnect service log:

 

System.Messaging

Path syntax is invalid.

System.ArgumentException: Path syntax is invalid.

at System.Messaging.MessageQueue.set_Path(String value)

at Microsoft.Dynamics.GP.eConnect.Outgoing.ExecuteCompanyRequest.Execute_Request(String DocType, DateTime DATE1, String TABLENAME, Int32 DEX_ROW_ID, String INDEX1, String INDEX2, String INDEX3, String INDEX4, String INDEX5, String INDEX6, String INDEX7, String INDEX8, String INDEX9, String INDEX10, String INDEX11, String INDEX12, String INDEX13, String INDEX14, String INDEX15, Int32 Action)

the message resource is present but the message is not found in the string/message table

 

Any ideas?

 
Validate GP login

 Greetings

My scenario is the following: A user X is logged in GP, upon a certain action in a window my customization will require the user to enter manager credentials (which is basically the login for another GP user) those credentials need to be matched against the account of user Y (the manager). Is it possible to validate that the credentials the user enters are valid?

 

Thanks in advance

The Precision is Invalid

You'll get 'The Precision is Invalid' in VBA ADODB transaction if you fail to specify the Precision and NumericScale for the ADODB parameter.

In order to do this quickly, I've written a quick little Function that does it
Invoicing

Hi everybody, please help me

 I am writting an intergration application with Great Plains version 9.0 in c# .net. The risk factor is we dont have SOP and Recievable Sales invoice. How can i send an invoice to GP using invoicing option. expecting immediate response.....

Advanced Thanks

Rajesh

 

 

 
eConnect GP 2010 (v11) taSopMultiBin Error

Edit 9/17/15 View the main article for this error here 

Please help!  

Converted v10 SOP Invoice/Order Creation solution to GP2010 (v11) and am getting the following error: 

"Procedure or function 'taSopMultiBin' expects parameter '@I_vSOPNUMBE', which was not supplied."

Here is the xml:

 

<?xml version="1.0" encoding="utf-8" ?>
    <SOPTransactionType>
        <eConnectProcessInfo xsi:nil="true"/>
        <taRequesterTrxDisabler_Items xsi:nil="true"/>
        <taUpdateCreateItemRcd xsi:nil="true"/>
        <taUpdateCreateCustomerRcd xsi:nil="true"/>
        <taCreateCustomerAddress_Items xsi:nil="true"/>
        <taSopSerial_Items xsi:nil="true"/>
        <taSopLotAuto_Items xsi:nil="true"/>
        <taSopLineIvcInsert_Items>
            <taSopLineIvcInsert>
                <SOPTYPE>2</SOPTYPE>
                <SOPNUMBE>ORDST2238</SOPNUMBE>
                <CUSTNMBR>AARONFIT0001</CUSTNMBR>
                <DOCDATE>10-27-2010</DOCDATE>
                <LOCNCODE>WAREHOUSE</LOCNCODE>
                <ITEMNMBR>CORDG</ITEMNMBR>
                <AutoAssignBin>0</AutoAssignBin>
                <QUANTITY>20.0</QUANTITY>
                <ITEMDESC>Green Cord</ITEMDESC>
                <LNITMSEQ>16384</LNITMSEQ>
                <DOCID>STDORD</DOCID>
                <ADDRESS1>One Microsoft Way</ADDRESS1>
                <CITY>Redmond</CITY>
                <SHIPMTHD>COURIER</SHIPMTHD>
                <AUTOALLOCATESERIAL>1</AUTOALLOCATESERIAL>
                <AUTOALLOCATELOT>1</AUTOALLOCATELOT>
                <ALLOCATE>1</ALLOCATE>
                <UpdateIfExists>1</UpdateIfExists>
                <DEFPRICING>1</DEFPRICING>
                <DEFEXTPRICE>1</DEFEXTPRICE>
                <UOFM>Each</UOFM>
            </taSopLineIvcInsert>
        </taSopLineIvcInsert_Items>
        <taSopLineIvcInsertComponent_Items xsi:nil="true"/>
        <taSopTrackingNum_Items xsi:nil="true"/>
        <taSopCommissions_Items xsi:nil="true"/>
        <taSopLineIvcTaxInsert_Items xsi:nil="true"/>
        <taCreateSopPaymentInsertRecord_Items xsi:nil="true"/>
        <taSopUserDefined xsi:nil="true"/>
        <taSopDistribution_Items xsi:nil="true"/>
        <taAnalyticsDistribution_Items xsi:nil="true"/>
        <taSopMultiBin_Items>
            <taSopMultiBin>
                <SOPNUMBE>ORDST2238</SOPNUMBE>
                <SOPTYPE>2</SOPTYPE>
                <ITEMNMBR>CORDG</ITEMNMBR>
                <LNITMSEQ>16384</LNITMSEQ>
                <BIN>AUTOCREATE</BIN>
                <UOFM>Each</UOFM>
                <QUANTITY>20.0</QUANTITY>
                <OverrideBin>1</OverrideBin>
            </taSopMultiBin>
            <taSopMultiBin xsi:nil="true"/>
        </taSopMultiBin_Items>
        <taSopHdrIvcInsert>
            <SOPTYPE>2</SOPTYPE>
            <DOCID>STDORD</DOCID>
            <SOPNUMBE>ORDST2238</SOPNUMBE>
            <TAXSCHID>USASTCITY-6*</TAXSCHID>
            <SHIPMTHD>COURIER</SHIPMTHD>
            <LOCNCODE>WAREHOUSE</LOCNCODE>
            <DOCDATE>10-27-2010</DOCDATE>
            <CUSTNMBR>AARONFIT0001</CUSTNMBR>
            <CUSTNAME>Aaron Fitz Electrical</CUSTNAME>
            <CSTPONBR>CPO1135</CSTPONBR>
            <ShipToName>PRIMARY</ShipToName>
            <ADDRESS1>One Microsoft Way</ADDRESS1>
            <CNTCPRSN>Bob Fitz</CNTCPRSN>
            <FAXNUMBR>31255501010000</FAXNUMBR>
            <CITY>Redmond</CITY>
            <STATE>WA</STATE>
            <ZIPCODE>98052-6399</ZIPCODE>
            <COUNTRY>USA</COUNTRY>
            <BACHNUMB>AUG31</BACHNUMB>
            <PYMTRMID>Net 30</PYMTRMID>
            <CREATETAXES>1</CREATETAXES>
            <DEFTAXSCHDS>1</DEFTAXSCHDS>
            <ReqShipDate>11/13/2010</ReqShipDate>
            <UpdateExisting>1</UpdateExisting>
            <DEFPRICING>1</DEFPRICING>
        </taSopHdrIvcInsert>
        <taSopToPopLink xsi:nil="true"/>
        <taSopUpdateCreateProcessHold xsi:nil="true"/>
        <taCreateSOPTrackingInfo xsi:nil="true"/>
        <taMdaUpdate_Items xsi:nil="true"/>
    </SOPTransactionType>
</eConnect>

 
Edit several lines in scrolling window

 Hello

 I need to edit several lines in a scrolling window upon the user clicking a button. I can easily edit the current active line in the scrolling window  but i cannot edit the other lines.

 Is there a way for me to navigate among the lines in the scrolling window and edit them one by one?

 

Thanks

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Anchored Marriage
3