How to fix the error “NBADR is greater than the number of lines” while editing a Sage X3 record from Salesforce to Sage X3 through GUMU™ ?

By | September 7, 2023

In this blog, we will discuss how we can fix “the value of NBADR is greater than the number of lines” error while editing a Sage X3 record from Salesforce to Sage X3 through GUMU™. For this blog we will be taking an example of an account field to be edited and saved which should change the Sage X3 account records field on a real-time basis.

What causes this error to occur?

When a user imports or syncs their account without importing the corresponding address from Sage X3 and tries to update the account from Salesforce to Sage X3 then the value of NBADR is greater than the number of lines encountered. As a result, only the migrated accounts from ERP to Salesforce are visible in Salesforce. If the user attempts to update one of these accounts, they may encounter this error.

Steps to follow to fix the “the value of NBADR is greater than the number of lines” error :-

Upon modifying a related/connected record of an Account field within Salesforce, the resulting error of “NBADR is greater than the number of lines” becomes apparent in the “Last Sync Message” field.

NBADR Error
NBADR Error

The address count in Salesforce is lower compared to Sage X3, as evident from the records.

Number of Address in Salesforce
Number of Address in Salesforce
Number of Address in Sage X3
Number of Address in Sage X3

To fix this error, make sure to sync the address import routine of that Customer.

Address Import Rountine
Address Import Rountine
Address Imported
Address Imported

As you can see all the addresses in the Salesforce are imported from Sage X3. Now let’s try to update the account.

NBADR is greater than the number of lines
Account Updated Successfully

By following the above blog instructions, you should be able to learn “How to fix the error “NBADR is greater than the number of lines” while editing a Sage X3 record from Salesforce to Sage X3 through GUMU™ ?“. If you still have queries or any related problems, don’t hesitate to contact us at salesforce@greytrix.com. More details about our integration product are available on our website and Salesforce AppExchange.

We hope you may find this blog resourceful and helpful. However, if you still have concerns and need more help, please contact us at salesforce@greytrix.com.

About Us
Greytrix – a globally recognized and one of the oldest Sage Development Partner and a Salesforce Product development partner offers a wide variety of integration products and services to the end users as well as to the Partners and Sage PSG across the globe. We offer Consultation, Configuration, Training and support services in out-of-the-box functionality as well as customizations to incorporate custom business rules and functionalities that require apex code incorporation into the Salesforce platform.

Greytrix has some unique solutions for Cloud CRM such as Salesforce Sage integration for Sage X3Sage 100 and Sage 300 (Sage Accpac). We also offer best-in-class Cloud CRM Salesforce customization and development services along with services such as Salesforce Data MigrationIntegrated App developmentCustom App development and Technical Support business partners and end users.
Salesforce Cloud CRM integration offered by Greytrix works with Lightning web components and supports standard opportunity workflow. Greytrix GUMU™ integration for Sage ERP – Salesforce is a 5-star rated app listed on Salesforce AppExchange.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

For more information on our Salesforce products and services, contact us at salesforce@greytrix.com. We will be glad to assist you.

­­Related Posts