BTW figured this out, The transaction.shipmethod was not pulling the ID like I assumed but the name of the field so I changed my array to name like below ship = ['FedEx International Economy® - No Tax','FedEx Express Saver®','FedEx First Overnight®','FedEx Ground® - Estimate','FedEx International Economy®','FedEx Standard…

This is an email template coming from the item fulfillment so NetSuite Internally we do not use the webstore. 

We still need to use these items to pay vacation time with a time off request. So when a users submits a time off request we still need to pay that on the payroll

Just test try the whole date that gives you in portions of hours then multiply by 24 I express this as formula currency to round (TO_DATE(TO_CHAR({datecreated}, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') - TO_DATE(TO_CHAR({custbody_sfccdatetime}, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS'))*24

Might sound wierd but chage the date to a date. I would also use HH24 so that you get 24. (To_Date(to_char({datecreated},'hh:mi'),'hh:mi')-TO_Date(TO_CHAR({custbody_sfccdatetime},'hh.mi'),'hh:mi')

Awesome that worked just one more tweak..... How can I get the results to be represented in just hours? the working statement CASE WHEN TO_CHAR({custbody_ready_for_approval},'D') BETWEEN 2 AND 6 AND TO_CHAR({custbody_ready_for_approval},'HH24' ) < 15 THEN to_char({custbody_ready_for_approval}-{custbody_approval_date_})…

I am getting close but can't seem to get the case statement working without getting an invalid expression. I know the then statement works on its own but as soon as I put this into my search it no longe works CASE WHEN TO_CHAR({custbody_ready_for_approval},'D') BETWEEN 2 AND 6 AND…

Well I figured it out if anyone ever searches for this you can still get the sublist value in the client script

figured out my issue. Had main line set to false that is why the paying transaction date was not showing up

I just created a search that shows the last time an item was used on a Work Order but you could possibly use it to show the last time an item was on a sales order as well Item Search Filter Transation: Type is Work Order Results Name Summary Type Group Transaction : Transaction Number Summary Type Maximum When Ordered By…

We have created a Rewards Program by using saved searches and fields plus a bit of suite script. It was pretty straight forward. Right now we pay our rewards out via credit memo once a year but we are moving with the ability to use these at any time. Here are a couple of things to keep in mind 1. What event triggers your…

So two days in a row with over 2 hours of outage. Does anyone have an ETA on the Latest Outage?

Yes the same thing when trying to build workorders must be systematic

So I tried this and it did not work I created two separate xml strings and combined them. Thought that would be a great idea... now I see why not but sure did give it a shot. Error Parsing XML: XML document structures must start and end within the same entity.