How do billing schedules work when the project features are enabled? We can't get the quantity and the related current % fields to populate based on the billing schedule when creating an invoice.
We want to automate our billing using the native NetSuite billing schedule functionality. The company has the projects and project management features turned on.
We tried creating billing schedules on the project and on the sales order. When we click next bill on the sales order or use the bulk invoice sales orders option, it successfully creates the invoice. But the quantity is zero, so the overall invoice amount is zero.
The field % Complete at the invoice line level shows the correct percentage that should be billed based on the billing schedule. But the quantity is zero, and the current % is zero. I can manually change the current % or use the Fill % button to enter the correct percentage. But we want to automate this process based on the billing schedule instead of manually entering the current % or quantity for each invoice.
Here is the project record for this test. The related project billing type is set to Fixed Bid, Interval, with a blank billing schedule.
Here is the sales order line. It has the correct billing schedule to create two invoices when the billing process is run.
Here is the invoice line. When I create the invoice, the billing schedule should bill 50% of the sales order as shown in the % complete field. But the QTY and Current % are both zero. Note, the "This Invoice" field is the native Amount field.
Is there a feature, preference, or setting at the project level that needs to be changed?
The billing schedule is showing correctly on the sales order and seems to be calculating the correct billing percentage on the invoice. But the quantity is zero, and the Current % is zero. What am I missing?