If you are trying to create Script records automatically that is a tough ask as it is not supported via script itself. Script deployments are fully available but not sure that helps you. If you are trying to import files using SFTP you can use the sftp download action on a scheduled basis. You can have the 3rd party drop…

I think @MoonK has the right approach. If you are seeing backorder quantities in your column it is referring to the back order of the item and not pertaining to the sales order transaction.

Some of it can be customized by customizing the external customer form. Some fields appear no matter what but you can hide them in a before load workflow by setting the condition User Role = Customer Center.

You can also consider inactivating the parent department. It will keep it in the list but will avoid posting or even seeing them in the drop down list.

For analytics the dataset is a bit more verbose. The transaction dataset should provide the same data as a search and you should be able to retrieve all the GL details. For accounting related data you will need to work with Transaction -> Transaction Line-> Transaction Accounting Line

Yes I think you are right it only validates against quantity on hand not quantity available. If you know how to write workflows I wonder if a workflow can help were the status of the sales order gets automatically set to Pending Approval on create if quantity - available < 0 This will prevent the quantity from showing as…

Also checkout the Enhanced Validations and Defaulting NS Suitebundle. It can help and allows you to also create item sets to validate specific items to avoid backorders.

Hi John, To resolve this I usually just remove the inventory detail column from the form all together. There is no effect on inventory as long as it is not a standalone vendor bill. This should clear up the error.

Are you able to select the lead when creating an opportunity from the blank Opportunity record? If not you may need to create a ticket with NS support. If you are able to select the customer, it is likely the lead form you are using is not displaying the opportunity sublist so you cannot create opportunities from there.

If you are looking for a better customer center experience you should check out the suitecommerce myaccount but it seems like that ship has sailed. It might still be option to at least provide a better experience on the SSO landing page. Our dev team did an SSO in the past to NetSuite MyAccount and we were successful but…

It is customizable but I believe only by including additional GL accounts by creating account categories. I don't believe you can do subsets of transactions.

Can you provide more detail on your question? In NetSuite you can convert a lead to a prospect (which maybe you renamed to Opportunity?) in 2 ways: 1- by generating an opportunity Transaction against the lead 2- Using a customer form that allows you to manually change the status to prospect. If you cannot manually change…

You are correct user event scripts or all scripts for that manner are not currently supported in saved searches.

There is an item type in NetSuite called downloadable item that is for the use case you mention. I haven't really looked at it in years and can't provide much about it but I would suggest researching it as well for a possibly fully integrated NetSuite solution.

The case# is 4923624 The out of district box is checked. Per line taxes is not enabled.

Not 100% sure this will work but if it is not available in native client scripts you can try loading a client script in before load of a user event script using the clientScriptModulePath.

Just trying to change the tax code under the accounting tab. I checked and all the line items have the Tax checked as well. I went through all the tax setup as well and everything seems correct. I tried a few times to reach out to NetSuite support but the new NetSuite support process doesn't seem to be working very well.…

Formula text is the way to go. You can just add the value surrounded by single quotes e.g. 'Fixed Value' or '0' in the formula field.

Not sure about VRMA but I think you can do just an RMA and receive it back in. You can also do an inventory adjustment as well to adjust it in.

I disabled all scripts and workflows and tried with the standard form and still has the same issue.

Advanced taxes. Thanks!

Never tried a search but isn't that what the N/currency module is for?

Ok thanks. Will have to a custom replace method as a workaround.