DynDeveloper.com

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 = 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>

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.

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.

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.

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,

 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.

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?