Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Sales by Customer - Roll Child TransactionTotal into Parent
We use Parent : Child relationship and we create invoices for both Parent and Child. I am trying to customize the Sales By Customer report but am running into trouble with the way data is displayed when group by Parent - only Name/ID and Sales Total display. To see the other columns I have in the report I have to expand the group. Why does it do this???
| [TABLE="cellpadding: 0, cellspacing: 0"] [TR] [TD] | ||||
| CUSTOMER | PARENT CUSTOMER/JOB: COMPANY NAME | CUSTOMER TYPE | CUSTOMER CATEGORY: NAME | SALES |
| [TABLE="cellpadding: 0, cellspacing: 0"] [TR] [TD] | ||||
| VMR033 | $2,689.15 | |||
| Total | $2,689.15 |
[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[/TABLE]
All I need to do is display the Parent, two other custom fields, and the Sales Total. Problem is when results are grouped can't see the other columns on the report.
Tagged:
0