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.
Opportunity>>SalesOrder>>Invoice
Has anyone generated a single item-level report that pulls data from Opportunity, Sales Order, and Invoices?
- When an opportunity is closed-won, we create a sales order.
- On the sales order we set up billing schedules
- From there we generate invoices
In one single report, we want to see all scheduled billings (from sales order), actual billings (invoices) -- all tied to the original opportunity -- at the item level.
For any given period, we need to see in one report scheduled + actual billings (this represents our billings forecast) -- with the original oppty/booking amount.
The views for Forecast, Sales Order, and Sales -- reports are not consistent in that we cannot easily locate oppty fields. Any ideas/suggestions would be much appreciated.