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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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