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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 18, 2026, at 8:00 PM Pacific Time, our Case Management System will undergo a scheduled maintenance for approximately 15 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Help, Reports on Matrix item
All my items are like this:
POLO11--BLACK--S
POLO11--BLACK--M
POLO11--BLACK--L
POLO11--RED--S
POLO11--RED--M
POLO11--RED--L
...
Polo11 may have 10 colours, every colour has 8 sizes.
I need my item sales report summary like this:
total POLO11
total polo11--black
total polo11--black--S
total polo11--black--m
total polo11--black--L
total polo11--red
total polo11--red--s
total polo11--red--M
total polo11--red--L
How do I do it?
It seems I can only have total POLO11, I can not have a total for every colour.
When we send PO to factory, the factory need to calculate total one colour quantity manually to get an idea of how many fabric they need to prepare.
0