DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In

Archives

 

This is not ground breaking code, it's kind of mundane. But it took me 3 hours to get it all working; I'm going to blog it so I don't have to do it again.

This article shows a SQL script and a DOS batch file that can be used to backup an instance of SQL Express, and then to delete files older than x days.

 

This short article will cover the steps needed to upgrade and existing eConnect app to GP2015

This article will be the overview for the process of installing Service Based Architecture for Dynamics GP. There are several steps, we'll break them up to make it easier to understand. For an overview of all the steps, look here

This short article exposes the exposed endpoints in Service Based Architecture

This article will walk you through creating a Self Signed Certificate in IIS 8. This certificate will be necessary to install Dynamics GP Web Components

Installing Service Based Architecture for Dynamics GP is a series of steps that need to be coordinated. Be sure that you're using our guide located here

 

This article walks you through installing the Dynamics GP Web Components on a single machine.

Installing Service Based Architecture for Dynamics GP is a series of steps that need to be coordinated. Be sure that you're using our guide located here

When I populate dropdownlists, I frequently want to add a new row at the top. I've figured out that you can easily add one at the bottom with DataTable.Rows.Add(), but that's... not elegant. This article is just a few lines of code that shows how to add one at the top.

Why bother blogging such a simple piece of code?

RAD.

I want to code quickly and efficiently and I can do that best if I have all the code samples that I needs at my fingertips instead of having to wade through endless blog entries. (some of which are innacurate)

Are you using the menus? Any subjects we can add? Tutorials

When trying to import a package file into Dynamics GP 2015, I get this error:

You do not have sufficient privileges on this system to modify the VBA project

Help?

I am trying to create a Project Costing Report using Project Accounting tables.  It appears I am missing price changes (between the receiving of the material and the invoice), project add-ons, etc...  Looking at the combined history table, it looks like table "PA01001" has this information.   

My question is regarding the linking to this table.  Have any of you used this table and what field are you joining to? 

Thank you,

Regards,

Tom

 

QUE DEBO HACER PARA QUE LOS PRESENTE COMO UNA SOLA LISTA DE DATOS.. 

 

 

I'm having an issue in VBA for GP 2015. My code works great on GP2010 however does not on GP2015. I went through and debugged the code and it looks like the connection to sql is not being made. The specific line of code that returns “Nothing” and I believe the cause of the trouble is UserInfoGet.CreateADOConnection. I did check the references but I do not know if maybe there is a reference needed for 2015 that was not needed in 2010? Or do you know of any change in 2015 that would not allow this connection? Can you help?

Hi there,

i've been trying to retrieve the smartconnect web service URL for the Excel templates after smartconnect install (web services and windows services included).

Going into IIS manager (we are on 6), the websites folder does not contain the Smartconnect website. 

Did i forget something?

thx.

TY.

Error: Duplicate Order

recien he instalado GP 10.0 en un computador con sistema operativo windows 8.1 y el Smarlist no me permite exportar a Excel. La vercion de OFFICE instalada es la 2013

 

I recently installed GP 10.0 on a computer with windows 8.1 operating system and Smarlist not allow me to export to Excel. The vercion is installed OFFICE 2013

Hi, I'm trying to join cm20200 with gl20000. I need to see which checkbook entries are missing from the GL cash account. I can get close, but I keep running into non unique fields to join on. I've used case statements to try and cut the data differently. They help, but generally lead to a one to many. Any suggestions on how to trace an entry from cm20200 to gl20000 that will cover all the different types of cm20200 possibilities?

 

tthanks!

We are trying to implement an MES system and integrate to GP.  We need to be able to write punches back to GP.  As we understand it, we need to write this information back to the SF010500 table where the configured ADC will then process it.  We understand all of the fields required excepting  DATAENTRYTYPEADC_I  what are the possible values this field need to contain, and does ADCDEVICEID_I need to contain anything?
Saludos a todos.
Necesito saber si GP 10.0 puede trabajar con base de datos distribuida. Para ser más explícito: con replicación de base de datos. Por ejemplo, Podría tener GP10.0 en una tienda corriendo sobre su propia base de datos y en otra tienda, de la misma compañía tener igualmente GP 10.0  corriendo sobre su propia base de datos; pero los datos entre los dos servidores SQL estarían sincronizados online, si uno de servidores SQL se daña o pierde conexión con su GP,  que este GP pueda  funcionar sin interrupción apoyado en el otro servidor SQL. 

Esta consulta es para trabajar una tarea de una asignatura de la maestría en conciencias computacionales que estoy tomando en la Universidad Tecnológica de Panamá. Requiero montar este escenario con tres servidores y el hecho de que quiero usar GP es porque cuento con las herramientas para instalarlo, estaría trabajando con la base de datos de ejemplo.

Les agradezco su colaboración.
Eric

Greetings to all.
I need to know if GP 10.0 can work with distributed database. To elaborate: with database replication. For example, you could have GP10.0 in a store running on its own database and another shop, the same company also have GP 10.0 running on its own database; but data between two SQL servers would be synchronized online, if a SQL server is damaged or lost connection with your GP, this GP can operate continuously supported in the other SQL server.

This consultation is to work a task of a subject of Master in computational conscience I am taking at the Technological University of Panama. I require mount this scenario with three servers and that is because I want to use GP tale with tools to install, would be working with the database instance.

We appreciate your cooperation.

My customer wants all the quantities we import to go into QTYTBAOR so they do not affect inventory.  They adjust this field at the time they process & ship.

 

I tried setting QTYTBAOR = to the quantity ordered but I’m getting the eConnect error below.  I was able to get the order in when I set DEFPRICING = 1 but it no longer used the correct price level (PRCLEVEL) and it seemed to think there were 2 items instead of 1.  I tried removing the QUANITY field but that’s mandatory.  Can you help me understand what combination of values I need to set to make this work?  Thank you!

 

 

 

Error Number = 299  Stored Procedure= taSopLineIvcInsert  Error Description = Unit Price calculation does not match out to Extended price

Node Identifier Parameters: taSopLineIvcInsert

SOPNUMBE = ORD0046790

SOPTYPE = 2

LNITMSEQ = 16384

Related Error Code Parameters for Node : taSopLineIvcInsert

SOPTYPE = 2

QUANTITY = 1.00

UNITPRCE = 15.17

MRKDNAMT = Note: This parameter was not passed in, no value for the parameter will be returned.

XTNDPRCE = 15.17

 

 

<taSopLineIvcInsert>

  <SOPTYPE>2</SOPTYPE>

  <CUSTNMBR>XXXX</CUSTNMBR>

  <DOCDATE>03/26/2015</DOCDATE>

  <ITEMNMBR>XXXX</ITEMNMBR>

  <PRCLEVEL>XXXX</PRCLEVEL>

  <UNITPRCE>15.17</UNITPRCE>

  <XTNDPRCE>15.17</XTNDPRCE>

  <QUANTITY>1.00</QUANTITY>

  <QTYTBAOR>1.00</QTYTBAOR>

  <LNITMSEQ>16384</LNITMSEQ>

  <DOCID>STDORD</DOCID>

  <PRSTADCD>XXXX</PRSTADCD>

  <ReqShipDate>03/13/2015</ReqShipDate>

  <QTYFULFI>0</QTYFULFI>

  <QTYFULFISpecified>True</QTYFULFISpecified>

  <UOFM>Case</UOFM>

  <USRDEFND3>00003</USRDEFND3>

  <SOPNUMBE>ORD0046790</SOPNUMBE>

</taSopLineIvcInsert>

Hi, 

I have been asked to make a some Journal Entries into Great Plains problematically. I am a .net developer who programs in C#. What tools do I need to accomplish this? I have been reading about EConnect 2013 but do not see any way to download this product. 

Some insight into this would be most appreciated.

Thanks,

Scott Kay

byteguy@bellsouth.net

 

I am seeing a scenario where we are getting "001" appended to the end of the document number.

Example:

Cm12345001 for a Sales Entry (BCHSOURC)

Then we have a RM_Sales (BCHSOURC) with a document number Cm12345.

I google this and found some information that seemed to indicate that this is by design if there are 2 documents with the same doc number. I did not find anything in the GP help file.

Can anyone confirm that this is by design, or is there something else possibly incorrect?

We are using GP 2010