How to Merge Business Partners (BP) in Sage X3

By | March 29, 2018

Many a times, the user creates 2 similar business partners in Sage X3 instead of 1 business partner, this results in 2 separate entities in all the related inquiries or reports. In such cases, Sage X3 provides BP Merge functionality which allows two BP accounts to be merged together, which will automatically transfer all the transactions/balances from one BP to another.

The BP Merge function can be used to transfer postings related to a Business Partner (Source) to another Business Partner (Destination).

Below are two examples of a customer inquiry for two different Business partners, prior to using the BP Merge function.

Navigation: Common Data → Customer → BP situation (right list)

Business Partner 1:

business partner

Business Partner 2:

business partner

Now we will merge the balances of both customers to a single account:


  • Navigate to Financials → Utilities → Miscellaneous → BP Merge

merge business partners

  • Select the company and site criteria.
  • Transactions related to the above specified criteria will be merged.

Source BP- Is the BP for which you want to transfer the transactions FROM

Destination BP- Is the BP for which you want to transfer the transactions TO.

  • Click ‘Ok’.
  • System generates Log for after successful operation. If there is any issue during the process it is traced in the log.

log reading

About Us:

Greytrix Africa– Sage Premier Gold Development Partner is a one-stop solution provider for all your Sage ERP and Sage CRM needs. Greytrix Africa is a consulting company that offers solutions across verticals which include accounting and business management, financial reporting, ERP, CRM, HRMS and EDI.

As one of the leading Sage certified X3 Partner, we have a strong sales and implementation industry presence. We offer scalable software development resource for customizations and enhancements within Sage X3. In addition to the Sage X3 development services which we provide to our end customers; our Channel Partners considered us as “Go-To” resource for custom Sage X3 solutions. Thereby, enabling Greytrix to rapidly introduce new products and solutions to the market.

For more information on Sage X3 Consulting Services, please contact us at [email protected] .We will be glad to assist you.