DynDeveloper.com

This is a function that returns the Receipts that are associated with a Payables document. 

The use of the function is demonstrated here http://dyndeveloper.com/ArticleView.aspx?ArticleID=1689

The requirement from the client was to get all payables documents, and link to receivers and POs where we could. The also wanted all the debit distributions. 

When including dists, you nave to understand that you'll get more than one line for each invoice at times. 

This view requires 4 helper functions:

ddf_Address

ddf_CommaSeparatedPOs

ddf_CommaSeparatedReceipts

ddf_Phone

Dynamics 2016 has an object called Dynamics.Forms.SyVisualStudioHelper

I don't know a lot about it, but I can see that it allows you to pop up a message box. 

The kicker is that this message box works in the web client, too

Our SOP history table has 10 years worth of history in it. We want to remove this history and keep only 3 years of history. How do we do this?

Also after removing from history, what happens to the data? Is it lost permanently? How do we save the data in case some one wants to refer to it at a later stage?

Tengo unas tablas creadas por mi, en la misma base de datos de GP, en SQL server. Necesito hacer un Smartlist de estas tablas, pero las mismas no aparecen en la lista del Generador de Smarlist. entiendo que esto se debe a que no son tablas propias de GP.

¿Existe algún procedimiento almacenado o código que me permita hacer que sean reconocidas por el  generador de smarList?

I have some tables created by me, in the same GP database, in SQL server. I need to make a Smartlist of these tables, but they do not appear in the Smarlist Generator list. I understand that this is because they are not GP own tables.
Is there any stored procedure or code that allows me to make them recognized by the smarList generator?

Hi all,

Actual questions in bold.  My vp wants a better solution to putting scanned invoices into the system.   currently, they get the invoice, get up, go scan, get the email from the copier, take the pdf out and place into a directory somewhere, attach to notes in GP, and hope nothing got missed along the way (especially from our Africa and Mexico offices)

so I wrote a quick little app that will handle the scanning and attaching, eliminating a few steps.  my app does scan, allows naming right there.  my next step is getting it into gp based on the vendor or  invoice number. 

the tables are CO001xx and CO40100(setup).   However, as I looked at the setup windows for attachments: Microsoft Dynamics GP >> Tools >> Setup >> Company >> Document Attachment Setup, I see that nothing is filled out in this form.   so does that mean we are only using the old style OLE attachments?

I was talking to my boss (not knowing of the new attach system), that the only way for my scanner app to be of real use is to launch my app from within GP, grab a command-line argument, and do the work......BUT.....reading this article, http://www.encorebusiness.com/blog/dynamics-gp-document-attach-feature/, it says that the new attachments already support WIA scanners.

I guess I was chasing my tail for a week or so writing a scanning app that didn't need to be written?

Next question, if using the blob way (new way), where does the blob get stored?

THANKS!

Hi, my client is just setting up the ACH payments and they have around 80 vendors. They are looking for a way to integrated the ABA/Routing number, Bank Names & Account numbers into Great Plains using the integration manager but I do not see an option under the vendors.

Is there a way I can integrate vendors into GP with bank routing number & account number?

The version is 2013 R2

Thanks

Paul Chacko