top of page

Liaison Messenger EDD

Case Studies

SOLUTION:
The solution is rather basic.  Each month, the end-user wants to generate the company's Trial Balance, burst it by Department head and email it to the department manager.  As an added feature, the HR department wants an updated W-9, from each of the department's employees, every year.

Distribute Monthly Reports and

Conditional Attachments

CHALLENGE:
Customer wants to distribute Monthly Trial Balance to Dept Managers and occasionally include an extra attachment .

A Liaison Messenger EDD Script was created with two action lines.  The first line

sends a copy of the Trial balance to the respective department manager for any monthly Trial Balance

that happens to fall in the months from February to December.  The second line will send a copy of the Trial Balance

to the respective department manager with the Year-End Trial Balance and also include a PDF file of a blank, form-fill W-9 form.  On this script, depending on the month the Trial Balance is being generated, either Line 1 or Line 2 will execute. Both, will never run at the same time. Following the screenshot is how that is accomplished.

To create the condition of which line to execute, a filter is added under the Output tab to the respective lines.  In the example for Line 2, if the system date is equal to 1 (January) then this action will execute.   Line 1 has an almost identical filter except reversed; any month NOT equal to 1.  This is a very simple and basic filter criterium. To be more accurate, we would actually parse the date that appears on the respective "Trial Balance" report, as opposed to the System Date as shown, but this will give you an idea of how filters can be used.

Alright, after we created the filter condition for Line 2 we select the Assembly tab. Here, we choose the W-9.pdf file from our ad-hoc master file library and assign it as an attached Static File, keep the Assembly method as; Separate (don't merge the W-9 with the trial balance report). This way the department manager will receive one email with 2 separate attachments; Trial Balance and also the W-9 to be passed out to his/her employees.

Now, when someone prints the Trial Balance Report to the Liaison Messenger EDD printer driver, the Messenger EDD server will receive the print stream and immediately burst the report by Department, render it as a PDF and email the respective portion of the Trial Balance Report to the specific Department Manager.

And, if the Trial Balance happens to fall in the month of January, a separate W-9 PDF file will be attached with specific instructions in the body of the Email (didn't cover that here but you can easily have custom email verbiage/templates by Line), saying to distribute and collect an updated W-9 for/from each employee within their department.  As you can see any report, form, file, process can be automated, piggy-backed, converted, conditionally filtered, routed etc. with ... Liaison Messenger EDD.

All this was accomplished simply by printing to our printer driver. The complexity and distribution takes place on the Messenger EDD server without any user intervention...

Liaison Software Corporation
20321 Lake Forest Drive, Suite D7
Lake Forest, CA 92630
800.811.4618  - 714.543.9877  -  Fax:  714.543.0887

Get Directions

© 2024 Liaison Software Corporation.

ABOUT US

We're a company based in sunny Southern California, operating under private ownership. Since our inception in 1993, we've been at the forefront of innovation. Our journey began with the development of Liaison CRM, the first commercially available DOS-Windows cross-platform CRM system. Fast forward to today, and our main focus is on crafting Workflow Automation Solutions, with our flagship product, Liaison Messenger, leading the charge since its introduction in 1999.

Liaison Messenger EDD is a crucial part of our offerings, designed to support various accounting systems seamlessly. We prioritize integration with industry leaders like Microsoft Dynamics 365 Business Central, Finance, GP, and SL systems, as well as WennSoft and Sage Software ERP packages including Sage X3, Intacct, Sage 100, Sage 300, and Sage 500. Additionally, we cater to the needs of businesses using exclusively web-based ERP systems such as Acumatica and NetSuite.

bottom of page