David_Jarrell

We have the same problem. Did anyone ever come up with a solution or workaround?

in Need Credit Card Failures to set Sales Order to Pending Approval Comment by David_Jarrell May 9, 2017 11:08AM

I see what you are saying. What I'm really looking for is a 'foolproof' way to know that a SO failed to become a Cash Sale because the card was declined for any reason.

in Need Credit Card Failures to set Sales Order to Pending Approval Comment by David_Jarrell May 9, 2017 12:36PM

Correction: the correct formula is case when {taxamount} IS NULL then ({amount}-{shippingamount}) else ({amount}-({shippingamount}+{taxamount})) end

in Transaction Search - Subtotal field Comment by David_Jarrell Oct 20, 2017 2:26PM

Amount (Net of Tax) returns nothing for me - just a null value. I've been using this formula and it seems to work fine for me: case when {taxamount} IS NULL then ({amount}-{shippingamount}) else ({amount}-({shippingamount}+{taxamount})) null end It subtracts tax and shipping from the total unless there is no tax in which…

in Transaction Search - Subtotal field Comment by David_Jarrell Aug 29, 2017 1:35PM

Thanks for the tip on the NVL() function. Love learning new things!

in Transaction Search - Subtotal field Comment by David_Jarrell Nov 13, 2017 9:16AM

Bummer. I'd like to be able to set it. Thanks for the answer though.

in Setting Expected Ship Date on Sales Order Line Item Comment by David_Jarrell May 4, 2017 8:46AM

Good feedback - thanks!

in Enable Departments Purely For Permissions? Comment by David_Jarrell Jul 12, 2018 5:20PM

How incredibly useful! Thanks so much.

in NetSuite Field Explorer - a new Chrome extension to discover NetSuite field names Comment by David_Jarrell Aug 28, 2017 10:11AM

Same here - started at 3:23 PM EDT. status.netsuite.com says everything is "rosey".

in Unexpected Errors Everywhere Comment by David_Jarrell Jul 28, 2017 3:36PM

Sam, Have you ever used REST API to connect NetSuite to Shopify? Just curious. Thanks

in We've come to a fork in the road. Comment by David_Jarrell Jun 8, 2017 3:55PM

Thanks John. This worked perfectly.

in Adding a User Note to a Sales Order via scheduled script, looking for code snippet Comment by David_Jarrell Nov 20, 2018 12:42PM

So, I got this working by using the event of Before User Submit, the Field of Terms and a Formula value of ''. Just in case anyone wonders how it was solved.

in Need To Clear Value Of "Terms" Field Via Workflow Comment by David_Jarrell Jan 23, 2018 8:52AM

MFA for Oracle Community

David_Jarrell Red Ribbon

Comments