htl1 — NetSuite Community

My Stuff

See All the Unlockable Badges See All the Unlockable Badges

New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.

Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.

Comments

Thank you so much for your help you pointed me in the right direction! I found that your suggestion pulled the total quantity on hand fro all locations. For just one location I used this formula and it worked: CASE WHEN {ITEM.inventorylocation} = 'Texas' THEN {item.locationquantityonhand} ELSE null END

in Saved Transaction Search sublist, need to show on on hand inventory for two specific locations Comment by htl1 Mar 4, 2020 12:49PM
What would be the formal numeric I would put? It does not work on a saved transaction search: CASE WHEN {location} = 'Texas" then {item.quantityonhand} ELSE null END

in Saved Transaction Search sublist, need to show on on hand inventory for two specific locations Comment by htl1 Mar 3, 2020 12:50PM
Thanks for answering, what I need in the transaction saved search is this result: CASE WHEN {inventorylocation} = 'Texas' THEN {locationquantityonhand} ELSE null END However, in transaction saved search inventory location is unaviable, is there a work around?

in Saved Transaction Search sublist, need to show on on hand inventory for two specific locations Comment by htl1 Feb 29, 2020 5:04PM

htl1 Newbie

Comments