yeah that would give me a string but I need a number, I think I figured it out using MONTHS_BETWEEN

thanks

turn them both into that

then subtract them

you need to convert them to same type to compare date and date/time

Can you make attachments mandatory to transaction records?

I'm sure you could, but I wouldn't want to be storing stuff in NS I didn't have to (i'm looking 3rd party for that)

I need to delete an employee but am not able to as they have modified folders, customs lists, saved searches, etc. Anyone to bypass this?

Why delete them?

Remove access or inactivate is what I generally do with employees

Boss wants them deleted.

Well, your hands are gonna be tied

yup. i will make inactive and let her know it is what it is and to go to Netsuite Suppport.

Does NetSuite have any shipper integrations that do same day delivery? Our same day delivery partner “Deliv” just announced they are closing up shop...

Does anyone remember what this companys name is? Was sold at suiteworld last year

Hey guys and gals, How do I set a field from a client script?

hy everyone !! Please tell me is CMS (wordpress) right option for integration as a 3rd party application ? and is wordpress support auth1.0 authentication ?

does anyone know how to create a join or vlookup in NetSuite? I have two lists of values Category and Commerce Category but I don't know how to have the Commerce Category automatically determined based on what the Category value is. For instance, when someone selects Winter Hats on an Item record, I want the Commerce Category of Hats, Visor, & Headbands to be automatically selected

Hello all, I cannot seem to zero the expense line amount on a vendor bill. Any advice?

What's it telling you?

its going in but not updating the record

want to see my mapping?

I don't know that I can troubleshoot it that way.

it successfully imports the record, but the amount doesnt change on expense

everything else im importing works

and no errors

You doing it via CSV upload makes it like a 4 part discussion

oh jeez

Are you trying to zero out a single line on a vendor bill? or the entire bill?