Hello. I'm excited to have joined the NetSuite online community.I need to create a saved search that will show the results of invoice lines open as of a certain date. Effectively, creating a “commissions payable” output without using NetSuite’s commission function. I’m able to calculate the date/time the invoice became paid in full, but I’m not able to add the second level to the case statement for the “as of date.”

As of Date is dependent on ChargeBasedBilling feature. I can try to help if you can provide some more details.