Microsoft Dynamics Partners providing comparisons and opinions to professionals in the ERP/Accounting software selection process since 2009


Crestwood Associates

Dynamics GP and Forms Printer – it slices & it dices!

Email | Print

Dynamics GP and Forms PrinterEach organization has unique business processes, and modifying solutions to meet, scale, and automate those processes can be very satisfying wins for your organization. We had a rather unusual client condition come through that we were able to acclimate in Microsoft Dynamics GP with the help of Accountable Software’s Forms Printer application.

The Problem

A client in the philanthropic sector had an explicit need to automate email delivery of invoices, with a special requirement. Certain customers needed to have their invoices “split” and delivered separately, with certain charges distributed between documents or appearing only on special secondary invoices. However, due to limitations with the business workflow further upstream, existing integrations, and cash application, it wasn’t achievable to actually create the secondary invoices in Microsoft Dynamics GP. Crestwood Associates stepped in to help solve this problem and discovered an exceptional add-on solution: Forms Printer application from Accountable Software.

The Solution

Forms Printer is a document delivery tool that leverages SQL Server Reporting Services (SSRS) giving you complete control over the format of the email attachment and sophisticated delivery options within Dynamics GP as well.  It’s a seamless interaction yet offers the most flexibility of any tools in the market today.  By using Forms Printer, we were able query and deliver a batch of “virtual invoice” which met a sophisticated set of criteria including customer class and document type.

Dynamics GP Forms Printer

Here’s how it works.  When a batch of invoices is printed, Dynamics GP populates the SOP50200 and SOP50300 tables with invoice headers for the batch.  These tables are normally then used to generate the invoices.  With Forms Printer, we have the ability to manipulate this data before the invoices are actually printed, so instead of taking invoices directly from the SOP temp tables in Dynamics GP, we created our own temp table where we were able to split invoices according to very specific business logic requirements and deliver them as one, two, or three separate invoices / attachments to the client email.  This way, the process was completely automated and required no involvement on behalf of the AR user, and does not disrupt other business processes within the organization.

Using Dynamics GP and Forms Printer, we were able to control the presentation, the raw invoice data, and the delivery with an extreme level of configurability and detail.

Subscribe to our blog and get new articles right in your inbox, so you won’t miss future posts on Dynamics GP.

Ask This Expert a Question / Leave a Comment