khultquist Red Ribbon

Yes, I setup the exact same thing with odbc through Excel. It works pretty well, and we still use it. The downside is that it's slow to refresh the tables and it's subject to my poor vba skills. For the most part I replaced here with custom popup windows through scripting, the popups are html and javascript pages (stored…

Yep I used that code too, worked great.

I just ran into this too, only I'm not using IE, using Chrome. Just like tmargot, my file contents for CSV are binary. Same file renamed to .txt is plaintext.

It was successful in my test, here are some screenshots

I suspect you have a problem in the condition of your CASE statement. Create a test search for Sales Orders, have criteria of status=Sales Order:Pending Approval (don't use a formula), have a results column of Formula (Text) with {status} as the formula, and see what the actual value is.

you could nest your case statements CASE WHEN NVL({custitemscp_26},0) > 0 THEN 'In Stock' ELSE CASE WHEN NVL({custitemscp_global},0) > 0 THEN 'In Stock' ELSE... END END

How about this instead CASE WHEN {optimuscutomfield} + {SCP26Customfield} + {scpglobalcustomfield} + {horizoncutomfield} > 1 THEN 'In Stock" ELSE 'Not in Stock' END As long as the values numeric, non-negative, not null.

does it work when you invert & simplify it? CASE WHEN {FIELD1} IS NULL OR {FIELD2} IS NULL THEN 'N' ELSE 'Y' END

Liz - these fields work for me on an Invoice search: Amount Amount Paid Amount Remaining as well as an equivalent formula for amount paid: {amount}-{amountremaining}

Sure, happy to help. You have a mix of single and double quotes. Maybe that is the error? Also you could use shorten your formula by using NVL instead of NVL2

I pulled that formula from an Item Fulfillment field that we use... so one of those fields must not work on the transaction type that you are using. What kind of transaction are you using? With Sales orders there are a few different quantity fields to consider: quantity, quantity committed, quantity fulfilled, etc.

You should simplify that to CASE WHEN {itemtype}='InvtPart' then CASE WHEN {vendorname} IS NULL THEN 'N/A' ELSE {vendorname} END ELSE 'N/A' END

Sarah - what you're describing can be done in a summary search. Results Tab Item (Grouped) Bin (Grouped) Formula (Sum) and the formula should just be the difference of 2 fields, not 6. You also should consider using this formula: {quantityremaining} - {quantitybackordered} because this will account for backorders. HTH

Steve - In production, you could get alerted for new employee creation by using a saved search with email alert. You wouldn't get the "Welcome" email, but you would get notified.

Can you temporarily turn off your script? Or apply it only to customers, not prospects?

al3xicon No sorry to say I never did

Another option is to create a script to that imports a CSV/txt file from your cabinet and builds an Inventory Transfer. If you have someone on staff to build it one-time, it wouldn't take all that long.

ReferenceError: "disableCurrency" is not defined. (NLRecordScripting.fieldChange.f.currency#3) Looks like you have a script running on this record?

Is the same item on the PO in different lines?

SQL formulas won't work, I found that out when I was trying to parse data from a 8,500 character long field. But javascript has no problem handling long text. See this thread: https://usergroup.netsuite.com/users/showthread.php?t=27735&highlight=long As an ugly work around, you can create custom, hidden fields like…

Thanks kk. In my case I am going to reactivate any bins with inventory, so it works in my favor that the items stay in the bins and I don't have to transfer them back in.

I ended up writing a script to do it

Same problem

rnedelkow is there going to be further information posted about this outage that lasted 10 hours (for us)? I feel like we need more of an explanation than what's on status.netsuite.com

rnedelkow here's the response I got from support. This is not very forthcoming and definitely not a 'root cause analysis' [INDENT]"Some of our customers experienced an interruption to our service July 24, 2018 due to a power outage at one of our east coast data centers. This has now been resolved and NetSuite is fully…

TAG BrandonF - These are the ones I captured and sent to my users today. I think there were a couple more but I don't have them. There is an ongoing incident in our NA East facility due to an unplanned power interruption. The incident is affecting the service for customers local to that data center. Our engineering team is…

KWestvik same here, we can login but are pretty much spinning our wheels, cannot access records or searches.

I'm not going to speculate on the cause, but it must be more that "unplanned power interruption" on https://status.netsuite.com/ Highlights from http://www.netsuite.com/portal/assets/pdf/ds-data-center-factsheet.pdf • Backup Power Systems: NetSuite has designed a solution for clean, continuous power. Uninterruptible Power…

Still having errors in Chicago

While I can understand that operational issues come up, this is really, really unacceptable to be down for 6 continuous hours (and counting). NetSuite's documentation states that power is redundant with UPS's and backup generators. Disaster Recovery is "push button" that is tested twice a year.