-
Access To Custom/Saved Reports
Hi Guys, Hopefully this hasn't been covered already...! I have created a saved report based on 'Open Sales Orders,' access to the original report is given through the 'Reports:Sales Order Fulfillment Reports' permission. Although the role that needs this report has been given access, it is unable to see the custom report…
-
Customer Addresses Search?
Is it possible to create a custom search that returns all addresses for customers? I couldn't find a join for this in the Customer search. Thanks! Dave
-
Results output Mutliple rows
I am trying to create a search based on the System Notes. Here is how my Results tab is set: Field: Sales Rep Summary: Group Formula: Field: ID Summary: Count Formula: Field: Formula (Date/Time) Summary: Formula: CASE {SystemNotes.FIELD} when 'XXX' THEN {System Notes.DATE} END Field: Formula (Date/Time) Summary: Formula:…
-
Monthly / YTD Variance Reports
Is there a way to create a report that has budget vs actual with both the current month and YTD on the same report? Current Mo YTD Actual Budget Variance Actual Budget Variance Revenue Gross Profit : :
-
creating a search for avg products per order
Greetings, I am hoping to create a search to add to my KPIs-- which would show me average number of products per order... Any ideas? Thanks! Lorna
-
Possible to highlight after summarizing?
Is it possible to highlight a row after it is summarized. For instance I am doing max trandate for customers so I see the last time they ordered. I now want to hight the rows were the max trandate is before 45 days ago, but when I add the highlight nothing happens even though it displays dates that are 45 days ago.
-
Not getting complete results
We sell books and on the website the books are under different (multiple) categories. We also produce a printed version of our catalog, which we would like to get from NetSuite. The search to get all the books and all the basic information works fine; however, under the results of the search tab I have selected Category.…
-
System Notes access
Hi All, Ive read many other posts here and I cant find an absolute reference to this anywhere. Has anyone been able to reference the System Notes records as a FORMULA? Support has told me what I already know - that being that I can make basic reference to the SN fields by selecting them in the pulldown - but there is no…
-
Course Roster Search
Here is my situation: We offer courses that people sign up for online. They either pay with a credit card and the Sales Order goes to a Cash Sale or they have an account with us and the Sales Order goes to an Invoice. As soon as they place the order, we fulfill it and send them the course information. The problem is that a…
-
Customer in Search Criteria
I have created a saved transaction search that references the customer. I would like the feild to show only the custmers name (entityid). But when I run the report get the parent's and the child's name. Example: What I get - Partent Level 1 : Parent Level 2 : Child What I want - Child Any ideas? I tried a formula text =…
-
Building a bespoke report
Hi, sorry I'm still a bit of newb with reporting, and i've been asked to make a bespoke report. I have created and customized reports in the past so I am aware of the UI etc. but I am a little confused of the limitations that are presented to me when building the report. It'll be easier to first explain the report i'm…
-
Customer Parent Child relationship
I have a parent customer who signed a pricing contract with us. There are approximately 50 children associated with this parent. I need the parent customers pricing to be carried over to the children but I also need each child pricing to have ability for additional exclusive pricing. I was told this was not available and…
-
Delete saved search
I've asked support about this, but they couldn't tell me how to do this & are possibly still working on it, so thought I'd ask you folk: As administrator, I created a saved search, then created another one from it. The two searches now seem to be permanently interlocked & I cannot delete either of them. If I mark one as…
-
Customer Status - Inline Edit
We have some scripting controlling the 'Status' field through selection of checkboxes - As such, the 'Inline Edit' functionality allows users to (accidentally) modify the Status field when in a list view rendering it out of synch with the checkboxes. Is there a way to prevent inline editing on the Status field only while…
-
After Class follow up
I attended the online advanced reporting class today. However, since the class was not interactive, I have a few questions. Maybe someone here can answer them? #1- Is it possible to do a saved search with alert, when a specific field is modified in an entity record? For example, send an alert to our accounting department,…
-
purchase order unfulfilled report?
I need to be able to print purchase orders, in detail, showing only those items not received. For instance, I have 8 purchase orders with a single vendor in various stages of receipt. Today I had to manually piece together an email to them going thru each purchase order and typing out those items in that purchase order…
-
Sorting on Last Name for Sales Reports
Our customer default type is individual. I am trying to create Sales reports that will list First Name and Last Name of customer in individual fields so that I may sort on Last Name. Unfortunately these fields aren't available, only the name field is (which includes Parent/Child, First, Middle and last name). I know I can…
-
How to get custom field to show in customer center?
Hello, I created a custom field that is part of our sales orders and I would like to have that field listed when the customer clicks on the link to their sales orders search in the customer center. That custom field shows up on our internal lists and the customer does see it when they pull up a specific transaction. I just…
-
Saved search on number of contacts?
I'd like to do a saved search that shows how many contacts each customer has. I tried just counting the contact field but that only returns zeros. This is an unusual request I realize, but we really need it.
-
Knowledge Base - Links to all solutions broken w/ 11.0.6?
Upgraded to 11.0.6, and all of the sudden all of my solutions are not viewable. Background: - we have created a separate tab for our internal KB - tab show up fine, as do topics, and sub-topics - when clicking on a link that would go directly to a solution, get an "unexpected error" - this same unexpected error occurs…
-
No alerts for document searches?
Is it possible to trigger an alert whenever a new document is uploaded to the file cabinet? I can create a document saved seach, but there's not alert tab for document searches.
-
Show Search with 1 Result
Does anyone know how to force a search with only one result to still display the results in the search screen/format and not go directly to that record? Many thanks! Jim
-
Resource Saved Search ... where's the 'Owner' field?
I've got a saved search that alerts me whenever someone books a resource (like a laptop or projector) that the IT department is responsible for. Right now I need to edit the search to add or remove resources as they change (new laptop, projector getting repaired etc). I'd like to change the criteria to just those resources…
-
Customer Search - Created by
Is there any way to show who created a customer record in a saved search?
-
Employee Utilization
Anyone run a professional services organization? If you do, how are you managing utilization? Typically you want to manage the ratio between billable and non-billable events. Most consulting organizations want about a 70% ratio if you can. Anyone able to create a report that has this? We have the advanced project module…
-
Compare old value to new value?
Hello, I am wondering if it is possible to have criteria in a search for system notes for system notes.old value <> system notes.new value. I have other criteria that further narrow the search to a particular field, etc. but this is the part I am stuck on. I'd appreciate any help. Thanks! Jon
-
Saved Search on Notes field
Hi Can anyone tell me it it is posibble to produce a saved search or report on User Notes. If so - how? I know it is possible to search on System Notes. I am not sure of the relationship between User Notes and other so called 'Activities' (Task, Phone Call, Event). Thanks Andy
-
emailing report recipient defaults to customer??
Hello, When emailing a report (clicking on email button at bottom of the report), the recipient defaults to a customer. It seems that the recipient list is populated with everyone in the system that has an email address. I think this is dangerous! A frequently emailed report for us is our pipeline report. In our case, that…
-
Custom Transaction form for a Order(External)
I must be having a bad day, for the life of me I can't seem to find where I can state what parameters I want printed on our External Order. I know I've changed this in the past, but there isn't the normal "Print" tab where you can state what you would like printed. Can anyone point me in the right direction? Thanks Carrie
-
Search engine keywords
I have one item that gets about 1500 unique visitors a month, but I have yet to sell even one. We rewrote the description, lowered the price, everything. When you search for the item name in any of the search engines though, we don't come up at all. I would like to find out what keywords most people are using to come to…