Java 1.8. I am using squirel sql. Same jdk and NS jdbc driver for sandbox and prod. It connect to SB, but not prod

na1 and na2 give the same error

You have to join to invetory_numbers to get serial numbers as there can be many. I am doing it from fulfillment. It is not part of the build or fulfill record hence the join.

Serial numbers are a bit bizarre in NetSuite. Are you trying to access serial numbers from a transaction (i.e receipt, fulfiullment...) or just trying to get serial data from inventory.

I had a similar issue with a suitelet and po. Worked in 1.0 API. Got the error you are getting in 2.0. It is a bug. In our case the inventory detail block was not needed and not displayed on the form. 1.0 did not care. 2.0 it did. I had to enable the detail evening though we were not using it. It was not required for the…

Yes. I only want to use 2.0 as well, gaps? I think its more like the Grand Canyon in some places.... I was doing a lot of null testing in some of the testing I did.

Do you mean disable the column or just a column in a row. Below only works in a client script. This is a standard field in fulfillment item sublist function pageInit(context) { var record = context.currentRecord; var itemCount = record.getLineCount('item'); var stStat = 0; // log.debug('itemCount',itemCount); for (i = 0; i…

I was using this in SS2.0 from fulfilment... sr = itf.getSublistSubrecord({ sublistId : 'item', fieldId : 'inventorydetail' , line : 0}); I never completed the rest of the testing , but I would get referenceError when using the incorrect method. try getSublistSubrecord

I took the following code and ran it in the debugger with scrip version set to 2.0. It worked fine and gave me a line count of 4 which is correct. Check of the record is loaded in deferred or non deferred mode... Are you doing a client side or server side script require([ 'N/record'], function(record) { try { var rec =…

We recommend that people have a look at MomentJS for date arithmetic. http://momentjs.com/ Interesting. I will try it. Thanks

We recommend that people have a look at MomentJS for date arithmetic. http://momentjs.com/ Do I need to update the moment.js with define and return statements or can I use it as is...

Yeah I was having the same issue. Using the following var today = new Date(); var sixmonthsago = new Date(); sixmonthsago.setMonth(sixmonthsago.getMonth() - 6); Yes. I found set month only sets the month number. It does not increment/decrement the year. Many seemed to be using Javascript libraries with addmonth functions

I think I have it all set except saving the sub record. I do this from the record to create a new subrecord sr = itf.getCurrentSublistSubrecord({ sublistId : 'item', fieldId : 'inventorydetail' }); After setting the values I commit sr.commitLine({ sublistId : 'inventoryassignment' }); But how do I make sure the sr…

I think I have the basics down but cannot seem to find the correct field. I get ":"Please enter value(s) for: Serial/Lot Following code segment sr = itf.getCurrentSublistSubrecord({ sublistId : 'item', fieldId : 'inventorydetail' }); sr.selectNewLine({ sublistId : 'inventoryassignment' }); sr.setCurrentSublistValue({…

Not solved yet. I still did not get the serial numbers.... Trying a simpler order first.

Hi ssilveri77 , What field id/s have you already tried for the { sublistId : 'inventoryassignment', fieldId : '', value : 'myinventoryNumber' }? Have you tried using the fieldId issueinventorynumber? yes. I did

Now I have to figure out the drop ship part.

well it was the isDynamic : true. you cannot use that method you have to use this one issue..

Next step. The item was a drop ship and had create po.. I put the serial number in receiptinventoryassignment . I don;t get the error, but have to figure out the next step

log.debug( 'Field Change', 'Sublist:' + context.fieldId ); in a fieldChange does not generate anything.

record.setSublistValue works. I wonder why setCurrentSublistValue doesn't

I think the variables are okay... Yes, noticed the zero based...Calling the search seems to cause the problem. I put it in a function call. If I comment out the call, it works. UN-Ccmment, it does not work. I am not using any global variables in the function. Passing two params in and returning one...

"setCurrentSublistValue requires that one of the lines of the sublist be active/selected. You would need to do something like this first: " Yes, I realize that. Wouldn't a line be selected if it was firing from a field changed event on the line I wanted to change?

Is there somewhere to set the log level? There is no deployment record, so I cannot set it there... This is a form based script, not record level

Are you using setSublistValue on LIST? or INLINEEDITOR? I have a LIST sublist created in Suitelet and calling context.currentRecord.setSublistValue call returns "it is not a function error" in client script. Anyone seen this? I did it on the item subrecord in fulfillment. When you say a list, how did you create it? Show…

Thanks... Works on a custom record. I will be using it on a custom field in fulfillment, so this may work.

Hi Steve, SDF will allow you to distribute SuiteApps, could you please describe a bit more what your desired scenario would be? There may be use-cases that you can benefit from right-away. I would like to install forms, new records/fields, scripts, workflow. It would be nice to customize the install of components based on…

That doesn't work either. Then I get an error that it is not in the dependencies list

Okay got it working... A few things wrong. I did not have the script in {FileCabinet] as you pointed out and some miscellaneous [] needed

Yes, I did open a case and it was assigned to a defect. I thought I would see if anyone here was successful. We refreshed this sandbox from prod just yesterday.