Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
Change saved search to show inventory locations in Columns instead of rows
I have created a saved search to help our purchasing team handle the demand plan recommended transfers. I have it working, but it is missing some vital information that I am struggling to add.
First we only have 2 inventory locations that we move stock between, but we have 3 others that are inactive but always show up on a saved search so that's problem 1. I would love to exclude the other three from results but I can't seem to make it work. I think because I have to setup a transaction search instead of item.
Second issue is for each transfer, I show five rows (1 for each location). I would like to show the available quantities for each location (preferably only the 2 active ones), in the columns instead of rows. Like the total in the last column of the attached screenshot. I have also attached my criteria and results parameters. If there is a way to do what I am doing that would be great or if you have better more efficient way of accomplishing the same thing I would be thrilled. Thank you Guru's, you are all