Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
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!