DynDeveloper.com

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

• 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.

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

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

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?