3951568 Newbie

Is the 'New Item Pricing' record tied to a single item or multiple items? What you could do is, in your existing script which I assume is a scheduled script, before submitting your invoice you fetch the relevant 'New Item Pricing' record(s). If the relationship is one-to-one you'd need to optimize your script to gather all…

Karthik's suggestion is a great solution IF you set this filter on creation of the field. Otherwise the inactive values will still 'stick' to the field even though you added the filter. This can be resolved with a user event script that takes the field value, looks up if the item is inactive and blanks the field if it is.…

Have you tried unchecking the 'Show Zeros' field under the More Options tab?

If you uncheck 'Display in Web Site' for each payment method with 'Credit Card' checked and that you make sure that Paypal payment method is inactive, when the customer selects the Credit Card option it's going to show : 'This business does not have any external payment methods defined.' and then the only way to proceed…

You can go to Setup-Accounting-Accounting Lists. In the Type dropdown you can then select Payment Method. Now, when you mention 'Shop' I'm not sure if you refer to the web store but if you do all you'll need to do is edit the payment method and uncheck the 'Display in Web Site' field. If you refer to your data entry in…

You cannot use the Group By clause for text variables (like your CLOB description). I am not sure what kind of results you expect from your query, why do you want to use Group By (and why use it on description?)? If you use the item's description to simply differentiate the items than you could use the item's ID instead…

Can you give me an example of a 'p.description' value? Is it a really long description? I understand that you want to use this value to identify your items. Is there any other field you could use that is not a CLOB that would accomplish the same thing? Could you use 'p.item_id' alone in the GROUP BY? One thing is sure is…

The Scheduler in the Activities-Activities Overview section should fill your need. You can manually add invitees, resources or even select an existing group (groups editable in List-Relationships-Groups section) and then click on the Create New Event button which will pre-populate a new event with the Attendees list filled…

The 'Minimum Quantity' field only applies to the selling side. On the purchasing side the closest setting related to this is on the 'Order Items' page. If you are not familiar with this page, it suggests a quantity to order based on the preferred stock level and quantity of open back-orders. On this page you can filter out…

Here is a workaround : - Create a custom item field called Lead Time (copy) or the name of your choosing - Set type to Integer Number - Set Store Value to false (unchecked) - Apply it to the types of items you want (Inventory at least) - Under tab Validation & Defaulting set the Default Value to {leadtime} - Save - Back on…

I don't think it's possible to change an item's subtype on the fly and don't see that as a viable solution. The simplest solution I can see is naming the items Development (Sale) and Development (Resale). This will correctly identify your items, let you link them to the correct parent and allow NetSuite to handle them…

Go to Setup - Sales - CRM Lists and create a new sales role called Adjustment Rep (make sure you check Sales Rep on this role) Go to Setup - Sales - Sales Preferences and check Allow Overassignment in sales Team. This will prompt you to enter adjustment reps. Add the adjustment reps and set their roles as Adjustment Rep.…

On the Individual Employee Commission form (New Commission) when an Employee (Sales Rep) is selected the Department, Class and Location fields are sourced with the Employee's corresponding values. Is it possible that you are using a custom field to set the department at the employee level? Because these fields are sourced…

Could you describe the items you are looking for that are not showing? Which type are they? Non-inventory, inventory, service..? As far as I can tell every item is listed (in the same page) when you create a commission schedule with the properties you described.

The best way to get what you're aiming for is probably to go with the Alt. sales Amount. First step : Setup-Company-Enable Features -> Check in Alternate Sales Amount under tab Transactions From your description, you could set up a schedule along these lines : Commission on Alt. Sales Amount per Transaction Line Item…

It should be there. Is it possible that the items that do not show up are set as Inactive?

Both of these options should result in the same commissions being paid since you do not have quotas set up. So, your negative commissions must be originating from something else. One possible way that the commission becomes negative is by going to the Individual Employee Commission screen and that a negative amount is…

The closest setting you can get to your desired process is to establish a schedule with the following : Commission on : Quota (Sales Amount) per Period Quarterly (Fiscal Year) Calculation Scale : Linear Rate : Target Factor Target Amount : (You can put your 10k here) Then, for each % of quota met you can set a % of the…

You could change your field type to Currency and remove any rounding (it will take care of itself). CASE WHEN {subtotal}>1000 THEN {subtotal}*.08 ELSE CASE WHEN {subtotal}<500 THEN {subtotal}*.12 ELSE ROUND {subtotal}*.1 END END

OK, just ran a quick example using tax amount versus amount using this formula : SUM(ABS({taxamount}))/NULLIF(SUM(ABS({amount})),0) I used summary type : maximum Let's say I have lines adding up to totals of 31875 taxes and 406880 amounts the result will be : 0.0783

Under the Results tab of your saved search you can select both the Department and Sales fields. For the Department you will need to select Summary Type = Group For the Sales you will need to select Summary Type = Sum

The payment method value is only accessible at the 'main line = true (or either)' level. The 'applied to transaction' is only accessible at the 'main line = false' level. Depending on the specificity of your search you will need to play around with the values on the main line and other lines to display the information you…

I assumed from your code that you wanted the window to open in a new tab : '<a href="https://system.na1.netsuite.com/app/crm/calendar/call.nl?&company='||{company.id}||'" target=”_blank”>Log Phone Call</a>' I put this is in a Formula (Text) field. You can remove this part if you want it top open in the current…

If you go to setup Users/Roles - Manage Roles, edit the role you want to restrict the view for and then under the Searches tab, under Custom Record, pick your record, pick your custom list view and right next to it check the Restricted checkbox. When a user with that role will log in he will view the custom records based…

To have a search that finds all items that are children of a specific parent you can use : Criteria = Sub-Item Of and then select the parent item. You can also set it as an available filer and show in footer to change the parent on the fly.

You could also use the 'internalidnumber' number field instead which gives you the numeric value of the internal id and allows you to perform number comparisons (less than, greater than, equal to, etc).

Under the Results tab of your saved search look for the Summary Label column and change the value to override the 'Maximum xxx' value.

To test your flow I created a new custom record and added a field of type List/Record - Customer. I created a new record with customer internal ID 133 set on this field. var filters = []; filters.push(new nlobjSearchFilter('custrecord_sourced_customer', null, 'is', 133)); var res = nlapiSearchRecord('customrecord231',…

You should add Criteria - Main Line is False This will limit your results to the sales orders' items

Here is a way to do it. We will use a Transaction search since we want to know who bought it (Purchase Order) and who it got sold to (Sales Order). Criteria : Type is any of Purchase Order, Sales Order Main Line is False Item : Type is Inventory Item (Item fields...) Item : Is Serialized (Item fields...) Results-Columns :…