Good luck mushrush !

Did you try wrapping the formula in TO_CHAR()?

I couldn't find it either. Bummer. One thing I managed to note is that if you add Qty On Hand : Account : Name, then for Item Receipts that are created from Purchase Orders I see "Inventory Received Not Billed" account, whereas for Item Receipts created from Transfer Orders or Return Authorizations, there is no account…

Sounds like you should easily be able to accomplish all this with workflows. You mention setting the Next Approver field on an Employee record, which I have never bothered to do - I do agree that it sounds like that wouldn't work for your situation. A series of workflow actions, each with the condition you state, should do…

trimblee is right - this is also a viable solution and requires no scripting.

This is deployed as a Suitelet to be tested via button push, but you could deploy it in whatever manner is needed... function callAPI(request, response){ var soap = ''; var key = 'test'; // Your Developer Key goes here var pass = 'test'; // Your Password goes here var accountnum = '123456789'; // Your Account number goes…

Hi - Do you mean that you want to set the Next Approver to person A if the PO total is < $1000, person B if the PO total is >= $1000 and < $5000, or to person C if the PO total is >= $5000?

If you mean that you want to add, say a fourth segment ("division" or "sales channel" perhaps) while not renaming/repurposing the existing ones, then the answer is currently "no". However, NS did make mention of at SuiteWorld this year that they are working to add the ability to add custom segments ("SuiteSegments"). He…

Not sure about UPS, but I have written a proof-of-concept FedEx API test to get transit time before; I'd be happy to share if it helps. If you don't have a FedEx account though I can't help much, though I'd imagine that UPS' API would offer the same functionality!

Yes hemang, I believe Olivier Gagnon NC hit it on the head...saved searches can query and display both body(main-line)-level data as well as line-level data. Reports tend to use only body-level data, depending on the report. Can you send a screenshot of the report or saved search criteria you are using?

Are you able to identify which scheduled script might be creating the sales orders?

Olivier Gagnon NC beat me to it - these are called Suitelets, are relatively simple to implement if you have any scripting ability, and give you lots of control. I use them all the time, not just for access control (although that is great) but to make certain processes dead-simple. Just beware, once you start doing it…

Can you provide some screenshots of your workflow? Is the workflow running On Create / On Update / Both?

Hmm, did you attach any screenshots? I'm not seeing any. Not sure if there's a specific way you tried to attach them... At any rate, one thing that comes to mind is for vendor/customer records, you want to use "After Field Sourcing" instead of "After Field Edit", as it takes time to load the information from the associated…

Curious...not sure why that might not be working, but one thought would be to try setting it to a formula instead, and use something like {createdfrom.internalid}.

Yeah, even mine doesn't display for me. Sorry to have hijacked your post, esmeraldaw !

Here's what I see (and we'll see if I can see this image, too...): [ATTACH=CONFIG]n357763[/ATTACH]

Still can't see it. Doesn't show in IE, Chrome or Firefox for me. Looks like there is an image in the HTML of the post, though. I don't see any settings in my account controlling this. I can definitely see other images on other posts. Don't know what's up.

esmeraldaw, I think you'll still need a workflow to accomplish that - I can't think of a way to do it without one (or scripting, which is more complex). Still not seeing the screenshots unfortunately!

We do this by simply using the "Transaction Item Options" available in NS. It allows us to put things like customization details for a given line item on a sales order, and they transfer to the work order that is created off of the sales order. I believe this field on the WO is stock. Sounds like this may help you…

Thanks CTorgerson , yeah that's what I ended up doing. Works fine :)

I am having this same issue now; pujar , how did you get this resolved, if you did?

pcutler - I tried adding that column to the saved search which I am loading in my script, and the columns show "ERROR: Field Not Found"

Thank you so much for taking the time to post this. I'm working on scripting the automation of our sales order approvals and would have been lost for quite some time without it. Cheers!

alex.hernandez - check this out, it should help: http://blog.prolecto.com/2016/02/21/quick-netsuite-utility-function-load-item-record/

Hi All, I have a custom Record with two fields one of which is custrecord_cat_bankdet I would like this record ( which is a list ) to change to be the same as the customer currency field, probably really simple but I'm struggling I have set this formula in a workflow am I miles out SET…

Thanks for taking a look So, your formula is set to: SET {custrecord_cat_bankdetcur}={record.currency} This won't work. Just set the formula to {record.currency} and see if that works for you.

To double check some things just in case: (1) your custom field is set to be type Date, and not, say, free-form text correct? (2) your results column in your search is set as Formula (text), and not, say, Formula (date)? What specific error are you seeing?

I am stumped with a saved search! I am trying to pull in sales orders where the fulfillment and invoice dates don't match. I have that all dialed in, but I want to exclude any where there are multiple fulfillments (because that is an acceptable reason to have a mismatch with our company's procedures). It is even possible…

sorry for being clueless but Im not sure what you mean I see now that you already mentioned it was in a workflow. Can you provide the details of the workflow? Perhaps some screenshots of the workflow definition and the action definition? That would help us to diagnose, as the issue may be inside of the workflow. Is the…