Home » Deeper in to NetSuite » How to Forecast an Invoice In NetSuite

How to Forecast an Invoice In NetSuite

In this post I’ll show you how to forecast NetSuite invoice. If you have enabled the “Advance Billing” option in your NetSuite account and use it to define the billing schedule for your sales orders, then you can also forecast invoices. You can do that by using the ‘Next Bill Date‘ filter. You will need to create a Saved Search on the sales order and use the Next Bill Date filter to forecast an invoice.

For instance, if you need to forecast NetSuite invoices from January till March 2016, you can do so by using the saved search (shown below) from either the NetSuite UI or by using SuiteScript.

CTA - NetSuite Shopify Connector Banner

How to Forecast an Invoice In NetSuite – Using the NetSuite UI

Saved Transaction Search   NetSuite  Wolfe Electronics

How to Forecast NetSuite Invoice via SuiteScript

var filters = [];
filters.push(new nlobjSearchFilter('type', null, 'anyof', ['SalesOrd']));
filters.push(new nlobjSearchFilter('mainline', null, 'is', 'T'));
filters.push(new nlobjSearchFilter('nextbilldate', null, 'within', '01/01/2014', '31/03/2014'));
var columns = [];
columns.push(new nlobjSearchColumn('nextbilldate'));
columns.push(new nlobjSearchColumn('tranid'));
var recs = nlapiSearchRecord('transaction', null, filters, columns);

Hope you find this post useful.

If you have a NetSuite Development requirement you would like to discuss, or would like to know more about our NetSuite Development services, please get in touch with us

Get In Touch With Our Experts

    Get In Touch With Our Experts

      I have read and agree to the Privacy Policy of Folio3
      I agree to be contacted by Phone or Email by Folio3

      Get in touch with the


      End-to-end NetSuite Servicing Agency

      Tell us how may we assist you!