DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In

Archives

 

Today I have a client that wants me to provide an incremented SOP Master Number. In the past, I've just written my own code to increment the SOP40100.NXTMSTNO field.

That's always seemed heavy handed to me, and I knew that there must be a native function to do it... so I went looking.

This article is a code example for how to call the taSopGetMasterNumber stored procedure and get an incremented number.   

Note:

As soon as I got this all documented, I went to install it at the client. Who didn't have eConnect. So... I had to revert to the stored proc method. I've included the full text of that proc at the bottom of the article.

This article will be listed in the SQL - Scripts specific to Dynamics menu

I've been coding eConnect for a while, and this one was hard. I wanted to be sure to save this for future use.

Because of its 'bolted on' nature, Analytical Accounting is often not straight forward.

This is a complete working example of a PM Transaction that uses AA.

Notes:

Not every line in the distribution needs AA; the AA lines need their own counter for that reason.

The DocType here for the AA is 0, not 1. That's in the documentation

Some errors that I got along the way:

An item with the same key has already been added

There are no distribution accounts linked to an Accounting Class.

The example below fixes those issues

 

I just finished a similar piece of code for PM. Here's the GL version - a GL Transaction with Analytical Accouting code. It took me quite a while to get the bugs out so this will be valuable in the future.

This article contains a complete working version of an eConnect GL transaction that has Binary Stream and Analytical Accounting code.

My company has a complicated commission structure.  Commission calculation is based on these factors:
  • Has the Invoice been paid in full
  • Which Rep firm made the sale
  • For each line item, is it a resale item or an item we manufacture
  • Is the customer one of those where a special rate applies

For years we have been doing these calculations semi-manually, by running smart lists, importing the results into Excel and manipulating the data.  Eventually as we added Reps, the task became too intensive, so we needed an automated solution.  The solution is summarized in this article.

Hi!

Is there any way to implement GP's Stock Count Entry window using eConnect?

If so, could you please guide me through? In the case that eConnect did not support this functionality, how would it be to insert directly into GP's tables?


Regards,

Santiago

I have a customer that is complening about how Dynamics GP 10 is very slow in posting and creating the following reports:

  • Receivables Distribution History - It takes apox 10 minutes to display
  • Historical Stock Status - It takes apox 15 minutes to display

They have two server:

  • One for SQL SERVER 2008 r2, 4HD SAS, 16GB RAM,
  • Another server with VMWARE using terminal server for 10 HP thin clients for Dynamics GP 10 Client
    • This server has 12gb ram, 4 HD SAS

I did the following process:

  •  In SQL I did a Rebuild Index and also a Shrink
  • In Dynamics GP I did a Check Links and Reconcile in all the modules.

Please advice me what other process can I do to speed Dynamics GP10.

Thank You

Hi,

Is eConnect 11 compatible with GP10?

We've always tested our integration against GP2010 hence using eConnect 11.

We'd like to know if our integration will work with GP10. I mean using eConnect 11's dlls against a GP10 installation.


Regards,

I am a newbie to GP10, but my company needed a better way to calculate commissions.  Our commission calculations includes different rates by product, salesperson and customer.  We were doing this pretty much manually by extracting data to Excel and working on it there.

 My solution involved using a Python script to fetch Sql Server data from three tables.   Doing the calculations, and then using report Lab to produce PDFs that could be sent to the Salespersons.  I am willing to share my solution if there would be any interest.  For example, here is my SQL select statement:

 sql = "select RM20101.CUSTNMBR, RM20101.DOCNUMBR, RM20101.DOCDATE, RM20101.DINVPDOF, RM20101.SLSAMNT," \
   + " RM00101.CUSTNAME, RM00101.SLPRSNID," \
   + " SOPNUMBE, ITEMNMBR, ITEMDESC, ITEMDESC, XTNDPRCE, INVINDX" \
   + " from dbo.RM20101" \
   + " LEFT OUTER JOIN RM00101 on RM20101.CUSTNMBR = RM00101.CUSTNMBR" \
   + " LEFT OUTER JOIN SOP30300 ON SOPNUMBE = RM20101.DOCNUMBR" \
   + " WHERE YEAR(DINVPDOF) = %d AND MONTH(DINVPDOF) = %d ORDER BY SLPRSNID, RM20101.DOCNUMBR" % (Year, Month)

 

I wonder if anyone else is using Python to generate custom reports when Smart Lists is not up to the job.  On the other hand, perhaps I will look silly once someone points out a much easier way to do this.

Robert

Hi everyone.

Today we are going Live with an eConnect integration and we are experiencing a very strange issue.

The Event Log gets filled in a matter of minutes with hundreds of eConnect Warnings saying something about using a Distributed Transaction ("Distributed transaction was used"). It also says something about a setting I should change in order to stop receiving this Warning:


The following information is part of the event: Distributed Transaction was used

This could be caused by new connection strings used within each xml document, but reusing the base transaction scope. 

Configuration Setting 'ReuseBaseTransaction' is by default FALSE. Remove this configuration setting, or set it to FALSE if this was not the expected behavior.


I searched eConnect's .config file and found no trace of this setting.

Due to the amount of warnings (300) that are being logged for every transaction, the log fills up quickly and eConnect stops working.


Has anyone experienced something like this?


Regards,

Santiago

Using eConnect, I have an integration that works in one DB but not another. The error that I'm getting is

SQL Exception Thrown in the GetNextNumber method.

Has anyone seen this before?

I'm trying to implement a Multiple Users Approving Purchase Order process in Dynamic GP10 but GP will approve only one user, how can I do this? does anyone has a presentation of this in power point?

 

Thank You

When I enter a note and save I get the message "The note ID has not been set". Anyone seen this before?