Alba Spectrum’s Company Merge Utility is a unique automated tool for merging Dynamics GP company databases together. It reduces the time to analyze and merge databases by an order of magnitude, dramatically reducing merge costs and increasing convenience, to the extent that the time needed to merge any combination of companies can be closely predicted in advance. Even more importantly, its unique user interface enables a merge project to be handled by a DBA or consultant, rather than having to engage and schedule a busy product vendor.

We have spent hours collecting feedback from our customers which we have utilized to inform the continued development of CMU. Today, we’re excited to announce the release of CMU 2.0, a major update that reflects the needs of many Dynamics GP partners and clients.

Previous versions of CMU renumbered transaction IDs as part of the merge process, but this functionality is not ideal for transactions which have been released to a Customer or Vendor or for physical Assets. The Renumbering method meant that documents would have entirely new numbers after the merge, preventing users from being able to track transactions from before the merge.

CMU 2.0’s new Append transformation method makes it possible to differentiate existing transactions from multiple companies by inserting a unique ID as a prefix into the document numbers in the merged database. Users can select from three different choices for the prefix:

• Company ID – the company ID of the source company
• DB ID – the database ID of the source company
• Custom ID – users can set up a Custom Database ID for source companies in the merge process; that Custom ID can then be added on to document numbers as a prefix

Let’s say that an organization needs to merge several GP companies but retain all the original invoice numbers for billing or auditing purposes. Users might also need to know which GP company the invoice originated from when viewing the merged records at the end of the merge process. The Append feature enables CMU to add on a prefix indicating the Company ID of the source company of each invoice, so that users and customers can both see the historical information they need for their workflow.

If you are considering a Dynamics GP company merge, contact us for a free, no-obligation consultation and assessment of your project. Just email us at sales@albaspectrum.com or ask your GP reseller to reach out to us.