Monday, April 1, 2019

Customer Saved Search > Added any field from Address subtab (like City, Country) into the Results causes duplicate rows

Each Lead/Prospect/Customer record (as well as Contact, Partner or Vendor record) in Address subtab it can have multiple Addresses defined.

In a Customer/Contact/Partner/Vendor Saved Search when added a field from Address subtab (like City, Country) NetSuite displays duplicate rows in results for every record that has multiple Addresses defined.

To prevent this, it is necessary to add some criteria into the Criteria subtab that define which particular Address is used, for example Default Billing Address > is true. After this modification duplicate lines disappear and only one line per record is shown.

No comments:

Post a Comment