How to identify a percentage of line items fulfilled on a Sales Order
we are trying to find a way to identify the percentage of fulfilled lines on a sales order. Is there a way to do this in NetSuite or create a saved search that will calculate? I can use a SQL database to pull if needed but looking for long-term solution in NS.
Saved search for sales order. Group by item or by sales order in results. Formula (numeric) {quantityfulfilled}/{quantity} .
I am not sure what all information you want to see but this should get you close.
