DynDeveloper.com

Hi !  Long time no talk...

 Well, I'm back on ANOTHER eConnect project.  This time it's eConnect version 8 (for Dyn GP 8).  I'm creating a Windows Service that polls an "export queue" table for invoices and repackaging the invoice to send it out via EDI.

 I've only ever used eConnect 9 and up but I assumed that the versions were similar.  Here's what I'm doing and where it's breaking...

1. My project is in VS2005.
2. I imported and am referencing Microsoft.GreatPlains.eConnect, MiscRoutines, and Serialization8 dll's.
3. I had to reference an "old" version of System.EnterpriseServices because eConnect v8 uses it.
4. For testing, I'm trying the following:

Dim serializer As New XmlSerializer(GetType(eConnectType))
Dim eConnect As New eConnectType()
Dim eConnectouttype As New RQeConnectOutType()
Dim eConnectOut As New eConnectOut()
Dim entrypoint As New eConnectMethods
Dim requesterDoc As String = String.Empty
Dim sConnectionString As String = GetGPConnectString()
With eConnectOut
    .DOCTYPE = "Sales_Transaction"
    .OUTPUTTYPE = 1
    .INDEX1FROM = "INV92029"
    .INDEX1TO = "INV92029"
    .FORLIST = 1
End With
...

My code is failing on the bolded line (Dim entrypoint As New eConnectMethods) with the following exception: "The system cannot find the file specified. (Exception from HRESULT: 0x80070002)".  Here's the stack trace:

I cannot figure out why it would be failing when dimming Microsoft.GreatPlains.eConnect.eConnectMethods.  All of the references and dll's are in place.  Have you seen this before?  Your insight will be greatly appreciated.  Thanks!

Joe Cogan
joecogan@adelphia.net
c:  216.288.1488

Hi All,

When am doing an entry for distribution via eConnect code the Debit entry is going as double.

Code Example:

taPMDistribution_ItemsTaPMDistribution NonPrjDisDebit = new taPMDistribution_ItemsTaPMDistribution();

taPMDistribution_ItemsTaPMDistribution[ NonProjDis = new taPMDistribution_ItemsTaPMDistribution[1];

NonPrjDisDebit.VENDORID = "00011";

NonPrjDisDebit.ACTNUMST = "39701-50";

PMHeader.VCHNUMWK = "10010";

PMHeader.DUEDATE = "06/11/2008";

PMHeader.VADDCDPR = "PRIMARY";

PMHeader.CHRGAMNT = 70.25m;

This code is working fine but only problem is when i check in distribution amount Debit entry is showing as 140.5 $ which id double. what could the reason?

If anyone has faced the same please reply.

Thanks

Arvind 

I have been asked to get the customer balance and the last payments of a customer for a particular month, so I don't think I can use the values in rm00103.  I guess what I'm wanting is a way to say give me the sum of the payments for the month of May, and the previous balance at the end of May.  Is this possible?

 Thanks,

Brad

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

I'm trying to post a return through eConnect, but I receive the following errors:

Error Number = 1526  Stored Procedure taSopSerial  Error Description = The Serial Number has already been sold - please choose another Serial Number

Error Number = 2905  Stored Procedure taSopSerial  Error Description = Qty fulfilled can not exceed qty allocated

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

Error Number = 1532  Stored Procedure taSopSerial  Error Description = The Serial Number (SERLNMBR) has already been selected for the entered item

Not really sure what to make of the errors.  The first error mentions that the serial has been sold.  This is true, but it is being returned so I don't see how that is relevant.  As for the quantity, I specified in GP that one item would be returned, and specified the serial number.  Only one item is being returned, and the serial number in the taSopSerial matches the serial specified on the return in GP.  The following is the XML that is being sent up: