DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In

Archives

 

If you leave a field blank in an eConnect update, nothing will change on in the data. So, how would you blank the field?

This idea came from David Musgrave's blog

http://blogs.msdn.com/b/developingfordynamicsgp/archive/2011/08/26/quick-tip-using-econnect-to-update-customer-or-vendor-addresses-with-a-blank-address-line-3.aspx

I'm copying the substance of it here so that I won't lose it. David's article is much better than mine <smiles>

 

 


 

{System.Exception: Sql procedure error codes returned:

Error Number = 11984 Stored Procedure= taSopLineIvcInsert Error Description = CUSTNMBR does not exist on current work SOP document
Node Identifier Parameters: taSopLineIvcInsert
SOPNUMBE = STD00581876
SOPTYPE = 2
CUSTNMBR = 2090
Related Error Code Parameters for Node : taSopLineIvcInsert
UpdateIfExists = 1


<taSopLineIvcInsert>
<SOPTYPE>2</SOPTYPE>
<SOPNUMBE>STD00581876 </SOPNUMBE>
<CUSTNMBR>2090 </CUSTNMBR>
<DOCDATE>3/5/2015</DOCDATE>
<LOCNCODE>003 </LOCNCODE>
<ITEMNMBR>zzzzzzz</ITEMNMBR>
<UNITPRCE>0.2652</UNITPRCE>
<XTNDPRCE>243.98</XTNDPRCE>
<QUANTITY>920</QUANTITY>
<PRCLEVEL>42090 </PRCLEVEL>
<UpdateIfExists>1</UpdateIfExists>
<UOFM>Each </UOFM>
<USRDEFND1>1687891</USRDEFND1>
</taSopLineIvcInsert>

  

 

{System.Exception: Sql procedure error codes returned:

Error Number = 4647 Stored Procedure= taSopLineIvcInsert Error Description = Decimal Places passed in on XTNDPRCE does not match setup
Node Identifier Parameters: taSopLineIvcInsert
SOPNUMBE = STD00581876
SOPTYPE = 2
Related Error Code Parameters for Node : taSopLineIvcInsert
XTNDPRCE = 243.9840


<taSopLineIvcInsert>
<SOPTYPE>2</SOPTYPE>
<SOPNUMBE>STD00581876 </SOPNUMBE>
<CUSTNMBR>2090 </CUSTNMBR>
<DOCDATE>3/5/2015</DOCDATE>
<LOCNCODE>003 </LOCNCODE>
<ITEMNMBR>GENSH~CORTEZ~QMROME </ITEMNMBR>
<UNITPRCE>0.2652</UNITPRCE>
<XTNDPRCE>243.9840</XTNDPRCE>
<QUANTITY>920</QUANTITY>
<PRCLEVEL>42090 </PRCLEVEL>
<UpdateIfExists>1</UpdateIfExists>
<UOFM>Each </UOFM>
<USRDEFND1>1687891</USRDEFND1>
</taSopLineIvcInsert>


 

Sql procedure error codes returned:

Error Number = 3566 Stored Procedure= taSopLineDelete Error Description = Required input variable DeleteType is invalid
Node Identifier Parameters: taSopLineDelete
SOPNUMBE = STD00585338
SOPTYPE = 2
ITEMNMBR = testitem    
LNITMSEQ = 147456
Related Error Code Parameters for Node : taSopLineDelete
DeleteType = 0


<taSopLineDelete>
<SOPTYPE>2</SOPTYPE>
<SOPNUMBE>STD00585338 </SOPNUMBE>
<LNITMSEQ>147456</LNITMSEQ>
<ITEMNMBR>testitem </ITEMNMBR>
<DeleteType>0</DeleteType>
</taSopLineDelete>



 
Database Back Up step by step instructions
Restore Database step by step instruction

This article discusses the following error 

The source was not found, but some or all event logs could not be searched. To create the source, you need permission to read all event logs to make sure that the new source name is unique. Inaccessible logs: Security.


 
2008 Database Back Up step by step instructions
2008 Restore Database to another database step by step instruction

During the install for the web client, we received the following error:

The host name cannot contain special characters such as an asterisk

The article discusses the resolution


 

We have an existing eConnect AP integration that pulls data from a .csv file from our invoice system.

This error appears to have only started a week back. Basically there is no pattern it can be the 411th line i a 1200 line file or the 40th line in a file.

I am not seeing any logs to determine why this is occurring. We re-imported the line that failed the other day and it integrated and created a batch no problem.

The source file has not changed, source file has the proper format, all accounts in GP are active ( or else they would all fail). Some specific error files are not even in the directory which is even more bizarre.

 

Currently eConnect runs every 15 minutes throughout the day using windows scheduler.

 

I am not sure what specifics I might provide to help resolve this.

Hi DynDeveloper community!

 

I'm getting an Error and I'm stuck.  Looking for anyone to share their experience.

I'm using eConnect to insert/update Credit Memos in GP.  I'm mapping to the taRMTRansaction and taRMDistrubtion stored procedures.

 I was planning on using the same stored procedures to send Credit Memo updates via eConnect, but I get an unexpected error as follows:

"Error Number = 190 Stored Procedure= taRMTransaction Error Description = Document number (DOCNUMBR) already exists"

In the microsoft documentation for the taRMTransaction node it indicates: "This node uses document exchange for updates. All existing values are overwritten with the value specified by the update document. If a field in the update is blank, the existing value is changed to be blank."

( See here: https://msdn.microsoft.com/en-us/library/jj193402.aspx)

 

I am mapping to the following elements:

RMDTYPAL

DOCNUMBR

DOCDATE

BACHNUMB

CUSTNMBR

DOCAMNT

SLSAMNT

CURNCYID

CREATEDIST

USRDEFND1

 

In other cases where I send SOP document updates I map to elements such as "Update if Exists" which is what I've seen in the taSopHdrIvcInsert and taSopLineIvcInsert, but don't see anything on the taRMTransaction to facilitate or indicate an update which is why I think I'm getting this error. 

 

Any advice would be appreciated, I'm very stuck at the moment.

Thank you!

I need to create a new payables transaction based off of an XML created by another software. That XML file does not coincide with GP's schema. The only thing I can control about that file is whether there's one transaction per file or multiple. There are technically two files, the voucher header and the distribution line. All the necessary fields are in there but not named as GP would have it.

Question 1) How can I set the field values of the taPMTransactionInsert equal to the values of the source XML? I've looked into XML reader, but had difficulty assigning the value to variables from the source XML.

Question 2) Am I better off to request the files as individual transactions (1 XML per Voucher) or as a batch from the source software?

Question 3) Since the distributions are in a separate file, how do I keep them joined so that the header has the correct distributions attached to it? It appears both files share a common id number ,<ID>, but how can I be sure it pulls the correct file in the queue? ( I am assuming I would have a service set up to pull from a queue for processing, I haven't quite made it that far).

 I have manually inserted a transaction using static values and confirmed that it works including grabbing the next voucher. I have searched for two weeks for information relating to this but am not making any real progress. Any advice would be greatly appreciated. I am not very familiar with VB & .Net, I typically work with SQL, so please use simpler terms when possible.

 

Thank you.

 

We are seeking to streamline processing of vendor ach payments drafted from our account.  Specifically lease payments.  We have multiple vendors and a growing number of leases.  One vendor we have drafts 250+ invoices on the same day each month.   We are provided information of the lease number, invoice number and amount and an upload is prepared for all invoices.  Unfortunately, this vendor also has special payments that are keyed directly from invoices (advanced payments, property tax payments, end-of-lease expenses, etc.).  AP staff cannot simply select all open invoices and mark them as paid to post the bank draft.

 

Is there an upload that would allow both the posting of the invoice and the recording of a payment at the same time, or is there an upload process to mark payment of multiple invoices? Currently there can be multiple purchase distribution accounts per invoice, but only one AP trade account.

 

I’ve attached the upload provided last month.  The first tab comes from the vendor, MHR adds the coding.  Gail uploaded the .CSV tab last month then checked each invoice (269) as paid.Crown 9 14 2015 327217.12.xlsx

 

Currently we have an AP Invoice integration, however it is not meeting the specific requirements.

Utilizing Dynamics Accting, CRM and Wennsoft, we noticed there the ReportServer MDB file is utterly huge: about 25 GB and 45 GB on two servers. Ran a script showing the last run/execute time and there were only 200-400 out of 4,000 + reports which have ever been run.

Is it safe to remove these reports that have never been used ? Some of them look like they pertain to Dynamics AX, since they have AX in the folder name.

 

Thank you,

Is it ok for me to update the status of a PO via the following SQL Script:

UPDATE dbo.POP10100

SET POSTATUS = 2

WHERE .....

 Or does Great Plains need to do additional work when the PO is released which would require me to update the status via eConnect or some other way?

 I want import transactions into PM vouchers using eConnect. I have for simplicity divided this into 3 phases.

1) Generate an XML file in the format required by GP for each transaction. (Not sure on how this will work, hoping to get some help from the 3rd party software's developers to generate this custom file but I'm sure the 'next voucher number' will be an issue)

2) Save the XML to a folder or queue or something it can wait in until a service can pick it up

3) A service of some sort moves the file to eConnect where it is read and imported into GP.

Is this a fair (though simple) representation of this process? Am I missing some fundamental understanding of how eConnect works?

How can I get eConnect to automatically detect a file for import and import it? I have read the manual for eConnect, most of Web Serivce's manual and some of MSMQ's manual, but nothing shows me how to tie them all together. I even created a windows service (XMLwatcher) based on documentation from CustomerSource (it was meant for VS2005, I'm using 2015 so that could be part of it) however, the file just sits there (yes the service was started). I have sent a message to the MSMQ and I can see it in the control screen, in a queue but still, it just sits there.

I know generating the proper file will be trouble too but I don't even know what to do with the file once it is generated, and I need to start somewhere so I was trying to sort of reverse engineer to figure it out. Attached is a sample of the file I generated, I can include the code if necessary though I'm not sure that would help. If I'm not mistaken, the creation of the XML is just that and doesn't affect what happens to the XML file.

 

<?xml version="1.0" encoding="utf-8"?>
    <eConnectProcessInfo>"http://www.w3.org/2001/XMLSchema"></eConnectProcessInfo>
    <PMTransactionType>
        <eConnectProcessInfo xsi:nil="true"/>
        <taRequesterTrxDisabler_Items xsi:nil="true"/>
        <taUpdateCreateVendorRcd xsi:nil="true"/>
        <taCreateVendorAddress_Items xsi:nil="true"/>
        <taPMTransactionTaxInsert_Items xsi:nil="true"/>
        <taPMDistribution_Items xsi:nil="true"/>
        <taAnalyticsDistribution_Items xsi:nil="true"/>
        <taPMTransactionInsert>
            <BACHNUMB>TMS</BACHNUMB>
            <VCHNUMWK>00000000000185685</VCHNUMWK>
            <VENDORID>KENJAC</VENDORID>
            <DOCNUMBR>123TEST</DOCNUMBR>
            <DOCTYPE>1</DOCTYPE>
            <DOCAMNT>5</DOCAMNT>
            <DOCDATE>2015-10-01</DOCDATE>
            <PRCHAMNT>5</PRCHAMNT>
            <CHRGAMNT>5</CHRGAMNT>
            <TRXDSCRN>TEST</TRXDSCRN>
            <PORDNMBR>Test</PORDNMBR>
        </taPMTransactionInsert>
        <taMdaUpdate_Items xsi:nil="true"/>
    </PMTransactionType>
</eConnect>
 

 

 

I posted a few weeks back on a random econnect AP integration error #305, upon drilling down I found a Steve Endow article that was very accurate on the issue within eConnect ( design flaw). Logic needs to change on the stored procedure, however it is from SQL 08 and is encrypted, we either modify and lose our rollback ability or we decrypt, backup and then modify.

 

 Here is the article

 

http://dynamicsgpland.blogspot.com/2015/10/econnect-error-voucher-number-already.html

Any thoughts?

 

 

Mark

 

 

I am needing to copy an existing Great Plains database "HOLD" into a new GP database named "MEZZ"

The new GP database will be used to record the closing journal entries needed to present the new company owners, an opening Balance Sheet.

 I will only need the general ledger codes and respective fiscal year copied from HOLD to MEZZ. I will not need the AR/Customer cards or data, nor the AP/Vendor card information.

 

What is the easiest way for me to do this? Can eConnect be used to do this?

Hi, 

Is there a way to automatically load exchange rates from another system without using the IM?

Thanks.