That's interesting. I assume the SO was made for customer A. If you Edit the Invoice for customer A and change the customer at that time, does the link remain?

Why don't you want to create a custom field?

You want to look at Mass Updates. You won't be able to automatically bump a customer's Price Level as they reach certain targets, you'd need some scripting for that. But you will be able to manually roll your mass update whenever, and all customers meeting your criteria will have their Price Level updated

This kind of problem would really benefit from a really detailed analysis of your exact needs. The approach taken is going to impact your successful use of Netsuite, it's not really something I'd leave to just a few posts on the User Group. That being said, I'd look at Item Options. You could simply maintain a generic part…

I would rather recommend going to Support->Netsuite Central->Implementing->Configure Application, and on the right-hand Best Practices box downloading the "Rental and Loaner Units" config guide.

To save many pages of scrolling, you can, but you must use a custom tool built using Web Services or ODBC connector. Netsuite did show interest in eventually building an out-of-the-box "data eject" button, but it does not yet exist and there is no ETA for it.

Well, *most* records are exposed via Web Services. That is your best bet for extracting all your data for making backups. We're presently working on building an "EZ Backup" app for Netsuite based on that idea. So NS may not offer an out-of-the-box button for jettisoning all your data, but it is possible to achieve.

What about backup via ODBC? Wouldn't this be easier? Requires the ODBC module...

There is no possible trigger directly on the item. You would need to either add scripting to trigger off any possible transaction that can affect Avg Cost, or use a scheduled script to verify on a regular basis for change. However, in both cases, NS does not keep a log of Avg Cost, so you would need to also capture the old…

Interesting, I'll check it out. Indeed, I would not expect one to be created as few scripts need to be converted and due to the complexities and gaps between versions there would be some impossibilities and terrible complexities to deal with for anything but the simplest of scripts. Curious to see how your tool copes, I'll…

If you're dealing with Custom Records, then when looking at the parent in VIEW mode, you can set a search filter as you describe. In EDIT mode of the parent, you cannot filter the shown child records.

No, and I would not expect one to be created.

Yes, you'll need to do all that yourself.

I'm not sure I understand your question. You should set the appropriate Subsidiary for this vendor. I do not see how you could not know the correct value. If for some reason you have the correct textual value but not the ID you can use that via setText rather than firing a search (unless you have a partial subsidiary…

What aspect of the customization do you want translated? Custom fields maintain their translation on the record themselves. Anything else - say, pop-up messages, email text, etc - you would need to custom handle that yourself.

record.setValue

You can refer to the Help under SuiteCloud (Customization, Scripting, and Web Services) >SuiteScript >SuiteScript 2.0 >SuiteScript 2.0 API >SuiteScript 2.0 Entry Point Script Creation and Deployment SuiteScript 2.0 >Form-Level Scripts >Configuring a Custom Action

Ok that's why. After Submit, as the name implies, triggers after the record has been committed to the database. So any script errors do not prevent save - save already occurred. If you cannot resolve the issue with External ID (there may indeed be a NS limitation there, I cannot recall off the top of my head), you would…

What script trigger are you using? Before Submit, or After Submit?

No it is not - you must monitor every possible transaction type. An alternative is to create a daily scheduled script that monitors overall inventory change. Simpler to produce if you are not too concerned about the exact timing of your scripted event.

Unfortunately, that is not possible natively. Kind of arbitrary limitation there. As indicted previously, in this instance, a Custom GL Plugin might be able to address this.

You will need to reactivate the employee, create the journal, then inactivate the employee. It is a fundamental NetSuite block to reject the the creation of new records referencing inactive employees, and scripting cannot bypass this.

I am not sure what you are asking. If you select a Customer:Project in the "Customer" field of Vendor Bills, that is what will carry over to the GL Impact of the expense line. The native Customer field allows the selection of Customers or Projects, and whatever selected is that carries to the GL Impact.

Use of Ext.js - or anything that injects any code into NS interface - is highly discouraged as it is very likely to either stop working or break the screen entirely. NS may make changes to their UI and DOM and any point without prior notice, putting your customization at risk.

"Putting the nlapiSetLineItemValue in the curlies completely ignores the first loop, thus, it doesn't work." I don't understand what you mean here. Why would setting the line right after fetching the value "ignore the loop"? Not to muddy the waters, but in any case, you should never, ever call a search within a for loop…

If I remember correctly, everything works but the huge problem is you must specify Serial Numbers by referring to their Internal ID, which makes it an incredible hassle.

I suspect it might be the selectNewLine. I checked some code I have that does exactly this, and it matches all your list names and field names and stuff. So I think it might be the newLine and commit. My code doesn't have that stuff and it works.

Yeah I am pretty sure that's the only way you can do it. You'll need to execute a search and pick out however you define the "first" Lot Number to be.

I'm not sure what you are asking for. SuiteScript is not the issue: RFSmart is an external system and you would need to know and understand the APIs they expose, and what communication is possible. You should contact your RFSmart account manager. In general though, RFSmart to NetSuite communication is handled through the…

Do the records being deleted trigger their own scripting, like say afterSubmit scripts?