Are files that are attached to item records/kit items sourceable? I have an instruction sheet that is attached under communication>files that I would like to have a link to under the item line on a sales order. If not, would a custom field on the kit record be sourceable with the attachment? I'm trying to be able to have the file be clickable at the item line level on the sales order when my office adds that kit item to a transaction. That way they can just click on the link and print it with the order.

seems the latter of the 2 worked. however, it only takes me to the file page instead of showing/downloading the document when I click on it from the transaction

Hi all, I have a custom column which I can see have values on line item level on SO & I have an IF search where I am trying to pull this custom column in the Results-> I do not see any value for the following two things I tried in the Results section of saved search: Column & Created From: Column Field. I checked that Main Line is False & also that the custom column does indeed is checked for "Store Value". What is the other possibility that I do not see the value of the custom column field?

@neerajrtiwari you can try using this setting on the custom field

Just tried doing this on the custom column and then went back to the search results - does not do anything - I tried Created From: Custom Column --> this is because I know the value only exists in SO for the custom column field-when I view the same custom column in IF, I thought it will carry over the value from the SO but it does not

In the search results, basically it shows blank results under the custom column field

Is it blank even when you select "View from Order Only"

?

It's blank either ways

with or without the checkbox checked

I thought it's not able to lookup the "Created From" fields-so I added "Created From" in the search results - but it does pull the created from value in the search results (SO number)

just not the Created From: Custom Column

maybe this is two level of joins so it's unable to do it (Created From -> Item-> Custom Column)?

It's not really two levels because the field lives on the transaction, not the item

It probably because Created From is joining to the main line, not the transaction line linked to the fulfillment transaction line

Ok, I just tried removing the "Main Line is False" criteria -> still did not pull the value for Created From: Custom Column.

No, what I mean is that Created From will point to the Sales Order main line, but the field you want to get from the created from transaction is not on the main line

Oh, I see, I wonder why they give custom column field as an option in the "Created From..." pop-up of Results

Because netsuite and main line / columns are one big mess in Saved Search

Got it, thanks for your inputs!

Also, one last thing - what is the real advantage that you have seen for the "VIEW FROM ORDER ONLY" checkbox?

I think it's something new that was added recently?

Nah it's been there for a couple of years. I've only used it once in a script. Apparently it doesn't help for searches but I used it to source a field from the sales order on fulfillment, without worrying that the value was copied across and without having to load the sales order as well

Our Web Services Analysis shows some requests being made on an old API (2013.2). how do we find out which app us doing this?

Can I import a work order transaction, or import an update for one.

Hi - question for people using inventory status - are you able to fulfill orders with a status that’s set to “make inventory unavailable”?

Is there a native field that can be added to sales order line items that indicates whether that line item has been fulfilled or billed?

Hello Everyone! Thanks for the invite

What is the best way to pull an Inactive Customer report?

As in the inactive box on the customer is checked? Customer Search where Inactive = True