Home

NetSuite case statement to return results of invoices open as of a certain date

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.”