Ben G Red Ribbon

you'll want subscribed not subscribe d in the setlineitem code

yang, i haven't had time to look at #2 but there is another problem: var fields = new Array(); fields[0]='custentity_dd_recurring' fields[1]='custentity_dd_oneoff' fields[2]='terms' fields[3]='entityid' var termsArray = new Array(); termsArray = nlapiLookupField('customer',invRecord.getFieldValue('entity'),fields,true);…

hi, we had several problems with the first release of the 2007 CSV import engine - the rep said there were a bunch of known bugs that they were working through. Issue 125474 covers some - including a null field problem with list/record fields. You may want to call the helpdesk and see if your problem is part of this -…

125836: will this change the records that were migrated incorrectly to v2007.0? all my leads and contacts that were subscribed are now unsubscribed from the new subscription categories...

thanks for the quick response ken 125694 - the workaround doesn't work with 'keywords' or 'contains'

125474 and case 577804 - i've tried recreating it from scratch: Using the "Leads & Contacts" import with 2 separate files, i get an error "Invalid company reference key" but the company field is identical in both records Using the "Leads & Contacts" import with 1 file and not mapping the company field for the contact, i…

lots of good features mentioned, but for me there's one very basic thing that would unlock a lot of the existing features - really good integration with Outlook/Exchange or similar until that's available the tasks, events, calendar, etc are just decoration. Or integrate with Google's calendar, email etc - and adwords etc…

rroscoe - we got cases working again by getting each user to open & save (without changing) their user prefs. seems there may have been a change to the date/time formats (NS now offers non-US things like 24h time) and this change isn't taking full effect until you do this overall, we're running fine on 2007.0 with a few…

hi yang, it is a user event script that runs when a fulfillment is saved. the script has to add an inventory item to a pre-existing purchase order. i've tried it both beforesubmit and aftersubmit what does "changed the line argument to linenum" mean? what should i change in the way i use setLineItemValue from how i used it…

you don't get the outlook integration link in the 2008.1 beta - only in the final release - this is by design apparently, i assume the client app talks only to the live servers etc. ben

the 2007.1 release shouldn't have been released without this! i'm glad it was, given the delay Hopefully the folks in charge will have learned something from this experience. unfortunately they'll probably have learnt not to rely on third party tech, which will limit the speed of adding new features but yes, we desperately…

and does it include the 'save email to netsuite' feature?

It will include integration with events and tasks, obviating the need for IntelliSync. Evan, this is great news for those of us struggling with intellisync but will the events & tasks be automatically synced? if the sync requires a manual action, it won't work - e.g. calendar items created in outlook need to be copied to…

bump............

ah, that simple! it works now, thanks all ben

hi, i still get the error when i comment out the lines you describe. i've got case #625192 open for this - they have found a 'Column not found' error -ben

thanks yang, not sure what i've changed but this works now a new issue: i'm using a suitelet to show a list of cases in teh customer center. if i include the 'closed' field (date case was closed) as a column i get "An unexpected SuiteScript error has occurred: list.addColumn('closed','date', 'Closed', 'LEFT'); i have that…

(btw, email notifications from the forum have stopped coming through - i can't see them in my spam filter either) here's the code - the commented-out line causes it to fail thanks ben var list = nlapiCreateList('Case Time Analysis: Results'); var company = nlapiLookupField('customer', nlapiGetUser(), 'entityid') var column…

if i try to access an html suitelet (not using any netsuite UI objects) without logging in i get INSUFFICIENT_PERMISSION Details: You do not have privileges to perform this operation id 13757 this is despite script deployment settings: Execute as Admin Yes Available Without Login Yes the offending code seems to be var…

i also want to show Jobs in the customer center... and probably much more once i put my mind to it... ;)

yes - for the domain i gave https://system.netsuite.com/ - is that right?

Hi Yang - one UI annoyance with this - you can't click the customer record's tabs until the google data has loaded - is there any way to disconnect this process, so that the page is usable while the google stuff is still loading?

yang, mat - i just tried our googlemaps tab in netsuite (based on yang's previous code) and it works fine - so it's not a change in google's API nb if you're using safari on a mac, try http://webkit.org/ for the latest build + Drosera - it has useful debugging functionality sorry, don't have time to help more! rgds ben

yang, i found the IE setting for the popup warning - in internet options > security > internet zone > custom level, enable “display mixed content”

yang, the other problem was locale & address format: add this line to set the locale to GB (UK) response.writeLine('geocoder.setBaseCountryCode("GB");') and in "var address..." replace billaddress with zipcode for some reason, google doesn't like full UK addresses - even though the normal google maps web site is fine with…

they have to be capturing COGS for each transaction as the Inventory Account is debited. careful... this is true for inventory items but not non-inventory items. you need code to grab the non-invty item's cost and calc the GP. For example if you resell virtual goods & services such as internet connections, microsoft…

brett, this needs commissions turned on in your 'enable features', which may be the module you mention - but here's how i'm approaching the problem: - enable alternate sales amounts (asa) - make sure all inventory and non-inventory items have both sales & cost prices - use code to keep inventory cost prices up to date from…

yiggy - that's great - thanks! couple of issues 1. the map controls appear but not the map. if i click any of the controls i get a javascript error such as "'undefined' is null or not an object". variously lines 361, 367, 478 of scriptlet.nl are blamed. 2. on loading the customer record, IE pops up the warning about…

another issue to add to the mix: it seems that if you use a beforeSubmit server script to set the ASA values, the total ASA on the sales order doesn't get updated until you edit the record again - so the script that sets the asa needs to load & save the SO in an aftersubmit section.

i’d really welcome evan or yang’s view on the following – i have the same issue as Brad, that i need to calculate commission on the profitability of non-inventory items as well as inventory items. We resell a lot of non-tangible items (e.g. online services) and it's too risky to apply a commission % to the sales value and…