GP Quick Attach

Next up for release is my “Quick Attach” feature. This was simply driven by laziness as people disliked having to open up so many windows just to attach one document. This adds the attach feature to the window you are currently working in.

Prerequisites: This assumes you are on at least 2013 R2 and are using the new Document Attach feature rather than the old OLE notes version. The new version stores the actual files in the SQL database rather than references a shared folder.

Installation: Copy the dll into your Microsoft Dynamics Installation folder’s Add-in folder. Restart GP

Use: Quick attach can be accessed from the following windows using the “Additional” menu that should appear on the toolbar if properly installed.

  • GL Transaction Entry
  • GL Journal Entry Inquiry
  • Payables Transaction Entry
  • Payables Transaction Entry Zoom
  • Sales Entry
  • Sales Inquiry

QuickAttach

Download: GPQuickAttach.dll (Version 1.0.5578.18959)

The way I coded the add-in makes it extremely easy to add to a new window. For me, it just takes one line of code to add quick attach to a new window so if others want it on other windows, comment below and I’ll try to update it.

Enjoy,
~James

Disclaimer: I am very much an amateur programmer. I have never taken an official Microsoft course. I cannot guarantee any code/program that I provide as I only have the ability to test my work on a small sample set. Users accept all the risk of using anything I provide and are encouraged to thoroughly test in a dedicated test environment before moving to production. Files I provide are free for use and are not to be resold. By using my files you agree to not hold me liable for any damages caused by said files.

Hello world!

I would consider this my first leap into the world of blogging. I am planning to use this as a platform to share my development work with others. Over the past few weeks I have taught myself the Microsoft Dynamics GP SDK to fill the gaps that 2013 R2 has for my employer. After having nothing but glowing responses about how much easier I made everyone’s lives, I decided that I wanted to share my work to others for free.

Features that I have developed and plan to release in the near future:

Paste Distribution:
Anyone who has worked with 2013 R2 has probably quickly learnt the limitations of the built-in Paste button. It ONLY works for non-intercompany general journal entries. After finding and reading Mohammad R. Daoud’s post: Practical Example on Dynamics Continuum Integration Library: GL Transaction Entry Integration I managed to easily expand out the paste abilities. I have added paste to the following windows:

-Payables Transaction Entry
-Sales Transaction Entry
-Financial Transaction Entry

Multi-currency and Intercompany are supported for all windows listed and since I use Sanscript/Continuum to fill the fields, GP still validates all information that gets entered (i.e. Checks if account exists).

Quick Attach:

I am a very lazy person. If I can find a way to reduce the steps I need to take by even one step, I will write code to do just that. With Document Attach 2.0 that was introduced with R2, more coworkers are finally starting to attach files to items in GP. Typically that involves clicking on the piece of paper icon which brings up the OLE note window, then clicking on the paper clip, clicking on attach, selecting your file, and closing back out until you are back at your original screen. Instead, I have written code that is accessible from the toolbar that directly opens an Open File Dialog window and attaches the file you select, all from the current window.

Batch Attach:

Integration Manager for Dynamics GP allows accounting technicians to batch upload invoices into GP. What happens when you then tell that technician he/she needs to attach the PDF of the invoice for all 50 invoices he/she just integrated? Complaints is what. Recycling a lot of the code I used for Quick Attach, I wrote a procedure that takes in Vendor IDs, Document Numbers, and the file paths as parameters and navigates to the document numbers and attaches the files given. This makes attaching 30 PDFs to 30 different invoices a couple second process.

I hope to have my code ready for public release soon so stay tuned. In the meantime, if anyone has a suggestion or idea for a future feature, please do not hesitate to comment or message me and I will see what is possible.

~James

Disclaimer: I am very much an amateur programmer. I have never taken an official Microsoft course. I cannot guarantee any code/program that I provide as I only have the ability to test my work on a small sample set. Users accept all the risk of using anything I provide and are encouraged to thoroughly test in a dedicated test environment before moving to production. Files I provide are free for use and are not to be resold. By using my files you agree to not hold me liable for any damages caused by said files.