Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
Now, you can stay up-to-date with the latest discussions, helpful tips, and important announcements, all delivered straight to your inbox. Whether you’re looking to catch up on what you missed or just want a quick overview, our email digest has you covered. To learn more and to subscribe, click here.
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