This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

hello all,
Is something like this possible in a Report?;

I'm going to say Yes.  Which part is your challenge?

I started with a Purchase by Item Summary

The layout you show is more suited to SuiteAnalytics rather than a Report

<@U01E037GJ84> my issue is that the received and open lines are 1 line each per Vendor and represent the total open or received for that year.
I think with your example it will show a lot of lines per Vendor and per status?
Mine is also of type Purchase order,

You have more flexibility using Analytics. 

Can also be done in saved search bit need to build a formula to filter each results column 

easy peasy in Satori Reporting. Otherwise, I agree with trying in search with formulas, but would take some time to build.

Here is the formula (numeric) for the quantities by a year : `CASE WHEN TO_CHAR({trandate},'YYYY') = '2017' THEN {quantity} ELSE 0 END`

Then the amounts are similar `CASE WHEN TO_CHAR({trandate},'YYYY') = '2017' THEN {amount} ELSE 0 END`

then for each year's columns change the year, '2018', '2019' etc

so maybe 5 minutes as a search?, plus some review , layout and a coffee in the extra 10 minutes

Don't forget about the time to export to excel and format for management's eyes...over and over again instead of being automated in presentation quality :)

Only issue is I forgot to mention I also have a column before the crednr that is a sales assortment and I want as a fold down as they are in reporting.
This for the end-user to just see purchases per sales assortment like the following:

and really want the open/received be as rows