Schulz Consulting

Sage 100cloud Consulting

  • Home
  • Services
  • Contact

Consolidate or Merge Multiple Sage 100 ERP Company Codes Into One

August 28, 2013 by Wayne Schulz

company consolidation sage 100

A question recently was asked in the Sage City online discussion area about whether there was a tool available to automatically consolidate multiple separate Sage 100 company codes into one.

At the time I’d forgotten that there is indeed a tool available and it’s from Accounting Systems Incorporated.

From their product specification sheet:

Company Consolidation can merge separate companies into one consolidation company. Once the basic setup is complete,
the actual process can be run from the menu or from an outside shortcut started by scheduling software. The consolidation starts
by copying the first source company to the consolidation company. If divisions are turned on for any source company,
they are turned on for the consolidation company. General Ledger accounts are matched based upon the formatted account
number. Any accounts missing in the consolidation company are automatically added. Matching customers and vendors are
merged, but customers and vendors missing from the target are automatically added. Detail data, such as transactions, invoices,
and orders, are not added together but are renumbered if necessary to maintain their unique identity. All companies must
have the same G/L account format and the same fiscal year in order for the consolidation to work.

The utility is available for Sage 100 ERP versions v4.40, v4.50 and v2013.

For more information view their product demonstration or visit the product information page.

Filed Under: MAS 90 Add Ons, Sage 100 ERP, slider Tagged With: asi, consolidation, merge, sage 100

Sage 100 ERP (fka Sage ERP MAS 90 or 200): Slow Renumber of Accounts Receivable Customers and Data

August 30, 2012 by Wayne Schulz

Just a heads up on an interesting tech topic being discussed over on 90 Minds. In version 4.5 of Sage 100 ERP the time it takes to delete/renumber/merge large numbers of customers is apparently quite daunting.

One of our members is troubleshooting a way to do 20,000 of them which he computes could take 3 months of processing (I’m probably paraphrasing this but it’s a long time).

If you are in a situation where a new or existing customer asks you about renumbering AR customers – keep this speed situation in mind. It’s not something that is really easy to test short of running a trial renumber on a copy of the customer data.

 

We’ll update you if there is a workaround uncovered

 

Slow Renumber of Sage 100 ERP Accounts Receivable in V4.50

Filed Under: Sage 100 ERP Tagged With: delete, mas200, merge, renumber, sage 100, Sage 100 ERP, slow

Search Our Site

Sage 100cloud Latest News

  • Expect Sage 100 1099-NEC Functionality in Purchase Order With These Updates In Spring 2021 January 18, 2021
  • What Are The Differences Between Sage 100 Perpetual and Subscription Licenses? January 11, 2021
  • Sage 100 Aatrix e-Filing Bug Erroneously Reports Bad SSN Matches for 2020 January 6, 2021
  • There is No Sage 100 IRD for 2020 January 6, 2021
  • Is Your Sage 100 Payroll Year-End Processing Slowly? January 5, 2021
  • Sage Announces Sage Partner Cloud December 16, 2020
  • What Happens When Your Sage 100 Subscription Expires? December 10, 2020
  • Sage 100 – 2020 eFiling Deadlines for W2, 1099 and ACA Released December 9, 2020

Our sponsors

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657-8544
Email Us
Locally serving all of Connecticut, Massachusetts, Rhode Island, Vermont,
New York, New Jersey. Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2021 · Parallax Pro Theme on Genesis Framework · WordPress · Log in