Yes the missing index number was the issue, it did not like that. Do you have an example of the where the nlobjScriptError is captured? I am assuming that it is created at available at the end of the procedure, but am not sure. Thanks Richard

Sure, here it is, I have posted the function that works with the 'onOrAfter' operator. what do I change filters[0] to to make it 'today' ? Thanks Richard // function rfq_batch() { // function to write line items from a purchase order to custom rfq records //function to create a job once a job record has been created var…

The main problem is goverance, the test data for the function selects 3 possible vendors and 3 possible products, and writes them to a custom record. However it errors out as follows: Script Execution Usage Limit Exceeded Date & Time: 6/21/2006 3:38 pm Record Type: Purchase Order Execution Time: 0.42s Script: rfq…

thanks for that. Just a quick aside, how does the reference work in the formula field for a custom field? I cannot get it to reference any fields on any form, so I am guessing I must have the syntax wrong. Thanks Richard

On the customer form, it does not come up with an error if I use what you posted, however, it does not come up with a value unfortunately either. My example is using the transaction column fields. When I put 10-2 it correctly returns 8 on the line item, however when I put {quantity}-2 I get ERROR: Field Not Found which…

Ah, all is now revealed! Thank you very much, and I can't wait until the next release in July! Cheers Richard

sure, here is the function - the custom record is called rfq and in the create record function is where it is failing. function rfq() { var rec = ''; var record = nlapiLoadRecord('purchaseorder','409'); var suppliers = new Array(); suppliers = record.getFieldValues('custbodyafqsuppliers'); for (var j = 0 ;j <…

You can by making a custom Purchase Request Order form. This can look a Standard NetSuite form, and behave in any way you want. Let me know if you would like further information. Thanks

Thanks very much! Richard

Just documenting it would be fine. Now I know, there are no problems! Thanks

awesome, thanks!

Hi Paul, thanks for buying our module! The advantage of having a simple script to do this is that it also displays the related transactions so you can double check it is not an error.

Common Mark, you should know better than that! :p Don't forget about the 'Other relationships' on the lead record. That might meet your requirement. Richard

I haven't done it in WS, but in Suitescript the only option is to use getText, as the internalid's do not match up to the search reference internal ids. Richard

Thanks, it is all good now. Is there an enhancement request to have a nullField API in the system? I so I will vote for it to help get it through. Thanks Richard

If you do a summary type COUNT on the InternalId field it does a distinct count. Richard

That's a tricky one, mainly because there is no history on the item fulfilment lines, so you cannot compare the change of values on the line, like you can on a Sales Order for example. One possible way of doing it is to create a script that stores the value of how many items were picked, and then compare that with the new…

Hi Dan, A Barcoding scanning system for NS item fulfilments works by downloading the item fulfilment transactions to a handheld mobile scanning device, and then uses the scanning technology to verify whats being picked/packed/shipped to the order. Then based upon certain business logic, you update NetSuite accordingly.…

I have logged in today with Safari after the upgrade and no problems. Are you using the Safari Beta version?

Also sometimes the www.netsuite.com looks rubbish. It looks as though its lost the CSS. Doesn't happen all the time though, which is a bit weird...

I had this problem, try the following if (js_is_job == '') it has worked for me.....

yes, sorry, the error is: TypeError - Value undefined (result of expression owner.setProperty) is not object. so the only thing i could think of was setting the internalid of the sent from email as admin, but this produced the same error. I orignally had it set up as a CSS (validating data by user) & SSS (invoking the…

Actually it appears to be a bug: the formula is nvl({custcoltvalue},0)/nvl({custcoliquantity},1) and it comes up on the form as Error: Field not found. However, after you have added a line item, and saved the transaction, the field gets calculated. the funny bit is if you click on the store value check box on the above…

Thanks for looking into it. Can you post an issue number if one gets created so we can be notified when it is released? Thanks

Will it be possible to sync with projects using the new Outlook integration? Currently this is a real problem for clients with the Advanced Projects module, their communication is directed at projects, and not the customer once the sale is approved. This would complete communication gap that currently exists in linking…

So what will ti take for Netsuite to expose the record type ' record' to all the accounts so that we can get a consistent implementation across accounts: $ var sr = nlapiSearchRecord('record',null,null,[new nlobjSearchColumn('internalid')]); > Code: INVALID_RCRD_TYPE Details: nlapiSearchRecord: type argument record is not…

hi, I want to convert Work orders in PDF layout using suitescript. I tried using 'nlapiPrintRecord' but it fails for work order. Just wanted to know if there is any work-around for this? thanks, sam I've just done this for another customer, it's really quite easy and using the nlapiXMLtoPDF() function. the…

I've done something similar with automatically tracking time spent on cases: // global variables for timer var sec = 0; var min = 0; var hour = 0; function pageInitCase(){ sec++; if (sec == 60) { sec = 0; min = min + 1; } else { min = min; } if (min == 60) { min = 0; hour += 1; } if (sec<=9) { sec = "0" + sec; }…

Enhancement 114791 - Ability to customize the look of the customer center including the links.

This customer does not use fulfillment, it goes straight to an invoice. If I did do a 'create' type on the invoice , then I have to go back to the SO and change the status and then throw an error. It would work... Any chance of putting the fulfilment event as an enchancement request and getting it through? Thanks!