3943513 Green Ribbon

you shouldn't need that script now - one of the upgrades brought that functionality in as standard. If you go to setup > enable features > transactions and turn on the 'gross profit: Track gross profit at the item and transaction level' thing it will then give you extra column fields which calculate gross profit for you.…

I was told in this thread https://usergroup.netsuite.com/users/showthread.php?t=19559 That it was supported but I'm not sure...

in what context are you using nlapiSearchRecord?

yes, i know they calculate automatically - I haven't put in any code to set the amount myself. I have left Netsuite to calcualte automatically but I still get the error. The full code is shown below (the error alert comes during the second batch of nlapiSelectNewLineItem): function addLoanItemstoTransactions(){ var…

The transaction in question has a discount item in it which means the total amount for that line is indeed a negative. However, this script has always worked before (we have supplier discounts on most of our transactions). Is this something Netsuite have changed recently?? I would have thought it was fairly obvious that a…

do you know if there are plans to roll out the PO Vendor / PO Rate functionality to Estimates? Currently what we want is EXACTLY what the PO Vendor / PO Rate thing does...

have you got a copy of the Suitescript Reference Guide? It has a list of all the operators etc. for the search joins etc.

voted!!!!!!!!!

OK, so I've figured out how to get the transaction ID (record.getID()). However, now I've figured out that I've got a pretty serious problem with my script. Probably down to some changes since the last roll out?? Code is shown below (I've stripped it down to pinpoint the problem): function clearLocProcessedonBills() { var…

i've just had the same problem but nlapiGetFieldText worked ok for me. what's the set up of the custom field? What type, store value?, etc. can you post the script too?

I've tried calling nlapiLoadRecord which works ok but when i try to call nlapiSubmitRecord I get an error message saying RCRD_UNEDITABLE That record is not editable. I'm trying to submit data to the Sales Order as it is approved (using nlapiSubmitRecord). I guess the record is locked until the approval process is finished?…

I tried loading the record but I think this isn't possible on a record that's in the middle of an approve process. Can you confirm that is correct?

I can't use nlapiSubmitField as I'm trying to change things on the line item. I think I have to run it as a sheduled script which loses me the 'real time' thing but I guess I don't have a choice! Thanks for your help. Cheers,

ok, i've found out that only some of the fields are being written on an approve so if i want to write to others I need to use nlapiSubmitField and nlapiLookupField However, these only work on body fields. I'm trying to reference the line items. Are there comparable functions to nlapiSubmitField and nlapiLookupField that I…

great - thanks!

I've just clicked on the significance of Oliver's last post. From the help pages I've just found this: Best Practices: Users should be doing post-processing of the current record on an afterSubmit. Use Case: 1. Load the record you want to make changes to by calling the nlapiLoadRecord API. Do NOT load the record object by…

Thanks for the pointer Oliver but i'm still having problems. I've stripped my script right down and still can't get it to work. So I have a User Event script running on BeforeSubmit. I have deployed it to apply to Sales Orders, status = released, event type = blank. The script is below: function…

Did this issue get resolved? I'm having trouble getting nlapiSendEmail to attach my email to the custom record (for viewing later): var emailRecords = new Object(); emailRecords['customrecord_partnerapplication'] = id; var emailFields = new Object(); emailFields['NLFULLNAME'] = name; var subject = 'Thank You For Your…

that's the puppy. perfect, thanks!

did you ever get anywhere with this? I am trying to do the same thing. The suitescript reference guide indicates it should be nlapiGetFieldValue('vendor') but that is returnning null for me. Any ideas?

The error in NS is: Line: 723 Char: 5 Error: Exception thrown and not caught Code: 0 And pog2000 is correct: the ID is '-5' and it is a valid sales rep

that's a great little trick. Never used try/catch before. Love it. The error was: USER_ERROR You have already invited -5 to this event Genius. Now i can fix it! Cheers,

the debugger is something i'm still figuring out. I've been kind of fudging it at the moment by pasting the value into a memo field so i can see what's in it. I think I found the problem and have it working now. I've also set myself up in a proper development environment which is making life a shed load easier. Thanks

Wow, that's embarrasing. I need some sleep... I've switched those around and I still can't get it to work. I'm having trouble getting the values to 'stick' at the line item. I've stripped my script right down to just: function beforeSubmitEstimate(type) { record = nlapiGetNewRecord(); var items =…

Did this enhancement ever get rolled out? I am trying to run a user event script to set the cost estimate type and cost estimate rate. What I'm trying to do is get the cost estimate type to always be 'custom' and the cost estimate rate to be based on a custom line item field (custcol_costmonthly). When I run the script…

nope, already tried that. Just tried it again and get this error: Function: testnlapiLookup Error: SSS_INVALID_RECORD_TYPE vendorcredit Stack Trace: testnlapiLookup(testnlapiLookup:100) testnlapiLookup is the test code i'm running: function testnlapiLookup() { var date = new Date(); date.setFullYear(2008,7,31);…

I'm still on 2008.01 - is there no way of doing what i want to do before I get upgraded?

PS - if anyone is reading this and wants to know the answer to my query above then the solution I came up with was: var memdoc = nlapiGetFieldValue('memdoc'); if (memdoc != null) then don't run the script

I am now having a similar problem to this running a script on an After Submit. I have a script set to run on After Submit for Sales Orders. However, when someone updates a memorised transaction the After Submit script is called. This is done by going into the memorised transaction list, clicking 'enter' to enter a new…

have you tried just doing a simple transaction search where: Memorized = Yes Client = Test Client ?? If you've got a memorised transaction it should come up. Alternatively, you could just do a search on all transactions on Client = Test Client and make "Memorized" one of the results column. Does that help?