Thanks for the confirmation. I don't understand however why I'm getting an error when trying to lookup that field. From my client script on a sales order: function fieldChanged(type,name){ // Get customer collect number from customer record when customer changes. if (name == 'entity'){ //if the field that changed is the…

This issue has been resolved. All you need to do is clear the browser cache in Firefox, close it and reopen it. Thanks to NS for the quick fix.

Thank you very much for the reply. I too can now get these to work. My issue was that I was using "price1" as the sublist internal ID per the record browser here (sublists section): https://system.netsuite.com/help/helpcenter/en_US/RecordsBrowser/2011_2/index.html I guess the number only ever applies when using multiple…

Thank you both for your feedback. Custom scripts being affected by this is a great thought. I do have several scripts that manipulate prices and some of that functionality does break after turning on multiple currencies. No doubt they can all be fixed but it definitely factors in to my decision.

Hi John, I have some similar requirements. I have some special pricing per customer, per vendor, subsets of vendor products and specific part numbers only. I implemented a SuiteScript solution with a custom record to hold all the "standard discount" rules. These are exposed on the customer record and inventory item record.…

I almost always do what you do now and create new customer records for new locations and use the parent child relationships. I keep them separate for sales rep/team assignments since sales territories and reps change. I'd rather just simply reassign the custom records to new reps than try to split one customer into two or…

I deal with this exact issue by making my own tax codes with the reduced percentages and then tax groups with the corresponding tax codes (state, county and city typically) in them. Then manually assign the custom tax group to the customer.

Sales tax is so confusing sometimes. Amen. You may not have to create tax codes for every customer but perhaps a tax group for every one. I deal with Alabama and they have sales taxes per state, county and city. In Birmingham for example, you may pay 10% sales tax but 4% is state, 3.5% is county and 2.5% is city so I have…

Strange. When I create a sales order for a customer on credit hold, I get a warning when I try to add a line item. Customer balance of 776.00 exceeds credit limit of 1.00.

In Setup / Accounting Preferences / General Tab there is a check box for: Customer Credit Limit Includes Orders This makes the credit hold apply at the Sales Order.

I would like to know more about this solution.

I accomplished this functionality by creating specific forms for roles that have the fields you want protected disabled or hidden altogether. Then make those custom forms preferred for that role and don't allow that role to change forms.

This may not help you but what works for me is to type the text I want complete with all carriage returns (just hit enter) in plain old notepad first. Then copy/paste that into excel/csv file. Then (if you need) concatenate that with whatever other text you need. This will import carriage returns as you want them in text…

I feel your pain farrago. I've dealt with this exact scenario for years and I've had the exact same discussion with my vendors you've had. I've even had a vendor try to retroactively charge me sales tax for all out-of-state, exempt drop ship orders for a previous three year period (they had a sales tax audit). Carl nailed…

I agree Olivier that your assessment is most likely. Why else would you proactively remove a form that had been there for years? It's still frustrating. By that logic will they stop supporting sales tax calculations/payments as well? Those laws are always changing as well. NetSuite taking liability for doing certain things…

Yes others do indeed have issues with this. See this thread: https://usergroup.netsuite.com/users/forum/general/latest-release/version-2015-release-2/387530-search-shows-non-matching-items

Thank you for the excellent response! I appreciate it. There would be times when on a single transaction, I would want both standard item names and the custom item names used. I'm not sure how this case would work when only using an alternate printing field. I think the custom record may be how I handle this. I always knew…

Is there anyway we can update this PDF layout ourselves?

Not sure if this is the issue but in Setup / Accounting / Setup Taxes, there is an option for, "Tax Code Lists Include" You can set this to Tax Groups only, Tax Codes only or both.

We deal with blanket orders the same way sterlingr described. We enter one sales order for the entire quantities and use description lines to enter release dates. All unknown release quantities/dates are set to the last date of the contract. As changes come in, release dates are modified by changing them on the description…

Hi winpod, In my experience there is little ability to link transactions after they are created. There are some enhancement requests to allow links to be made after the record has been created for specific transactions. 156116 for example is to "Have an ability to link a stand alone Sales Order to an existing Estimate or…

I've seen this question before and the only answer I ever saw was to delete the PO, refresh the SO and then use the Special Order link under create PO. This could probably be done with scripting but this is too rare and not painful enough when it does occur for me to investigate that option.

I'm not sure on this but I don't believe you can set exact dollar amounts for a price level. I believe you have to put in markup or discount values. If you want this price level to be always $0, try putting in -100.0% for the Markup/Discount % field on the price level.

Hi TWW, I implemented the Apply Discounts functionality with a custom record and suitescript. I can explain in more detail if you're interested.

Hi Jeff, Not sure if this will help or not but I faced a similar problem. I don't have 200 line item orders but I do have customer specific pricing rules and SKU's that get pulled in from custom records. To make our order entry as fast as possible, I have the custom pricing and SKU's applied after all the items are entered…

Hi dreamgard, In the Accounting Preferences, there is a checkbox that says: Customer Credit Limit Includes Orders We have this on and it prevents sales order creation for customer on credit hold (not sure about cash sales though).

You are correct and we don't delete the SO but the PO only. Then do as you say Still, having to delete a transaction at all seems like an inappropriate method for handling this and was hoping for a better way.

If you go into your accounting lists and look at the various price levels, is the one that is the default internal ID number 1? My assumption (dangerous I know) is that that price level is the default. This can be renamed so it might not look like the one you expect to be the default. If you can determine that this is the…

I had a problem where a few specific domains were not receiving emails from NetSuite but most were. For me, the problem was I did not have a properly configured SPF record in my DNS configuration. In short, the SPF record tells other email servers that it is acceptable for email from <yourdoman.com> to come from a…

The "created from" field works but not when Main Line = True. Since a single payment can have multiple lines that apply to multiple invoices, you may have to run the search without Main Line = True and get creative with grouping by payment number.