Hello. I'm excited to have joined the NetSuite online community.I need to create a saved search that will show the results of invoice lines open as of a certain date. Effectively, creating a “commissions payable” output without using NetSuite’s commission function. I’m able to calculate the date/time the invoice became paid in full, but I’m not able to add the second level to the case statement for the “as of date.”

Is there a way to disable a field from the netsuite android / ios app?

HI.. I have created a custom field Multi select type on Sale order. filter it type quotation/estimate. On sale order i want to update my that custom field on the basis of customer. when customer is selected it will show only quotation numbers/estimate in custom list field related to that customer. How ill apply this filter. Second when quotation numbers/estimate are updated in custom list, I want to update Item list on the basis of quotation selected/estimate. I.e. items only shows list related to items added to that specific quotation/estimate selected.

Hi, Is it true that we can't cancel an order through Suite Script ?

I see now that new standard customers are allotted 100 gb of storage but our standard account (re-signed in March 2020) is at 10 GB. Is this something we should expect NS to update on our account?

Hello community! Is anybody using a forecasting tool within NetSuite?

hey guys I’m trying to create a saved search which shows items below reorder point - I used the formula on an inventory balance search as “{onhand}<{item.locationreorderpoint}” but am getting “Error: Invalid Expression”

Hi all - Two Questions: Our website allowing people to create multiple accounts with same email. Anyone know of anything or a solution. Second Question: How do you all limit selling something online to certain parties? An example would be customers purchasing a class that they are not qualified to purchase. How do you all restrict sales. Thanks!

Can anyone help me find this field in the ODBC tables? I've checked TRANSACTIONS and can't see it.

Hello, I have a question. Has anyone here done anything for vendor contract management in NetSuite?

Hello !! Does anyone know if SuiteAnalytics Connect ODBC driver also provides access to table SavedSearches and stored procedure CreateSavedSearchSchema , just like these 3rd party vendors provide - https://www.cdata.com/kb/articles/netsuite-saved-searches.rst, http://cdn.cdata.com/help/DNC/odbc/pg_sp-createsavedsearchschema.htm, https://docs.tibco.com/pub/tdv/8.2.0/doc/html/AdapterHelp/index.html#page/AdapterHelp%2Fword-frame_netsuite.33.071.html%23 . I couldn't find that from the ODBC connection though.

is there a way to add a field to the form where you attach a file to a record?

For scis can i change payment method?

Reposting here...Hi all, My accountant is looking to add a referral fee to our sales orders. I know that NS has a comprehensive commission feature but since we are only looking to use the basics and NetSuite's cost for it is quite prohibitive we are looking to customize it on our own. Does anyone have any experience doing this? I've tried a basic workflow but I'm having trouble getting the estimated gros profit field to change.

@Ava You can't change the est. gross profit, but I was able to change the est. extended cost on invoices, but it was via script not workflow

Anyone have a recommendation on a tool/feature / configuration that allows automated email logging to netsuite? We communicate with customers via gmail. I'd like inbound / outbound emails from customers to automatically log under the "communication" tab on a customer record in netsuite.

Hi can I print a workbook?

pivot table?

or best way to create a pivot table in netsuite?

its hard to dynamically add the columns, correct?

i still need to set the columns static it seems

hi Guys i am sourcing base price from item into custom field on sales order/Invoice

but it showing base price per KG as we have Units of measure on the line

has anyone experienced very poor performance in Sandbox recently? We are seeing insane load times for Sales Orders and purchase orders, both in Web Service requests and just trying to load/save in the UI.

Is it possible in NS to create cumulative quantity discounts for a specific period of time (not quantity discounts per individual transaction)? Say, the discounts are 1%, 3% and 5% if the customer purchased 1,000, 3,000 and more than 5,000 units CUMULATIVELY, respectively, in one calendar year (taking into consideration the prior sales within the CY). Same is required for the vendor purchases. Hopefully without scripting if there are alternative options.

Does anyone how I can update my online atp with what is currently on hand + any on order? would that require a workflow, import, or is there a setting for this?

This message was deleted.

All of my users portlets are stuck "loading" and/or are showing no data when they do "load". Anyone else running into this?