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!
Hide item in Saved Search that doesn't match formula criteria
I am using a Case When formula in a transaction saved search based on Item Fulfillments and Item Receipts. (Criteria: Type=item fulfillment, item receipt)
Basically want to show inventory debits (fulfillments) and credits (receipts).
My issue is with Transfer orders between branches. Each transfer order shows twice in the search, as both an IF and an IR, both showing both the fulfillment qty and the receipt qty.
I have created formulas for the Qty Fulfillment column and Qty Received column so each qty only shows once, but now there are blank lines for the items that don't meet the criteria to display.