NSThriver

My Stuff

See All the Unlockable Badges See All the Unlockable Badges

Comments

Forgot to provide an example. This one is contrived but you can easily adopt it for your needs case when instr({account}, 'Purchase') > 0 then 'Purchase' when instr({account}, 'Sales') > 0 then 'Sales' else 'DNE' end

in Need SQL help Comment by NSThriver Jan 19, 2018 12:34PM
You could either use the INSTR() function or SUBSTR() function depending on how the field is structured.

in Need SQL help Comment by NSThriver Jan 19, 2018 12:13PM
Hate resurrecting dead threads, but I recently ran into this issue. Did you or anyone figure out how to set the status? Setting it to 'D' in SuiteScript gave me an Undefined Status

in How to Approve an Inventory Count via RESTlet? Comment by NSThriver May 7, 2018 5:49PM
[h=2]Answer Id: 36726 Usage Notes[/h] You cannot use SuiteScript to update the Status field on inventory count records. You must set this field by clicking the Start Count button manually on the inventory count record in the user interface.

in How to Approve an Inventory Count via RESTlet? Comment by NSThriver May 7, 2018 5:59PM
I *think* I might have figured it out using these settings

in Balance Sheet 1 Aggregated Column Comment by NSThriver Feb 9, 2018 5:29PM
I'm not sure if there is anything I could do to hide or obscure the Items page (List->Accounting->Items or Lists->Website->Items), but one thing that could be done, in case anyone is facing or will face this problem as well, is throw an unauthorized access error, whatever that means to you. On load and from the item…

in Creating Custom Vendor Role and Center Comment by NSThriver Feb 14, 2018 7:54PM

NSThriver Green Ribbon

Comments