I followed Tris' instructions and have that field showing on our Purchase Orders, but it's still not pulling the values from the Item file

You are correct. The MPN screen field is one with an ID of custcol4 on the Transaction Line Fields page. In any case, is it possible to put the MPN field from the Item file in its place? We would like our users to be able to enter data if there is none, but have the value pulled from the Item file if there is one there

Yes, the one used in our Purchase Orders is the custom MPN (searchable), whose data seems to be stored somewhere other than the Item file. What we want is to be able to have the data from the Item file's MPN field pulled in and any changes to it to be saved to the Item file

If I untick the checkbox "STORE VALUE", can I make it pull the value from the Item file? Also, when I try unticking the box, I get the ominous warning:

Ohhhh! Here you go:

This is from the Items tab in one of our Purchase Orders:

I found it under Item Fields. Is there a way to have this field populated from the MPN field in the Items file? Currently, it seems that the contents of this field is coming from some unknown (to me) file, but I need it to get the data from the Items file instead

I think this has answered my question. Thank you all for your input!

Apparently, it's a custom field, and it appears on our P.O.s. The Field Help says it's named custitem_mpn_searchable. I was wondering what file this field is from (where the data it contains is kept).

How can I find out what file contains the Field ID: custitem_mpn_searchable?

I just voted for the "enhancement". Seems like this should be standard! Why else have the field there on the screen? 😐️ Thank you for your help!

Nevermind, I just found where to do that (Customize form). 😀

It's still not working for Non-Inventory items. I can see that the MPN (SEARCHABLE) field is greyed out when editing Non-Inventory items. This may be the problem. Is there a way to make that field editable?

I applied the changes you suggested above and changed Standard Purchase Order to check "Show" MPN box (Screen fields, Expenses). I believe this solved the problem, but am waiting to hear back from our users. Thank you!

This is the same as clicking on the Tables Reference button in SuiteQL. I just don't get why the Help Center lists files that we can't access with SQL! Thank you for your answer

I will see if I can implement this. For now, I'm going to say my question has been answered. Thank you all for your contributions!

The Advanced Bill of Materials feature is enabled in our Sandbox account already, so it made no difference in our testing

It is not. I was going to change it, but there was a dire warning that it might affect all kinds of things, so I'm going to try it in our Sandbox first

Where exactly may I do this? NetSuite's Help Center says to use Lists - Supply Chain - Bill of Materials, but this last option is not there in 2024.1

In the header of a Purchase Order, under the LOCATION field is a checkbox (Field ID: custbody_nsps_copy_location_to_line) to COPY LOCATION TO LINE ITEMS. It's not a custom field as far as I know

The problem is, we have assembly builds WITHIN assembly builds, and only the main work order is created. It does automatically create the parent, just not the sub-assemblies.

Sorry, the header above should say "Purchase Orders" (although this may also apply to Sales Orders)

Thank you for that explanation. I will pass it on. I got this further update from our user: Currently, only the first work order is "attached" to the sales order. They know what work order go to the sales orders because they notate it on the sales order. What they really want is to be able to hit "create work order", and…

Yes, I tried using that, but it didn't give me any of the information I needed. I used the help center info. What was confusing was that on the Item file page, salesdescription is listed as a Search Filter. Here is a screen shot, since this forum apparently doesn't allow users to post web addresses: Thanks!

Richard James Uri-Oracle's reply revealed that the "Sales Description" field is actually just "description" in the item file. I used the query: select itemid, description, purchasedescription from item where description IS NULL or purchasedescription IS NULL and this gave me what I need. It's too bad that information like…

There is no "Purchase Description" file that I can find. My original query was: SELECT itemid FROM item WHERE purchaseDescription IS NULL It produced 42 records. I ran the query you suggested above and it produced no records. When I changed it to: select itemid from item where ((subtype='Sale' or subtype='Purchase') and…

I would really appreciate that! I wish NetSuite would make it easier to find out what file a particular field comes from, e.g., the one identified as salesdescription on the Inventory Item screen. That is the "Inventory Item: Description (Sales)" field in the report. The problem is, there is no file called Inventory Item…

Other reports allow the user to filter by fields that are included in the edit columns! Why not this one? It seems ridiculous to me that this would be considered "standard behavior." I already put in an "enhancement" request (757770):…

This is a screenshot of the Filters page and the file fields being shown are from the Inventory Item file: As you can see, there are no Description fields available!

This issue has once again come up with a notice from NetSuite that "some of your employees are using SMS/voice call as a code delivery option for two-factor authentication (2FA) in NetSuite." That's good to know, but we have no way to identify these employees in order to notify them! Not very helpful!