https://netsuiteprofessionals.com logo
Join Slack
Powered by
Trying to get this field, does anyone know the fie...
# suitescript
c
Trying to get this field, does anyone know the field ID?? i tried to use field explorer but without any luck. the average cost field next to last purchase price, is called {locationaveragecost} tried to get last purchase price with {locationlastpurchaseprice} But unfortunately this did not work. Any suggestions are highly appreciated
c
Are 100% sure the field viewer plugin didn't show you anything?
I've never seen that before.
🙌 1
another option is to add ?xml=t to the end of the URL and that will show you an XML representation of the record and you will be able to find the field name there.
c
message has been deleted
Does not work
Field explorer shows a name. But the location average cost next to it, is called averagecostmli on the field explorer, but in the help documentation it is called locationaveragecost
averagecostmli does not give you any vaules in a saved search
locationaveragecost does
so the field explorer is not always useful
c
?xml=t
you missed ?
c
It wont work..
it will give me the same id as the field explorer does
c
Yeah, the help is sometimes trash
so you're saying the field ID that you can actually see doesn't have a value?
c
It does
c
what's the issue then?
c
..
dont know how to explain
c
I wouldn't ever count on the help text being correct.
c
I have the field that has a value on the record
i use field explorer to find the field name
IT gives me the wrong name, but the field still has a value that it holds
c
wrong name?
What makes the name wrong?
If it's in the field explorer, I would say it's the correct name. The help text is wrong
c
when i try to make a saved search FORMULA with the name i get from the field explorer i get "Error: field not found"
as i said....
even the locationaveragecost field
has a differnt name in the field explorer
try it yourself
c
I don't have that field present on a few of the accounts i have access to
I might add it to the form when I've got some free time to take a look
c
What saved search type are you trying?
c
Item
c
What formula are you using?
c
text
and currency
c
I can find the field in search criteria and result
c
tried both
can you export
c
Copy your formula here
c
Can you just export to a suitescript search and give me the field id?
2 sec
message has been deleted
@Craig
c
Copy code
["lastpurchaseprice","equalto","1.00"]
c
that is not the one.
c
Which field do you need?
c
the one you linked is lastpurchase price, the field that is in the main line
2 sec
message has been deleted
i need the last purchase price for the location
not the one in the top of the pic
As i said.
Averagecost = mainline locationaveragecost = locations
😄
cant get it
c
I can't find what you'r elooking at
maybe your view is very different omine
*to mine
c
the first pic i posted
i posted i was looking at locations
not the main line
But fairrr
c
I can't match your screenshot to what I can see on this record
c
welll i google and i cant find anything
on how to access this field
c
Is this an item record?
c
I don't have locations/bins enabled on my account, but it looks like a sublist. Have you done the sensible thing on your search and looked for something like "Location fields...." (scroll down to the bottom of the column list when picking) or similar?
c
Yeah I've got nothing that even matches
not sure why
I can probably pull it using SuiteScript, will try later.
c
https://netsuite.custhelp.com/app/answers/detail/a_id/12551/kw/multi-location%20last%20purchase%20price Weird behavior for sure, but makes it seem like it only takes the item's preferred location last puchase price and ignores the others, maybe thats why you can't pull it?
s
Did you try 
lastpurchasepricemli
, thats what it looks to be int he field explorer
s
could be a non-store value field, or one of those weird fields you'd try to pull via formula
k
hey, did you resolve it? just curious as I always had issues with this, and there is SA Answer ID 70862 that might work. if does not apply just remember this is location level LPP, NOT item level LPP
c
@Sandii First thing i tried 🙂
@Sciuridae54696d I can pull the value with the analytics tool
@Karina No i did not resolve it.. can you link the SA answer?
k
@c c - just type number 70862 into the search box in SAs. Cannot link, sorry,
r
&XML=T Will give you the ID. Just have to look for it properly. Sometimes the ID you can get from it will not be the same which will get you the value. Like based on subsidiary the ID of some particular fields change on transactional level. So in field explorer it might differ, but you need to pass in the actual ID not the one it's changed too. First, Try looking it in record browser. Then Through extension. And then through &XML=T. One last thing It could be a field that does not store a value. The value gets populated as soon as you load the record. Try all 4 things, you are sure to get your answer.
4 Views
Open in Slack
PreviousNext
Powered by