Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Transfer Order transaction saved search - BackOrdered quantity formula HELP
Scenario:
Formula to return Quantity Back Ordered on Transfer Orders in Transaction Saved Search is working for most scenarios, but not all
Current formula is returning correct results using Case When conditions for specific Items and Transfer Order status and inventory location except when the Item has On Hand inventory which has been committed
Current formula:
CASE WHEN {item} IN ('NFBL001','NFBK001','NFBN001','NFPR001') and {type} = 'Transfer Order' and {status} IN ('Pending Fulfillment','Partially Fulfilled','Pending Receipt/Partially Fulfilled') and {item.inventorylocation} = 'XXXX' THEN ABS({quantity}+transferorderquantitycommitted}+nvl({transferorderquantityshipped},0)) WHEN {item} IN ('NFBLZP2','NFBKZP2','NFBNZP2','NFPRZP2') and {type} = 'Transfer Order' and {status} IN ('Pending Fulfillment','Partially Fulfilled','Pending Receipt/Partially Fulfilled') and {item.inventorylocation} = 'XXXX' THEN ABS(({quantity}+transferorderquantitycommitted}+nvl({transferorderquantityshipped},0))*2) WHEN {item} IN ('NFBLZP4','NFBKZP4','NFBNZP4','NFPRZP4') and {type} = 'Transfer Order' and {status} IN ('Pending Fulfillment','Partially Fulfilled','Pending Receipt/Partially Fulfilled') and {item.inventorylocation} = 'XXXX' THEN ABS(({quantity}+transferorderquantitycommitted}+nvl({transferorderquantityshipped},0))*4) else 0 END