GP Optimizer Summer 2012: Multi-Entity Management Streamlined QTS' Database Infrastructure to a Single Database

Written By Binary Stream Software for GP Optimizer
 Summer 2012 Edition by Rockton Software

• Multi-Entity Management streamlined QTS’ database infrastructure to a single database
• Redundant Processes were eliminated by 30%
• Centralized AR, AP and POP processes
• Fully Automated Audit Trail
• Simplified Complex Deferrals
• Simplified QTS compliance with regulatory standards


QTS (Quality Technology Services) is a leading national provider of data center solutions and fully managed services for enterprise businesses. QTS offers a complete, unique portfolio of core data center services including a Custom Data Center, as well as Colocation and Cloud services, while offering the flexibility, scale and security needed to support the rapidly evolving infrastructure demands of web and IT applications.

Using Microsoft Dynamics GP to manage their business flow, QTS found themselves requiring additional customization to meet some specific needs. After a thorough search, they chose Binary Stream’s Multi-Entity Management (MEM) solution and Binary Stream’s Advanced Revenue and Expense Deferrals (ARED) solution.

With 12 data centers across the U.S. and multiple GP databases for each of these facilities, QTS was operating a total of 33 separate Dynamics GP databases – a significant number of core processes were both redundant and time consuming.

Binary Stream’s Multi-Entity Management solution streamlined QTS’ database infrastructure to a single database environment – eliminating redundant processes by 30%!

With Multi-Entity Management, QTS now enjoys centralized AR, AP and POP processes, which are accessed from a single database by a centralized team.

“We can now create a single purchase requisition and distribute the GL coding amongst multiple facilities,” says Kitty Geiger, QTS’ Senior Dynamics GP System Administrator.

Using Multi-Entity Management, QTS also created a fully automated audit trail for posted, voided and corrected entries, as well as fully automated intercompany transactions such as transferring fixed assets or bank transactions between their data centers.

QTS also had as many as 38,000 unrecognized deferral entries that were processed manually from the many different databases they were utilizing. QTS chose Binary Stream’s Advanced Revenue and Expense Deferrals solution to help them address this challenge.

Advanced Revenue and Expense Deferrals is a fully integrated solution that simplifies complex deferrals by creating deferrals by line item and building schedules allowing for complete control over the timing of sub-ledger and GL recognition postings.

Following the Advanced Revenue and Expense Deferrals installation, QTS’ team was able to close their previous month-end financials a full 11 days sooner than their previous month-end financials. Advanced Revenue and Expense Deferrals also simplified QTS’ compliance with EITF 08-1 and subsequent rulings with regards to Vendor Specific Objective Evidence (VSOE) revenue recognition.

Ultimately, QTS is better able to serve their customer base using Dynamics GP in conjunction with Binary Stream’s Multi-Entity Management and Advanced Revenue and Expense Deferrals.

“We have customers with work orders in multiple facilities. With Multi-Entity Management and Advanced Revenue and Expense Deferrals, we are able to effectively manage our monthly invoicing and apply corresponding payments across invoices in multiple facilities,” says Geiger. 

And that makes good business sense!

These are just a couple of ways Binary Stream’s Multi-Entity Management and Advanced Revenue and Expense Deferrals have added value to QTS’ daily business. Please contact Binary Stream to learn more. 

Download GP Optimizer Summer 2012 Edition by Rockton Software for more great content on how to make Microsoft Dynamics GP work simpler and easier. Click on the GP Optimizer Picture at the bottom, right corner of Rockton Software's homepage.