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.
Using a Formula to Show Only Data for a Fiscal Quarter in a Column
I have built a search for a client that has the date criteria built into the Columns (Results tab). For example, the first column shows Period to Date, the next column Quarter to Date, next YTD and last previous YTD. The Period to date column works fine since you can just choose a period and the YTD columns work ok because even though this client uses fiscal periods and quarters, their year still runs 1/1 - 1/31.
The issue is the QTD column. Ideally, any time you would run the report, it would pull Period to date, QTD and YTD data as of the date you are running the report; we'd prefer not to have to change any dates manually. The parameter we were using as part of a CASE WHEN statement to try and only get QTD info in a column was TO_CHAR({trandate}, 'Q') = TO_CHAR({today}, 'Q'. This would work great if they were on calendar months. But since they are on fiscal periods, this formula misses any dates that are part of the next period,