That does help a little. Exporting the Pivot-table isn't really efficient, but at least I can export something. And have done a print-screen for the pivottable to keep the formatting. Hopefully there will be some enhancements added.

Thanks Leonard. Unfortunately for us, our payment processor doesn't accept that a company the size of Oracle doesn't have any security measures in place for a Credit Card Cracking intrusion. Our ecommerce is completely stuck in the mud until we move our ecommerce off NetSuite or we pay NetSuite for a customization. If…

That sort-of answers my question. I don't really understand enough about scripting to implement it, even though the examples are really straight forward. I can't find instructions for "My first SuiteScript"

Thanks all. This was incredibly helpful!

Yeah, it is working. It looks like I was using an activity search and not an event search, so maybe that is the crux of all of my problems.

Thanks @Pauline Joy Cac-Oracle, it turns out that we were upgraded to a new TIME-OFF Management Bundle which caused the issue we were having. Here is further information should others have a similar question/concern... 1. The Time-Off Calendar Event was previously removed when the SuiteSuccess Approval bundle which…

Thanks @Pauline Joy Cac-Oracle I had the custom tab hidden, but now it is all good.

@Ivy Lopez-Oracle, if I did that would I be able to use the 2nd field in an update import? I thought InteralID & ExternalID were the only fields that could be used in an update

I know this is an old thread, but... I have 2 ancillary systems that both have customer creation coming over. Is there a way to make a field act as an external ID? System A has a unique ID and System B has a unique ID. NetSuite Customer 1 will receive an import from either (or both) table-A or table-B... why I need to…

Is Anyone using single label rolls? I have labels that are 1.2" x 0.85" (actual label size: 1.1875" x 0.84375") In the Advanced PDF/HTML form, the page size shows as "Letter" size paper. I usually am not bad at BFO but I am really struggling with getting the sizing correct. Anyone have something they would share?

Something is still not quite working... <table align="center" border="1" cellpadding="1" cellspacing="1" width="550"> <tr> <td> <span style="color:#564240;">1700 University Dr | Fort Worth, Texas 76107</span> </td> <td> <p style="text-align: right;"> <span style="color:#584240;">3220 Botanic Garden Blvd | Fort Worth,…

Thanks Jack, this worked great

Thanks!!

They do have different Center Tabs. I hadn't given them "SuiteAnalytics Workbook" and now they can see portlets, but they cannot actually see the worksheets. I made sure that I shared the workbook with that role.

It appears that at least some non-admin roles are able to pull analytics with no issues.

Screenshot below Center Type = Sales Center No Restrictions, the below is my user account and in that role I cannot see Analytics and have no problem in ADMINISTRATOR I have used multiple browsers, in private mode and cleared the cache

My Sales Team still cannot access Analytics. I went through the instructions on SuiteAnalytics Workbook permissions. They have Analytics Administrator within Permissions>SetUp, even though there were no explicit instructions on adding that. My organization does not use SuiteAnalytics Connect and Workforce Analytics would…

@Jack Daryl O Espiel-Oracle, If I use those steps will it change to that form that I stipulate or is that, only if the current form attached to the record will execute. If I need to change the form in the workflow, how do I do that? In my case, the form that SCIS uses has very minimal fields avail, so I would need to…

Yeah, I think the system cannot act as a ticketing system (at least easily). Until I can write java-scripts I think we will have to multiple systems to sell tickets and sell merch and do our accounting system. I think seeing the limitations are creating as many disparate systems as we were trying to remove by picking up…

Any thoughts out there @Mikko De La Fuente-Oracle, @Pauline Joy Cac-Oracle, @Jack Daryl Espiel-Oracle ??

No results, so does that mean I have no out of balance sales orders?

That's great. much easier than a support case

It is definitely something in his employee record. I would say, view his record and expand all of the submenu's (the box on the right of the list of submenu's). do a search (CTRL-F) on his "Jon Beer" look for all the places it occurs just as that and compare to your account.

Is it just Jon? Also, check his ID, that is often when you see duplication. For instance, this is how I list my employees: Also, in General Preferences (it might show why)

Thanks @Pauline Joy Cac-Oracle, I was afraid that was the answer.

When I say out of balance I mean. You purchased from our website 7 yellow roses, 3 white tulips, and 2 loquat trees to you. You paid online. When the order came in to us, we were short on loquat trees and had to return your 2 loquat trees. I want to make sure that we didn't return an item to you and forget to refund you.…

@Shamaine Chan-Oracle, unless our balance sheet is built incorrectly, including the detail, I don't see any Sales Orders. Within the detail piece of my different AR accounts I see INVOICES, PAYMENTS, CUSTOMER REFUNDS,& DEPOSIT APPLICATIONS. I don't see any Sales Orders or Customer Deposits.

Any thoughts out there?

Once I created a custom segment to the system and added that field to all of my items/transactions I was able to get the report to work properly. Thanks.

@"PaulFleetwood", I would love some sort of guidance. I'm afraid I will need to do all that you did as well. Did you find that most of this had to be done outside NS or did you accomplish it within the constraints. I'm a whiz with Excel, but hate to have to buy a software solution that has more questions than answers, so…