David_Jarrell

My Stuff

See All the Unlockable Badges See All the Unlockable Badges

Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.

Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more

Comments

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

David_Jarrell Red Ribbon

Comments