Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Need Main Line Quantity on Line item Lines in a Saved Search
Hi there, looking for assistance on an assembly build record search. I have a search that shows the main line (item being made) and the component lines (member items that were consumed). If I put quantity as a field, i get the appropriate quantity for each line in the search... main line and line items each reflecting the quantity of the item on that row.
What I am trying to do (unsuccessfully) is to have a column on all the line items but source only the header level's quantity value. I don't want to main line Y or N, i want all the data for header and sublist ... but want the header quantity on the sublist too. Even as a formula, i can't seem to achieve this. Any suggestions?
Tagged:
0