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.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
ODBC billing_schedule and sales forecast
using billing schedule table I am trying to forecast sales using ODBC. the table does not appear to indicate what invoices have been generated vs those that are still pending generation. Any ideas on how I can figure this out? There is no indication of this in the billing_schedule table but it does surface in the UI as billed or not.
One idea I had was comparing the invoices generated vs the invoices scheduled to be gen'd. This seems kinda hard and slow. Also it appears that invoices are not usually generated on the exact date the schedule indicates they should be (usually a day later, sometimes more), so matching becomes a best guess.
0