Seems like you have created a client script so it does not execute on CSV import which is a server side function. Convert it to a User Event script and it should do the job.

function copypopageInit(type) { if (type == 'copy') { nlapiSetFieldValue('custbody1', '1'); //to set a value nlapiSetFieldValue('custbody1', ''); //to remove values on copying } }

hi lorne, yes its nlapiVoidTransaction (i mentioned void record as it was mentioned under record apis section) ... its nlapiVoidTransaction and works for both reversals using journal and direct voids

thanks for the views... found the solution ... its great ... good job netsuite ... for everyones reference is nlapivoidrecord() ... works like a charm

Great ... OniNoKami ... your solution is perfect ... just what I was looking for ... i did not find it earlier ... and thanks to all for their feedbacks.

try putting the filter on transaction as var filters[2] = new nlobjSearchFilter( 'internalId', 'customer', 'anyOf', '13312', null );

thanks Olver and Brett for your inputs - seems i will end up doing this using java or php now as theres no short n simple way

thanks everyone, seems like a simple thing like copy create file to and back from an ftp gets quite tedious with the hosting middle bridge and other things. can this be anyway done using restlets instead ? as it does most of the things that webservices allows like read or write data. any suggestions ?

thanks roberth and oliver will try this

use text file (html/xml) to read the data in NetSuite as an alternative

Here it is : deployed as Validate line function var account = nlapiGetCurrentLineItemText(type, 'account'); } alert('account is ' + account); if ((account != null) && (account != '')) { if ((account[0] == '5') || (account[0] == '6')) { alert("Missing Department. Please select a Value in Department Field."); return false; }…

thanks tbuffington, thats a good workaround. will implement it that way.

guys, did anyone find anything - i tried loading the file returned by the job id - which gives insufficient privilige error (this might be because its a system generated - protected file) how do we get the status of the job ? the response ?? i need this info to understand if it has been successful or not.

its simple ... in the search - results - area - select "run unrestricted" and max results as 1.. this should do the job without any technicalities .. hope this helps :)

thanks a ton frederick, this will help to some extenet, however I am looking for all schedules belonging to customers who are cancelled status so that I can process them. anyway that I can do a join on revrecschedules on customer fields. Also the big questions is if Rev Rec Schedule is a single record with multiple lines…

thanks to you as well mms for sharing the code.... this is the true essence of this form that we were able to work on parts together and get to the solution.... frederic & mms a big thanks to you both ....

wow frederic you made my day ..... tx a lot .... customer fields are available when doing the search through the UI on rev rec schedules, apart from customer also other fields like transaction etc. are also available..... these goes something like customer.status .... anyway we can access it .... in the meantime i will…

through the UI the search on rev rec schedules is working great will all fields like customer, account, amount, schedule data, source transaction data, customer data is available. the same fields are not returning values if i search using script if i could get this same functionality with searching through script that…

try global search .. through suitescript

Hi, I too seem to have got stuck at the same issue. Is there any way to access Rev Rec Schedule line details like Source account, Destination account, amount, isrecognized etc. I have tried various methods but all that i got returned is null (no error). Is there any information on how these lines are set and fetch values…

hi sara, theres nothing wrong with the code here.... can you pls specify what exactly is the error ? are you using a user event or a client script ?

thanks a lot for your inputs ... these are really valuable ..... the limitation of this URL is that when redirected to it .... the message says 'you can not open this page directly' or 'you do not have sufficient privilege to view this page' ...... I understand that this page can only be invoked by clicking on 'reject…

hi frederick, this is not a NS user role but an external user like a customer center ..... the idea is to reject expense report over emails ..... the reply email triggers an NS suitelet which triggers the rejection .... i hv got the approval part to work thoug....

hi sara, theres nothing wrong with the code here.... can you pls specify what exactly is the error ? are you using a user event or a client script ?

Thanks e ...

thanks hawk, this is a great pointer.... i have been trying to use the search on parent (customer) record and select the count of custom child record though ..... appreciate your idea ... :)

this is where i am stuck, the column 'custrec_column_to_sum' is a formula column, so how do i refer it ? is it by label ? as there is no id to refer its a forumla numeric column ? thanks a lot for your suggestion, hope to get there after coming so close :) Hello, I would do like this: 1) create a saved search through…

I am facing the same issue where I need to summarize a formula field which picks values from parent.child ..... have got stuck ... did you get any solution ? any suggestions would be welcome .. Per support: Turns out that the field that I wanted to script a search for only allows filtering by "assignee" and that same field…

hello, i have been working on this scenario a lot and would be glad to help. for not processing the rev rec shedule further, you can do a rev rec mass update and set isupdated to true. this will not generate any futher accounting entries.

Have tested it. If isrecognized is marked it will not show up while creating JEs as the system understands that the rev rec process for these schedules have been completed. So far this is the only and working method that I could find. Thanks J.J. I was looking for a way to automate the cancellation. It is not available in…