What formula di i type to get the price on invento...
# generalc
c c
10/13/2021, 9:57 AMWhat formula di i type to get the price on inventory items? under sales / pricing. I can select Base price, and i will get the amount which is shown on the pic, but i also want to show what currency it is, Euro, DKK, USD etc etc
n
NElliott
10/13/2021, 10:01 AMNot really sure but if you go to an item and look at the underlying structure (&xml=T) it might give you a clue, I can tell you that multi-currency / price breaks are less than intuitive I find.
c
c c
10/13/2021, 10:06 AMWhat do you mean
c c
10/13/2021, 10:07 AMlike inspecdt eleement?
c c
10/13/2021, 10:07 AMinspect*+
c c
10/13/2021, 10:07 AMmessage has been deleted
c c
10/13/2021, 10:08 AMprice6 might be it
n
NElliott
10/13/2021, 10:08 AMlike this on the url:
Copy code
?id=31420&e=T&xml=TNElliott
10/13/2021, 10:09 AMI don't have an account set up to use those pricing fields otherwise I'd give you a more meaningful screenshot
c
c c
10/13/2021, 10:09 AMSry bro, but the url does not change when i switch tab
c c
10/13/2021, 10:09 AMi can show you on zoom or skype if you wanna go
c c
10/13/2021, 10:09 AM5 min
c c
10/13/2021, 10:09 AMor here
n
NElliott
10/13/2021, 10:09 AMPut the record in edit, add &xml=T to the end
c
c c
10/13/2021, 10:09 AMill try that
c c
10/13/2021, 10:10 AMmessage has been deleted
c c
10/13/2021, 10:10 AMahhh like this!!!
c c
10/13/2021, 10:10 AMDamn!!
c c
10/13/2021, 10:10 AMi did not know you could do that, thats amazing
n
NElliott
10/13/2021, 10:10 AMYeah it's a bit rubbish actually but can be handy in a pinch
NElliott
10/13/2021, 10:11 AMIf you use Chrome then you could also use this extension:
https://chrome.google.com/webstore/detail/netsuite-record-json-view/ibkdphopcbimokejnhhgelcancfabhba?utm_source=chrome-ntp-icon
NElliott
10/13/2021, 10:13 AMYou could also just load the record in the console and JSON.parse(JSON.stringify(therecord)) as a down and dirty way to view it...
c
c c
10/13/2021, 10:13 AMAh yeaaa
c c
10/13/2021, 10:13 AMand then get the field name
c c
10/13/2021, 10:13 AMand then do a formula
c c
10/13/2021, 10:13 AMto get to curency right
c c
10/13/2021, 10:13 AMcurrency
c c
10/13/2021, 10:14 AMmessage has been deleted
c c
10/13/2021, 10:14 AMIt seems like it would be price9 or sometihng
c c
10/13/2021, 10:14 AMso maybe do formulatext("price9")
n
NElliott
10/13/2021, 10:25 AMProbably not, that's a sublistid and you need to know that and the field internalid
c
c c
10/13/2021, 10:26 AMmessage has been deleted
c c
10/13/2021, 10:26 AMmessage has been deleted
n
NElliott
10/13/2021, 10:26 AMI was just going to say have you checked that it's not already available in the columns list...
c
c c
10/13/2021, 10:26 AMmessage has been deleted
c c
10/13/2021, 10:26 AM,
c c
10/13/2021, 10:26 AMmessage has been deleted
c c
10/13/2021, 10:26 AMsomething is wrong
c c
10/13/2021, 10:27 AMtho
n
NElliott
10/13/2021, 10:29 AMUnfortunately, as I said, I don't have access to an account to fiddle with it to figure what you need and I don't know off the top of my head. Sorry, maybe someone else will come online to advise. I have accessed it via code and was looking for an example in case that gave a clue but I cannot find an example.
c
c c
10/13/2021, 10:29 AMAlright, thanks for your time elliot
c c
10/13/2021, 10:29 AMalways appreciate your help brother
n
NElliott
10/13/2021, 10:29 AMNo problem and it's Neil 😉
c
c c
10/13/2021, 10:30 AMAahah sry man, ill remember till next time
👍 1
🤭 1
2 Views