Cloud Red Ribbon

Bump Anyone? Please

Bump......

Thanks Mhill, I will have to get back to you one this. Thanks.. have a good weekend. Mayur

There's no-way I have the balls to change the CSV script...why couldn't they make it simpler?

Which field would I be checking if it has been saved? User notes will not show, will it?

just thought, what about if (type == 'cancel') OR (type == 'save') for those users who do not save? and maybe a time formula in there, if its less then 1 minute to clear the flag? I could get a custom field which is blank. for example : function afterSubmit(type,form) { if (type == 'cancel') nlapiSubmitField('blank field')…

anyone? :(

Hi Olivier, Sorry for not getting back to you earlier, just had other more important jobs from my MD. Apologies. Both of you are right - if I can't get it to lock, a pop up message would do the trick. As long as the message comes off once a user has finished working. If the pop up appear when another user is in edit…

Thanks Khultquist, I have already scanned through dozens of custom code on the forums. However, could I just insert a message, instead of locking it? I.e function beforesubmit (type) { var current_record_type = nlapiGetRecordType(); var current_record_id = nlapiGetRecordId(); var current_timestamp =…

Thanks again. You are right, first test it and if it works then advance it further.

ok I think I got you.. never done a time stampe or scripting..I guess something like this will work? function BeforeLoad(){ var TimeID = nlapiGetFieldValue('custom item field'); if (TimeID <== '00.00.60') { ('Note you will not be able to edit any fields or save the record as (nlapiGetRecordId('Employee ID') is currently in…

Hi Olivier, I do not know how to do that :( unfortunately. unless you or anyone else could please help me, write it? I do not know which functions, or coding to use..No one in my place has experience on Javascript. So I am totally snookered. Thanks

Hi Olivier, As I said zero experience, I just copied and changed other peoples codes to give me a simple code, I do not know how I would untag it - afterSubmit perhaps? Even with a scheduled script, I do not know how to create it, and 1 hour is to long. There must be a way to lock it, I mean there are bigger companies than…

Works!! however.... I typed in 0 in Reserved on Hand and then clicked on Save - Message isn't shown. When I click edit and put back the 1 Qty I had taken off and try to save it, The message pops up 'Please Specify Reason for Removal'. I want it to pop up when the field is zero after submitting it. Is there a 'onSumbit'…

Hi, I have tried this : function fieldChange_getFieldTextTest() { var RemovalID = nlapiGetFieldValue('custitem14'); if (RemovalID == '0'){ alert('Please specify the Reason for Removal'); } and inserted the code like this : dont know If I need anything else filling in.. the RemovalID - is something I made up.. I dont know…

Hi, This is the code, saved as Removal.js and uploaded onto Netsuite by selecting the Add sign and uploading .js file and adding the name : Removal Reason - MR function fieldChange_getFieldTextTest() { var RemovalID = nlapiGetFieldValue('custitem14'); if (RemovalID == '0'){ alert('Please specify the Reason for Removal'); }…

Nope doesnt work.. Error is thrown. I have done as advised, So I copied in my custom code tab. Start from Scratch? Maybe I should give up scripting. Sorry guys. I thought scripting would be easy when you have no experience at all..

Sorry I am lost.. what do you mean? function fieldChange_getFieldTextTest() { and change it to : Function fieldChange_GetFieldText({custitem_reason}) I do not know what you mean, I do not have a function..also do I need to fill anything else in? in the entry page? Thanks George

I am want to customize the Make Desposits Page, and have a button on there to export CSV/Excel.. Shouldn't there already be a script to export? and just a matter of adding it to this page?

One tip that I use is prefix any numeric/date string with ' a single quote - this will make excel mark it as text and it will not convert it to anything else automatically. hope this helps. So let's say you want to upload some items and save the file as CSV is that when you add the ' ? How does NS take it, I mean how do…

The issue here is that Excel is trying to be helpful and convert what it thinks are long decimal numbers to exponential notation. Once the CSV file has been saved and Excel closed, you cannot accurately convert them back, as the numbers have been rounded off and you have lost the last 9 characters, so you will need to do…

JCirocco, Just saw you're message, Sorry was away so didn't get a chance to log in.

Hi, No it doesn't, well not always - sometimes it might have the same options. How would I do this anyway? Thanks

Hi Dpcabansag, Not sure how you mean by combing them all in one file. Maybe my own fault in explaining but that's what I meant, I will group all the Matrix options so that for example I have item code 123 and I want to add abc & def then I will create then in 3 lines, then I will add 456 in the 4th line along with its'…

Thanks Michael for the reply. but isn't my code already doing that? var promoCodeRecord = nlapiCreateRecord('promotioncode'); promoCodeRecord.setFieldValue('custrecord_promotion_code', 'Promotion Code'); promoCodeRecord.setFieldValue('custrecord_promo_description', 'Promotion Description'); the 'Promotion Code' &…

bump..please anyone?

Hi Felix, I realized it has to be internal ID and not field name. so I amended the script.. im sure im missing alot more here. function afterSubmitCreatePromoCode(type) { var my_code = nlapiGetFieldValue('custrecord_promotion_code'); var my_description = nlapiGetFieldValue('custrecord_promo_description'); var my_discount =…

Hi Jennifer, Thanks for the reply. 1) Matrix is enabled 2) No Limitations. I have full access, and the error it's thrown - Site Cat & Product Feed, I've done uploads before that included these fields. 3) Deleted Cache & Restarted Windows. No luck. We have a custom multi select list - Called 'Item Options' I don't know if…

Oh Sh** thought I needed both.. ok so just uploaded 2 test codes they imported successfully.. but are not in the Promotion Code page.. don't know what's happened. ----- Update Never mind, found them.. Thanks :)

Hi Felix, really not doing good :) ok, so I've written more of your test script this is what I've got : function afterSubmitCreatePromoCode(type) { var my_code = nlapiGetFieldValue('custrecord_promotion_code'); var my_description = nlapiGetFieldValue('custrecord_promo_description'); var my_discount =…