T.Watz Red Ribbon

I just tried it on transactions, which is similar, and it worked. Field: Formula (numeric) Summary Type: max Function: Round Formula: trunc(nvl(max(decode({systemnotes.newvalue},'Pending Fulfillment',{systemnotes.date},NULL))-min(decode({systemnotes.newvalue},'Pending Approval',{systemnotes.date},NULL)),0)*24) This gives…

maybe try something like similar to this: formula(text) max to_char(max(case when {system notes: new value} = 'awaiting discovery' then {system notes: date} else null() end) - max(case when {system notes: new value} = 'ready for approval' then {system notes: date} else null() end),'tt:mm') and change the criteria to:…

Ran into the same issue today. Did you ever solve it?

Hi Evan, Thanks for your response! I actually figured it out myself right before I left work. I actually did practically the same thing you've just told me: (sum({pricing.unitprice}*transaction.quantity})-sum({transaction.netamount}))/sum({pricing.unitprice}*{transaction.quantity}) /Tomas

maybe you can try to do something like this: '<div style="float:right">' || to_char({theinfohere},'theformathere') || '</div>' - it works for me :D however, ' ' works for me. even '&nbsp' works.

Have you tried setting the criteria to: Date = on or before today then adding Date to the filters. The "on or before" or "after" or "between" or what ever you choose is retained to the filter all you have to do is then to change the date in the filter.

Hi, have you tried what I proposed? It works when I test it. Or have I misunderstood something? Crireria: Date: "not after" today Filter: Date (same field as in the criteria) This will give you a search that retains the "not after" even if you change the date in the filter.

ApoorvaP, No I have not found a solution for this. pcutler, Yeah, I've looked into that a little bit, but I'm not sure a before load user event script would work since the drop-down would have to be re-initialized if you change the customer on the order form (or if you enter the form clean, ie no customer chosen. I guess…

For example, use the validateLine type in a client script to check if the line has been partially/fully billed, and if so, confirm with the user with using confirm(). Thanks for the reply, we have this as well. Although the sales reps clicks through it and performs their changes regardless. We have been researching to…

See example: var customerSearch = nlapiSearchRecord("customer",null, [ ["internalid","anyof","7049"] ], [ new nlobjSearchColumn("internalid"), new nlobjSearchColumn("email","CUSTENTITY_CUSTOMCONTACT_TEST",null), new nlobjSearchColumn("firstname","CUSTENTITY_CUSTOMCONTACT_TEST",null), new…

Hi Again, if it is a dropdown where you choose the Contact then you can use {custentity_customcontact.email}, {custentity_customcontact.firstname} or any field available on the contact since it is joined. And skip the whole CASE formula. If you recreate the search in the UI, you should have an option in the bottom of the…

Looking at your internal field ID [LIST] [*]custentity_customcontact.ID [/LIST] it seems as the custentity_customcontact isn't just a numeric field or a string, it looks as it is linked to either a custom record or to the contact-records. Can you explain why you need to pull the info from {contact.entityid} and not from…

I did some in-browsing trial and error, and found out that everything resets when I set the {billcountry}. So setting the {billcountry} right after the {billaddresslist} solved it. When looking through the documentation I remember I read about this, but as it has worked for so long. I didn't think much about it. Maybe it…

It seems to be linked to Chrome and not Firefox...anyone has similar experiences? Edit: No this does not seems to be the case. Instead it has to do with it only happening when you edit an order, not when you create a new one. I have gotten an issue filed #394232 if anyone wants to add them to it. [B][B]Issue Number:…

Anyone got this working 100%? I have similar code implemented on the lineinit and on fieldchange. When selecting a row by clicking the item or taxcode, I can see that the quantity field is correctly disabled however if I move to another field, like the rate-field. The quantity field gets enabled again, and I have debugged…

Ha! It feels like I've been trying for hours now and finally got it working. It seems as I couldn't choose the item directly in the matching view. I had to supply the itemID through the CSV-file.

I'm gonna hijack the thread a bit here. I'm trying to add a custom segment to Charges (billing charges used on time and expenses). Anyone knows where I can activate that? I've added it to the invoice,bill, time and expenses columns. I just need the in-between record

Maybe the role doesn't have privilege to see revenue recognition schedules? For us, the field is called "Revenue Recognition Schedule" and when you view the order, it shows a link to the schedule but when you edit the order, you use the field to change template.

Hi, What I wanted was to export the Item-list to an excel. The way I did it was to create a custom header field in the form of an inline html which displays the excel-icon and links to the export of a saved search. https://system.eu2.netsuite.com/app/...&searchid=1902 The saved search has the id 1902 and I've set the…

Where does one find the list of defects? I don't think you can see them. In this case, I filed it.

The two salesreps I had reporting it, actually didn't complain too much of the workaround. They just looked a bit troubled by this alternate way of doing something. Maybe my salesreps aren't the laziest either. :P

Hi. My people are creating quotes and converting them to work around this. Will skew my quote reports for this day, but they like this workaround. Isn't waaay slower then just creating a blank sales order? The only thing you gain is that you don't have to enter the customer/contact manually.

No, the option to add sales order isn't there.

Yes, attach yourself to defect #283131

To revisit an old thread... We are a mediacompany that "deliver" ads. We also measure the amount of orders that are put in netsuite on a day to day basis (google translate gives me "order intake"). To historically have a correct sum for each day we cannot adjust already approved SO's since changing these would affect the…

This is now available as an option in the latest release when you manually want to send an invoice. I can't get it to work though. When I open the mail I never get any notifications of read receipts. I can't see any read receipts on the email in netsuite either. Furthermore how can I use this with the…

Hi, we are trying to do something similar, we have an external form that we want to post using javascript (to get around the stupid redirect) but we have hit a wall with the following: test.html:1 Failed to load https://forms.eu2.netsuite.com/app/site/crm/externalleadpage.nl?compid=[formdetails...]: Redirect from…

Hi, we are trying to do exactly what dominicb is suggesting but we have hit a wall with the following: test.html:1 Failed to load https://forms.eu2.netsuite.com/app/site/crm/externalleadpage.nl?compid=[formdetails...]: Redirect from 'https://forms.eu2.netsuite.com/app/site/crm/externalleadpage.nl?compid=[formdetails...]'…

:Canned" report means any out of the box NetSuite report. I do not think it is possible to pull in unapproved Sales Orders into a Revenue Forecast. Ok, not that it is in anyway easier, but I want to get estimates/quotes in a report.

FYI, I have moved to using two saved searches that shows the full amount for unapproved orders and the weighted amount for estimates. These searches shows me current month,+1,+2,+3,+4 and +5 in columns. This is then combined in excel with the standard report for revenue forecast on sales orders. The formula for one of the…