Schulz Consulting

Consulting and Upgrades

  • 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

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 News

  • Will There Be A Sage Summit for Sage 100 Users in 2022
  • Avalara Outlines Setup for July 1, 2022 Colorado Retail Delivery Fee
  • Sage 100 API Offered by ROI Consulting
  • Sage 100 Paperless Electronic Delivery Via Gmail Requires App Password or OAuth Starting May 30, 2022
  • Best Practices for Sage 100 Security
  • SPS Commerce MAPADOC EDI for Sage 100 2022 Due for June 22, 2022 Release
  • Can Sage 100 Premium ( SQL ) Be Migrated Back To Non-SQL ( Providex?)
  • Sage 100 2022 Requires New Activation Key for Production Management Installation
  • Sage Releases Sage 100 v2022
  • What File Prerequisites are Required by Sage 100 v2021?

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657.8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

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