Show sub customer’s Transactions on Parent Customer’s record as a sublist

Requirement: To get all Sales Orders created by all the sub-customers on parent customer as a sublist.

As per Netsuite’s standard functionality, the customer record shows all the transactions created by that customer only.

Solutions:

Step 1: Create a Saved Search on Customer record

A) Set Criteria:

1. Type: is Sales Order

2. Main Line: is True

cost-center3

B) Set Results:

Add fields as shown below figure:

cost-center1

C) Set Available Filters:

Add Field as shown below.

cost-center2

Now Save the Saved Search.

Step 2:

1.Go To Customization -> Forms -> Sublists as below.

cost-center5.png

Now click Entity Tab and select the saved search that you have created just now. Add the tab on which you want to show and select Customer checkbox as shown below.

cost-center6.png

Now add and save.

Now Go to the Customer record -> Sales -> Cost Center Transactions and see the results.

cost-center4.png

Leave a comment

Your email address will not be published. Required fields are marked *