3942423

I have been using ER for over a year with MS Access and Crystal Reports. I hear Putty will be no more!!!!! I haven't played with it lately but it sure sounds like the upgrade is way better.

in Everything Anyone ever wanted to know about ODBC and NS Comment by 3942423 Oct 5, 2006 5:29PM

We use Dymo to print our labels. I have code posted on the forum somewhere. If you would like the code, I can post it again. **If you don't want to mess around with code, I'd go with the Solution Provider.

in Label Printer? Is there one compatible with Netsuite? Comment by 3942423 Mar 25, 2009 1:16PM

We have implemented the functionality for converting non-inventory to inventory items. In order for the conversion to work, it would require the COGs account to be different. The main intent of this is to allow the system to determine when the item type conversion took place for costing purposes. Is there a bulk way of…

in Converting 1826 Non-Inventory to Inventory Comment by 3942423 Mar 19, 2009 11:21AM

Ok, it is not a bulk update, however, I have cut down much of the headache. From the results of my Saved Search that returns the Items I want to convert I click on Edit (open in new tab, by clicking the wheel button on my mouse). The code below fires and converts and saves the item. Then the tab closes. I added to the Page…

in Converting 1826 Non-Inventory to Inventory Comment by 3942423 Mar 19, 2009 2:52PM

If you don't want to take the time to delete them, you can Inactivate them. Go to the list of Saved Searches, click Show Inactives on the bottom left, put a check beside each one you want gone, Click the Submit button on the bottom right. Then uncheck Show Inactives.

in Delete Multiple Searches Comment by 3942423 Aug 18, 2009 12:55PM

I was able to do this with a transaction summary search. Criteria: Mainline = T Shouldn't Mainline = F, if you are checking line items?

in Find customers that have ordered at least two of a list of items Comment by 3942423 Jul 23, 2009 12:39PM

I did not know that! Thanks Guys!

in Find customers that have ordered at least two of a list of items Comment by 3942423 Jul 23, 2009 1:13PM

Lyn, Being able to know why you made a saved search would be very handy! I would also like the ability to Save my Saved Searches into Folders, just like the the Documents\File Cabinet.

in Can I log the reason for a saved search in the search form? Comment by 3942423 Apr 21, 2009 12:08PM

mgoodman, Thank You, this worked perfectly: DECODE(TO_CHAR({trandate}, 'YYYY'),'2006',{amount},'2007',{amount},'') It combines both years into one column. Off the top of your head... How can I use a range inside a formula? IF {grossamount} is greater than 1 and less than 100 then sum the {grossamount} IF {grossamount} is…

in Formula between 2 dates Comment by 3942423 Apr 15, 2009 12:40PM

Thank you for helping me out! These formulas are for a 'CrossTab Query', so I need to hard code the dates; 2009, 2008, 2007 and 2006. I wanted to combine 2006 and 2007 into one column. All 4 columns have the same Field and Summary Type. Results tab: Field: Formula (Currency) Summary Type: Sum Formula:…

in Formula between 2 dates Comment by 3942423 Apr 15, 2009 11:51AM

We have 100s and 100s of saved searches. We have made it mandatory to name your saved searches with our convention: Department: Type: Description: (Grouped) ie: DevCom: Customer: Over $1000 (Prov, City) C2C: Elaine: Ontario Area (SUMMARY) IntStaff: Support: Monthly: ( KAW) This way you can scroll down and find your…

in How to find out which searches are not used anymore? Comment by 3942423 Apr 9, 2009 1:09PM

Why can't NS just add a folder structure for the saved searches. It would be nice to have all our departments' saved searches in their own folders.

in How to find out which searches are not used anymore? Comment by 3942423 Apr 9, 2009 1:01PM

Criteria: Use Expressions- Checked ( ThingName Is "Blue Thing" OR ThingName Is "Red Thing" ) AND ThingName Is Not "Green Thing" (if you want a date range add 'AND' to the above line then add a new line) ThingDate (with the criteria you need for date) Results: Name ThingName ThingDate If you want the latest entry, then…

in Want to select Contact where one custom record exist and another does not Comment by 3942423 Mar 11, 2009 11:42AM

Evan, I started with your example within the Results tab: Formula (Numeric) INSTR({item.custitemsponsor},{customer.custentitylastname}) I then used it within the Criteria tab: (after removing it from results tab) Formula (Numeric) INSTR({item.custitemsponsor},{customer.custentitylastname}) filter is greater than 0 It works…

in Compare two Criteria fields in a Formula Comment by 3942423 Feb 24, 2009 12:16PM

I made a quick Saved Search to produce the checks we print. I am not an accountant... Transaction Search: Criteria: Account: is 110 Bank Accounts : Bank - Checking (our check writing account) Date: is within this month Type: is Bill Payment I checked the results against Checks waiting to be printed and they were there. I…

in Create Check Register Comment by 3942423 Aug 12, 2009 5:48PM

I went to Reports --> Vendors/Payables, A/P Register--> Customize Clicked on Filters Added line new line Transaction Type, set that to Bill Payment, from the Vendor Register Transactions folder. That produced the same thing with more info... Once again, I am not an accountant.

in Create Check Register Comment by 3942423 Aug 12, 2009 5:58PM

Oliver- I was hoping to create the line numbers before we export it to Excel, just trying to save the end user having to do it. Mark- I am interested in the portlet idea though. Do you have some code to point me to or some documentation? Anything would be helpful. I haven't played with Portlets yet.

in Formula for Incrementing Line Numbers on a Saved Search Comment by 3942423 Jan 8, 2008 12:16PM

For fun I put it in a portlet and added line numbers. I also exported to Internet Explorer and was able to add line numbers there too. Thanks for the help

in Formula for Incrementing Line Numbers on a Saved Search Comment by 3942423 Jan 11, 2008 2:43PM

Eric Thanks for the quick response!!! You gave a ton to chew on. Thanks for giving an example too.

in Featured Items: How do you control the look? Comment by 3942423 Aug 1, 2006 5:25PM

I found a solution. <SCRIPT LANGUAGE="JavaScript"> var myAlert = '<%=getCurrentAttribute('item','salesPriceHTML')%>'; alert(myAlert); </SCRIPT>

in Assign getCurrentAttribute to a variable Comment by 3942423 Aug 8, 2006 6:21PM

In addition... Can I use IF statements to control which template I want to use for the differnent types of items and then drop the HTML into it... IF Item Type = Information then insert Html code that changes the look of the row IF Item Type = Donation then insert Html code that changes the look of the row ...and so on Is…

in Featured Items: How do you control the look? Comment by 3942423 Aug 1, 2006 12:07PM

This worked! var ContactID = nlapiGetFieldValue('custitemsponsor'); var CompanyID = nlapiLookupField('contact', ContactID, 'company');

in Find Company using a Contact ID Comment by 3942423 Feb 4, 2010 12:10PM

I found this: var id = nlapiDeleteRecord('contact', 44390); and it works, now I just have to find the ContactID from the nlapiLoadRecord.

in Delete Contact with AfterSubmit Comment by 3942423 Dec 17, 2009 3:06PM

Seeing how the Contact is created after the Lead is Saved/Submitted...the afterSubmit code to delete the Contact does not fire because the Contact is not made yet. Now... I will try to figure out a search that will trap a new Contact, generated from a Lead, that was generated from the Registration page. Then get that new…

in Delete Contact with AfterSubmit Comment by 3942423 Dec 18, 2009 11:49AM

Come on! Someone has to have something!!!

in Populate Item Options on Cash Sale. Comment by 3942423 Dec 1, 2009 6:53PM

Thanks for help, for a quick fix I used: if(CenterNum == '108-011' || CenterNum == '108-014') { var values = new Array() values[0] ='2'; <span style="color:'"Blue"'">nlapiSetFieldValues</span>('custitem_available_in_communities', values); }

in Selecting Items in a Custom List Comment by 3942423 Nov 13, 2009 11:45AM

I got it to work the way I want it to. If there is a better way, feel free to tell me. function xUpdateBadges() { <span style="color:'"Green"'">//**Get Data from Customer record </span> var record = nlapiLoadRecord('customer', nlapiGetFieldValue('entity')); <span style="color:'"Green"'">//Populate Array from Current Badges…

in getFieldValues doesn't work on 1 item selected Comment by 3942423 Oct 16, 2009 5:40PM

I know this doesn't answer your question, but... I think this is the first time on the forums that somebody said, NetSuite is too fast!

in Pop up way too fast Comment by 3942423 Sep 17, 2009 5:50PM

Yang & Eric, thanks for the replies. I was able to get it to work with much less code, but. . . I can only get through 33 cash sales before I hit the API Governance limit. Does anyone know how I can optimize the code to do more at a time? Update: Added on Aug 27, 2009 In the sandbox it would only run 33 at a time In our…

in Update Class on a Cash Sale Comment by 3942423 Aug 21, 2009 6:32PM

Now to get rid of the code I don't need and clean it up a bit: function xGetHowManyChildren() { var arrSearchFilter = new Array(); arrSearchFilter[0] = new nlobjSearchFilter('company',null,'is',nlapiGetRecordId()); arrSearchFilter[1] = new nlobjSearchFilter('custentitychildcentre', null, 'noneof', '@NONE@'); var…

in .length error Comment by 3942423 Aug 10, 2009 6:04PM

3942423 Green Ribbon

Comments