Hello Guys, How I can show Back Ordered Items Qty ...
# suiteanalyticsn
Nilesh Patil
11/23/2021, 3:32 PMHello Guys, How I can show Back Ordered Items Qty using a Sales Order saved search?
n
Netsuite Tragic
11/23/2021, 9:14 PM{quantity}-NVL({quantityshiprecv},0)
n
Nilesh Patil
11/24/2021, 3:51 AMThanks @Netsuite Tragic
Nilesh Patil
11/24/2021, 3:52 AMAnother query I have, I want to show invoice data and fulfillment data based on SO saved search but it should not be more number of lines than no of Items on SO!
Nilesh Patil
11/24/2021, 3:52 AMthis is right now giving me with gaps and increasing no of lines! can we resolve it ?
Nilesh Patil
11/24/2021, 3:53 AMquery for Qty Fulfilled: CASE WHEN {applyinglinktype} = ‘Receipt/Fulfillment’ THEN {applyingtransaction.quantity} END
query for Qty invoiced: CASE WHEN {applyinglinktype} = ‘Order Bill/{#Invoice#}’ THEN {applyingtransaction.quantity} END
Nilesh Patil
11/24/2021, 3:53 AMkindly help here!! Thanks in Adv
n
Netsuite Tragic
11/24/2021, 4:06 AMuse grouping and Sum to reduce your lines ie Group by Sales Order document number. Sum by Fulfilled Qty etc
n
Nilesh Patil
11/24/2021, 4:16 AMokay, I’ll check that! Thanks a lot