https://netsuiteprofessionals.com logo
Join Slack
Powered by
Does anyone know if this field “is drop shipment” ...
# suiteql
c
Does anyone know if this field “is drop shipment” is accessable on the transaction line? Note this is not “dropship” on the transactionLine.
j
I’m not sure where you are grabbing that screenshot, but are you trying to get the “is drop ship item” value from the item itself? If so, you should be able to join to the 
item
table to get it. https://695173.app.netsuite.com/app/recordscatalog/rcbrowser.nl?whence=#/record_ss/item
c
Not from the item, it is a field on the return authorization transaction line. It specifies whether the returned item is going back to the vendor or into inventory
j
ah
what do you mean by “is it accessible”? What happens when you run a 
SELECT
and try to get it?
c
The field doesn’t exist in the transactionLine table
I’m just wondering if there is another table that would join to transactionline to determine this information
j
where did you get that screenshot from?
nm I found it
it also doesn’t seem to be exposed to saved search
annoying
I’ve had similar issues with trying to get povendor on SalesOrders
c
Yep I think scripting is the only way.
For po vendor the best way I’ve found is to join to the po on transactionline.createdpo and get the vendor from the joined table
j
we tend to need it BEFORE the po is created
c
Ah yeah thats tricky then
j
yah it’s a hassle
I don’t get why NS seemingly arbitrarily hides data
it’s our frickin database
🙌 1
2 Views
Open in Slack
PreviousNext
Powered by