Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
ERROR: Invalid Expression
Hello,
I created a saved search with below
- Criteria
Transaction: Type is any of Invoice, Purchase Order
Transaction: Status is any of Purchase Order: Partially Received, Purchase Order: Pending Receipt, Invoice: Open, Invoice: Paid In Full
- Results
On Hand : ROUND(({quantityonhand}),0) Is: 422
On The Way : CASE WHEN {transaction.type} = 'Purchase Order' THEN ({transaction.quantity}-{transaction.quantityshiprecv}) ELSE 0 END Is: 2,000
Last 2 Months Sales : CASE WHEN {transaction.type} = 'Invoice' AND {transaction.trandate} between last_day(add_months({today}, -3)) AND last_day(add_months({today}, -1)) + 1 THEN {transaction.quantity} ELSE 0 END Is: 3,997
Sales Monthly Average : CASE WHEN {transaction.type} = 'Invoice' AND {transaction.trandate} between last_day(add_months({today}, -3)) AND last_day(add_months({today}, -1)) + 1 THEN {transaction.quantity}/2 ELSE 0 END Is: 1,998.5