DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In

Archives

 

How to remove this warning in SOP and Invoicing:

Sales Order Processing and Invoicing modules are both installed. They do not share information. Transactions should be entered in one module only.

 

When using eConnect with your .NET application, you might want to use tracing to monitor the execution of your application.  The classes in the Microsoft.Dynamics.GP.eConnect namespace support .NET tracing.

 

This one is normally pretty easy to fix, you just... get the debits and credits to equal. But I ran into it today with an Integration Manager integration using eConnect and Analytical Accounting and the fix was not so intuitive. 

Exception message: Sql procedure error codes returned: Error Number = 944
Stored Procedure= taGLTransactionHeaderInsert
Error Description = Unbalanced journal entry, the credits do not equal the debits
Node Identifier Parameters: taGLTransactionHeaderInsert
BACHNUMB = BEGBAL JAN14 JRNENTRY = 457 REFRENCE = xx TRXDATE = 1/31/2014 TRXTYPE = 0

<taGLTransactionHeaderInsert>
    <BACHNUMB>BEGBAL JAN14</BACHNUMB>
    <JRNENTRY>457</JRNENTRY>
    <REFRENCE>xxx</REFRENCE>
    <TRXDATE>1/31/2014</TRXDATE>
    <RVRSNGDT></RVRSNGDT>
    <TRXTYPE>0</TRXTYPE>
    <SOURCDOC></SOURCDOC>
    <NOTETEXT></NOTETEXT>
    <Ledger_ID>1</Ledger_ID>
    <RequesterTrx>0</RequesterTrx>
</taGLTransactionHeaderInsert>

Stack Trace: at Microsoft.Dynamics.GP.eConnect.EntityMessageProcessor.ExecuteSqlCommands(XElement transactionNode, EntityMessage message) at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ProcessMessageImport(EntityMessage message) at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction) at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateEntity(String connectionString, String sXML) at Microsoft.Dynamics.GP.eConnect.Service.CreateEntity(String ConnectionString, String sXML)

Exception type: Microsoft.Dynamics.GP.eConnect.eConnectException
Exception message: Error Number = 944
Stored Procedure taGLTransactionHeaderInsert
Error Description = Unbalanced journal entry, the credits do not equal the debits

This article details a complete, running code example for the eConnect IVInventoryTransactionType.

This code, and all our other eConnect examples, is on the eConnect menu.

This article contains notes about updating SOP documents. This article, and all our eConnect content, is contained on the eConnect menu

This code example is a complete running code example for the IVInventoryTransactionType eConnect integration.

All the rest of our code examples can be found on the eConnect menu.

Here are the basic steps for an Inventory Stock Count:

This article shows how to save document attachments from a Sales Document to a temp file.  

Just a sample of some of my code, I am not a trained programmer but this works.

 

 

This is a particularly nice piece of user-submitted code that shows not only how to achieve a goal, but how to use the 'tables' in VS Tools. Great read!

 

So, I'm trying to connect to a remote install of Web Services for Dynamics GP and I get this:

The caller was not authenticated by the service.
The request for security token could not be satisfied because authentication failed.

Grrr.  

This article shows how to connect to Web Services for Dynamics GP and pass credentials. The example uses .NET code.

 

This is the class that we use for common code in our .NET projects. Nothing special going on here. Kind of boring, actually. But we need to post it because some of it is used in the other examples

Our eConnect examples use custom tables, this script will create the tables for you

This is fully functioning example code for the eConnect POPReceivingsType schema

 

This is sample XML for the eConnect POPReceivingsType schema

This is an example of the XML for the POPReceivingsType schema showing a lotted item and sending unit cost

 

This is a complete code example for the POPReceivingsType schema, showing how to receive lotted items.

 

Error message when you try to export a package file: "One or more components cannot be exported because they belong to a VBA project that is locked"

When you try to export a package file, you receive the following error message:

One or more components cannot be exported because they belong to a VBA project that is locked

Edit: well, apparently all my writeup for this was deleted when I submitted the message... I'm rewriting it now

Here's the Scenario:

Website takes invoices from GP web services, allows the user to make a payment and then transmit the payment information for that invoice back to GP. I'm getting validation errors trying to do this.

Here's the actual error from Web Services Exceptions Console:

A validation exception has occurred.
Validation Errors:
- If AllocateLotBehavior equals 0 the taSopLotAuto node should not be called.
- A validation error has occurred.

Here's the XML data transferred via Web Services:

invoice val error.txt

Here's the code in C#:

GP 10.0, I need SQL tables linking me checks paid to suppliers with the purchase order by which the purchase was handled.

Our system is currently configured to pull the A/P offset accounts based on the vendor type.  Is it possible to establish offsets based on the GL expense code?

Is there a screen or table where the output options can be set for the reports created by the PA Reconcile Utility?  I'm trying to close years of open projects, and while it's only a time-wasting nuisance, it would be nice to be able to set these ahead of time.

To clarify a bit more, I want all of the results to always print to the screen.

Thanks ahead of time.

Using econnect out of the box. Requester set up and transactions available in SQL "eConnect_Out". But they do not make it to the outgoing queue.

System.Messaging
The queue does not exist or you do not have sufficient permissions to perform the operation.
System.Messaging.MessageQueueException: The queue does not exist or you do not have sufficient permissions to perform the operation.
   at System.Messaging.MessageQueue.ResolveFormatNameFromQueuePath(String queuePath, Boolean throwException)
   at System.Messaging.MessageQueue.get_FormatName()
   at System.Messaging.MessageQueue.SendInternal(Object obj, MessageQueueTransaction internalTransaction, MessageQueueTransactionType transactionType)
   at System.Messaging.MessageQueue.Send(Object obj, String label, MessageQueueTransaction transaction, MessageQueueTransactionType transactionType)
   at System.Messaging.MessageQueue.Send(Object obj, String label, MessageQueueTransaction transaction)
   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)private$\econnect_outgoingCTL

 

Hi - is it possible to install eConnect 10 to a GP 10 environment?  We only want the SQL objects and nothing else.

We tried to move them from one DB to another but the procs are encrypted.    Any ideas?

Thanks!

~Mark

-IEdit 9/17/15 View the main article for this error here
I
I  I am trying to receive a PO line with a lot and its giving the subject error. Any help would be appreciated, as far as I can see the qty numbers are the same. A bit of an update on this, this is currently failing on previously tested receipt lines and lots that had been created.

 

TThanks

 
<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
- <POPReceivingsType>
  <eConnectProcessInfo xsi:nil="true" />
  <taRequesterTrxDisabler_Items xsi:nil="true" />
  <taUpdateCreateItemRcd xsi:nil="true" />
  <taUpdateCreateVendorRcd xsi:nil="true" />
  <taCreateVendorAddress_Items xsi:nil="true" />
- <taPopRcptLotInsert_Items>
- <taPopRcptLotInsert>
  <POPRCTNM>RCT20410</POPRCTNM>
  <ITEMNMBR>LICLMPP3O</ITEMNMBR>
  <SERLTNUM>cil123</SERLTNUM>
  <SERLTQTY>8.00000</SERLTQTY>
  <RCPTLNNM>32768</RCPTLNNM>
  <LOCNCODE>MAIN00</LOCNCODE>
  <EXPNDATE>5/26/2016</EXPNDATE>
  <MFGDATE>5/26/2015</MFGDATE>
  </taPopRcptLotInsert>
  </taPopRcptLotInsert_Items>
  <taPopRcptSerialInsert_Items xsi:nil="true" />
- <taPopRcptLineInsert_Items>
- <taPopRcptLineInsert>
  <POPTYPE>1</POPTYPE>
  <POPRCTNM>RCT20410</POPRCTNM>
  <PONUMBER>011044</PONUMBER>
  <ITEMNMBR>LICLMPP3O</ITEMNMBR>
  <ITEMDESC>GONE NUTS - CILANTRO LIME MOJO PISTACHIO & PEPITAS - LIVING INTENTIONS - 3 OZ</ITEMDESC>
  <VENDORID>LIVING</VENDORID>
  <QTYSHPPD>8.00000</QTYSHPPD>
  <AUTOCOST>1</AUTOCOST>
  <LOCNCODE>MAIN00</LOCNCODE>
  <POLNENUM>32768</POLNENUM>
  <receiptdate>5/26/2015</receiptdate>
  </taPopRcptLineInsert>
  </taPopRcptLineInsert_Items>
  <taPopRcptMultiBin_Items xsi:nil="true" />
  <taPopRcptLineTaxInsert_Items xsi:nil="true" />
  <taPopRctUserDefined xsi:nil="true" />
  <taPopDistribution_Items xsi:nil="true" />
  <taAnalyticsDistribution_Items xsi:nil="true" />
- <taPopRcptHdrInsert>
  <POPRCTNM>RCT20410</POPRCTNM>
  <POPTYPE>1</POPTYPE>
  <receiptdate>5/26/2015</receiptdate>
  <BACHNUMB>5262015110717TBOJ</BACHNUMB>
  <VENDORID>LIVING</VENDORID>
  </taPopRcptHdrInsert>
  <taMdaUpdate_Items xsi:nil="true" />
  </POPReceivingsType>
  </eConnect>

I have been trying to find the property to use when naming a ship to address for a customer when using the dynamics GP web service to export my customers to GP from the application I am working on. I have had nothing but trouble finding answers for any kind of c# coding to GP web service type dev. Here is a picture of the field I am trying to fill in.

http://i.stack.imgur.com/xa0P1.png

The highlighted box is the one I cannot get to display correctly, it looks like it is just filling in the customer name. But I need it to display the name of the ship to address for this customer. Can anyone help me out here with a property name I can use to fill in this field?

When our comments are being passed into GP using web services for a sales invoice all of the line breaks/returns are either being removed or not recognized.. Does anyone have some info on what line break character GP will recognize, so that the formatting of the comments being passed in will be retained?