Get all customers with "3rd Party Billing Account Number"

Question

Hi,

What is the the way to get a list for all customers with field "3rd Party Billing Account Number" filled?

Also, I need a list for all products with field "Handling cost" filled too.

I couldn't find these fields in saved searches criteria or results.

any suggestion?!

Thanks in advance!

Angel mariya T. P. · Accepted Answer

Hi @BM136 ,

Currently, the 3rd Party Billing fields are not available as Fields for Results of Customer Saved Search. This is logged under Enhancement 160478. So we have to use SuiteAnalytics with the Customer Dataset, as it can pull out these fields. There, you can add a filter to list out only the customers with "3rd Party Billing Account Number".

Please refer to the SuiteAnswer "Creating Report to Show 3rd Party Billing Information of Customers" (Answer ID: 88019) for detailed steps.

Similarly, for the Handling costs, you can use the Item Dataset in SuiteAnalytics.