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.
How to expose a planned component issue date
Hi all,
I'm trying to make a transaction saved search where I can pull the usage for a part on past work orders, and when it happened. So far I can pull the Quantity Fulfilled/Received and that handles quantity "used in build" on a work order but I can't get the "Planned Component Issue Date", which, to my knowledge is the date it was issued if it has been. Any ideas on what field this is on a saved search??
Alternatively I know I can pull the work order issues, but it always gives me 2 line items, 1 with a positive value and 1 with a negative and I'm not sure how to just get the negative (which I assume it means it was pulled from inventory and allocated). Personally I'd rather do it off the W/O instead of the issuance. Any ideas? Thanks!