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.

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.

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…

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…

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.

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

I did not know that! Thanks Guys!

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.

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…

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:…

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…

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.

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…

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…

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…

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.

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.

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

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

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

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…

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

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

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…

Come on! Someone has to have something!!!

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); }

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…

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!

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…

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…