(Also asking here because this maybe is not possib...
# suitescripta
alien4u
02/15/2019, 4:14 PM(Also asking here because this maybe is not possible with a workflow)..
Anybody ever tried to get Items On Order quantities for an specific location in a Workflow?
I'm adding an On Order custom column/line field to the Purchase Order record and trying to populate it with the Item quantity on order for the location that Item have in that transaction line.
b
battk
02/15/2019, 5:16 PMnot for a workflow, but the best i got was on order for all locations
battk
02/15/2019, 5:17 PMquantity on order for one location is a search and nothing native on lines does searches
a
alien4u
02/15/2019, 5:36 PMWell Sales Orders have Ond Hand natively at the line level, I want to recreate that on POs and add On Order... which is basically the same... but I understand what you are saying... still I don't think netsuite do a search everytime a line location is changed or a line is added, to populate On Hand on the fly, otherwise would run out of governance...
j
jkabot
02/15/2019, 5:37 PMNetsuite's client side code just makes ajax requests, probably doesn't call nlapiRequestURL and probably doesn't track its own governance.
a
alien4u
02/15/2019, 5:37 PMcool...
j
jkabot
02/15/2019, 5:38 PMAt least I would be surprised if it did