nathanah Green Ribbon

Yes we have filed an issue for the inventory numbers join issue. Actually it is not only through SuiteScript that the search throws an error. If you add a column to the item search (ie: Inventory Numbers: On Hand) and preview or save & run the search it will throw an exception in the UI. The issue number is 142597. I…

I was able to create an Inventory Numbers Saved Search and this has all the data that I need. The problem is that I don't know what type to use. So when I call "var results = nlapiSearchRecord(type, 49, null, null);" where 49 is the id of my save search, I'm not sure what "type" should be. I've tried inventorynumbers,…

Case number is 631553. Thanks.

Here's a little followup to the previous posts ... In version 2007.1, I can now load a record and get access to the serialnumber and quantity on hand information for all lot numbers on an item. I used the following code to accomplish this: var record = nlapiLoadRecord('inventoryitem', nlapiGetRecordId()); var count =…

Yes it would be nice to know about these changes so that we could be prepared when code starts breaking. Thanks for posting this thread. It saved me a lot of trouble and headache this morning when I was attempting to figure out why the filters on my custom record search were not working.

Yes I did that. I called in to Netsuite a couple of days ago and they said they were going to look into it (what the type is for an Inventory Numbers Saved Search) and make an issue for it if necessary. Thanks.

Unfortunately, we have not been able to come up with a good solution to this problem. There's been a few options that we have tried but none have worked. There is an "inventory numbers" join that you can put on an item saved search but when we do that the entire search throws an exception. And then there is the problem I…

Yes but that will give me the total quantity on hand for that item. What I want is the quantity on hand for each lot number on that item. That's why the joins are there.

Thanks for responding so quickly. That sort of helps but I want to access the inventory numbers without actually having to be on an item receipt. I want the total quantity on hand (or on order, or available) for an item's particular lot number. What I would like to say is nlapiSearchRecord('inventorynumber', null, null,…

i'm still a little confused. can you just give me a snippet of code so I can understand what you are talking about? thanks.

ahhh... okay. I understand now. thanks.

Yeah I did. They created an enhancement request for it.

Yes I did. It still is an issue with v. 2007.

What do you mean "use server suitescript to access those fields"?

Thanks for the suggestions. I think we are going to use SuiteScript to accomplish this task. We'll just fill in the email field on the invoice via SuiteScript when we select a customer. The emails can be stored in a custom field on the customer record. Thanks again.

Thanks for the feedback. Yes, we are doing a custom NetSuite hosted html page that is in an iFrame on a 3rd party page. They are able to enter their email and password on that page and then that logs them into NetSuite. Based on your approve comments, it sounds like we are good. Thanks.

Has this been fixed? Was there a case or defect filed? I'm running into the same issue. Thanks.

Thank you that worked great. I appreciate it.

Okay, thanks. Hopefully this gets fixed soon.

Okay, but the serverWidget code completion didn't work either. Any ideas? Is something wrong with my code?

Okay, that's helpful. Is there any plans to make Eclipse work correctly? When I create a code snippet from the IDE, it formats it like the first example, not the second. Another question around this. I'm trying to create a SS2 Suitelet and I reformatted it like you described: From this: /** * @NApiVersion 2.x *…

I upgraded to the latest Eclipse version and latest SuiteCloud IDE version and things are drastically improved. Thanks for the help.

Nevermind. Disabling the content assist didn't seem to help. It is still hanging for random reasons. Really makes the IDE borderline unusable when it will hang for 1-2 minutes. Any help would be appreciated.

Any timeline on when this will be resolved?

Is your debugging configuration set up to debug a single file or the entire project? I was having the same issue but when I set it to run for the entire project, it started working. And for the entire project is what I wanted anyway, so I didn't mess around with it further.

This is what I was looking for. I'll try it out. Thanks!!

I'm running into the same issue, only with the Advanced PDF/HTML Templates. I'm trying to get the deposit amount on an invoice so am calling "{record.total - record.amountremaining}" but I get the same "Expression record.amountremaining is not numerical." Did you ever figure this out?

Wow, it seems like someone would have run across this before. I'm at the point where I'll need to create some kind of custom field or something to get this to come through...

I just submitted a case with support. Case #1155045 if you want to check on it. Thanks.

They have not fixed the defect yet. I also noticed that inventory valuation reports sometimes work and other times don't for some of these items. Not sure what the issue really is and support still doesn't have any urgency to resolve the issue and we've had it for 1 week already.