You could look at the math and find out? If you take your ending cash balance and then look at the table, try the math and see what the conversion yields and if it meets your ending balance. I think if your account base != sub base, it has to run through one of the two available fx tables. If it isn't the consolidated…

I think you are going to need to explain a little more here. Are you asking if you can change the base currency of a cash account? If that is the question, the answer is no you can not and need to make a new account. Sorry for that. -OR- Are you saying you believe the values shown in the bank rec are incorrect? If that is…

Ahhhh. That makes more sense to me now. So two things to double check: Since you have multiple currencies, I'd just double check you have enabled the currency function (where netsuite pulls rates daily from Thompson Reuters). It's under setup>company The balance sheet report (assuming you are using the stock version|…

This is obviously an old thread but since I stumbled across it. The landing page element aside, as that requires either customer access or a separate integration. From a payment processor perspective, can't recommend Stripe highly enough. They have a nice tool - suitesync.io which allows you to set up how you treat CC…

I know it isn't SQL, but another post put me onto this. There is a nice extension in Chrome allows you to export any saved search into SS1.0 or 2.0. If anything, quick way to identify some tables and fields. "Netsuite: Search Export". Good luck

We run the cloudextend product currently. It's much more stable but has a different feature set some of our users aren't in love with (won't auto-sync email threads, only one by one being the main one). Just my two cents on the product. 

As of today, yes we have a limited number of users succesfully operating the outlook plugin with SAML (token based authentication). We have outlook version of 1805 (O365) and the laterst plugin version. That said, everytime we blink, something negative happens. We've begun rolling users off SAML to get this functioning…

Nice call there. Glad it worked out for you.

So, my thought process would be that, regardless of how or who gets the bill/journal approved, it must go through an approval "process." I would look to run a saved search that shows "created by" and "approved by" and look at the instances where they match. Below should get you this on the results tab (i've never tried as…

Thanks vanderbeek - if/when i get it to work, i'll post. Glad to hear my thought process was accurate. Onto the design phase....

Are you looking to add fields within the line items themselves (as in a new column)? If you have the form open and you hit customize>sublist fields, you can add fields directly into the line item details. Otherwise, you can add fields under the screen fields option. Not sure I understand the question, but maybe that helps?

There isn't a great solution to this issue. I've been down this rabbit hole a bit. We have a poor entity structure with a sandwich stack. So fun story, NetSuite also rounds rates differently than the TR feed. So it's a consistent issue that a US sub will have 100% a transaction at their sub level and 99.998% of the…

Not sure I understand the difference. Thinking in NS terminologies, most activity in the system which has a financial impact would be classified as a Transaction. Transaction 'Types' include Journals, Bills (A/P), Invoices (A/R), Credit memo's etc. There are various ways to generate each transaction (specifically journals,…

What was your solution on this? I've been looking at this same question lately, as a new admin.

Thanks - just an FYI - we are looking into SuiteBilling to replace our subscription billing. I'll be happy to share experiences if/when we go down this road.

I've never tried this personally, but I would think you could create a saved search (Transactions) with criteria: type = Invoice and within your results, include the following: 'Created From' (should reference you SO) and 'Amount Paid' (how much has been paid on the invoice) as well as any other fields you deem necessary.…

This is clearly from a while back. Did you ever get any insight on how to "mass" update projected totals on opportunties. 

We run Workato. It's designed to be more functional but has a nice developer side as well. From my experience (hubspot, jira [on-prem], servicenow, docusign and zendesk), it's worked well for us. Just another ipaas to throw into the mix. Note: I'm not overly technical, so boomi, jitterbit, etc. didn't make me comfortable…

I have one - it's not a 'standard field' but there was my approach: Transaction saved search: Criteria Type == Journal System Notes:New Value | Contains:Approved Results Created By: (user who made journal) System Notes:Set By |custom label = Approver System Notes:New Value Any others you deem necessary. Hope that helps.

What could be driving this? Never seen this before from NS

We are able to login but also still experiencing the exact same issues with integrations, lists, data access as mentioned above. Entire day down the drain.

Updated ETA?

Same here. We've been down all week, "refresh delayed" and have only received minimal updates from NetSuite. Impatiently waiting on this one.

Ours came back on Sunday, June 8th. Refresh is a little different now. After the refresh, you have to go into SandBox Accounts and 'Activate' the refresh. But, our is officially back, hoping that means they found the solution. 

@ Dejero: We did 'consider' it briefly. Spoke within my network and read up on some of the whitepaper / documentation around the module. Given our Company's user-base and what I'll call uniqueness, it didn't seem like the right fit and would require a lot of customization. We utilize CRM+ from a sales side, but we don't…

Just as an FYI - i've decided to avoid 3rd party. I've built a Custom Record to house the necessary information and display it as a list under a new tab on our forms. Seems to be working well so far, as the primary functionality is a repository and not actions driven. 

nlapiSearchRecord(type,id,filters,columns) Per Usual Suspect 'Type' == Vendor Bills|Vendor Payments etc etc

Hey Brettsuite - Also in the software services vertical and recently I just had to tackle the renewal issue. I looked at the module mentioned above and also discussed this topic with various resources at SuiteWorld 2018. My solution - Custom Record. I built a custom record attached to the customer record to house contract…

What specifically are you trying to load? I am not experiencing any latency issues with Sales related records (customers, contacts, opportunities, etc)

Is this an active group? Set of users in Louisville (KY) looking to join a group. Ok'd to travel down for meetups. We are a software company with ~250 active users, running oneworld and crm+. Would love to join in. Also originally from ATL if that helps.