n.tiwari Green Ribbon

* Located in the Greater LA area. * I am currently working as a NetSuite Administrator at my current employer. I have a Masters degree in Information Systems from George Mason University. * I am primarily working with NetSuite OneWorld, Analytics, SuiteScripts, SuiteFlow, and eCommerce Integration (Magento, Shopify) using…

eleran Thanks for the suggestion. It significantly reduced my results but I still get the customers having sales orders amount greater than 0.

Thanks Torin, I was able to implement the schedule and get pdf of the transaction. Thanks for that! My only other concern is we want to send emails only in weekdays to our customers. So, if the saved search has any results in the weekend then the workflow will not trigger the email action as the workflow is scheduled only…

Attached are screenshots of our saved search.

Hi Mark, We did make use of Custom Segments across multiple records. All the custom segment fields sources from the Customer record (Source List) but we had to build a workflow (to update the empty values on other records like Customer Refund, Credit Memo for example) that didn't source it successfully. We also were…

Started with trying to display gift certificate code used and the gift certificate amount applied in an order on a Return Authorization record -> You can see the gift certificate code and the gift certificate amount on the Sales Order as well as the Cash Sale record. My approach is to use formula in a custom field or…

Actually, I am now able to add a EU Direct price custom field which sources its value from an Item Search. I have confirmed on multiple Inventory Items that the value is being pulled correctly. Now, my only challenge remaining is to put this new custom field in a report as one of the columns. I do not find the new custom…

Rafe, No. I did not as I was sourcing the field.

As it turns out, NetSuite support told me that an Item Fulfillment record field which populates the field value based on a search will not work if you try to display it on the Packing Slip pdf. If you have the same custom transaction body field on a Sales Order and try to have that field on a Picking Ticket pdf instead…

Hi zackb22, thank you for the suggestion. These are custom lists. Even if I convert them to a custom record then I will still have to give the role a custom record permission which means I am back to square one. The custom record permission will given them access to not only the four records in question, but also all other…

Thank you Tori. That helped!

erictgrubaugh - I posted this question in the slack community and got a response for using a saved search instead of a report to display the unit price. I did that and trying to get feedback from my colleague and see how it goes. I did thought of an alternate, dirty solution - to use two custom fields - one for sourcing…

zackb22, thank you! This helped. I can see that after implementing this, the "List" section of the record type is editable for for only this field that I tested for the role. Other record types that has list of records can be viewed but cannot be edited.

Yeah, I forgot to mention that I tried to modify the formula as below: {item.custitem106} - {rate} This gives me the error: ERROR: Field 'item.custitem106' Not Found I also tried the below modification: {createdfrom.custitem106} - {rate} This also gives me similar error: ERROR: Field 'createdfrom.custitem106' Not Found

Hi al3xicon, I am not trying to do a search. I am just trying to display the field's value on the Sales Order form. The field is using a formula which calculates the difference between the Item's field of "Direct List Price" and the standard Rate field. This field is applied for only Sales Order form.

Thanks Voltron and j.j! I will try your suggestions!

I think that helps us. Thanks again Torin!

We achieved removing the return tracking number on an Item Fulfillment record by following the below steps: 1) Created two custom body fields for SO -> i) One to capture the tracking numbers --> This gets populated as soon as the Item Fulfillment record is created--> Formula used: {applyingtransaction.trackingnumbers} and…

rnedelkow Thanks. This was not discussed at all. I will check this and let you know if it helps.

Not sent: Blocked by mail filter Hi Michael, we are facing the same issue of customers saying either emails are being received by them or the emails are going to the junk email folder. Can you confirm where do you see the message - Not sent: Blocked by mail filter?

Yes, I have done it. They filed a defect for us: Defect # 420691

We faced the same issue and what Carol mentioned is the best workaround I am aware of, is what we're doing as well. Importing your updates will be quick and less frustrating if you do as follows: 1) Prepare your import csv file by using a transaction saved search, with a criteria of the Transaction's Internal ID (Number)…

Sorry, I have questions rather than an answer to your question. Does GDPR affects only EU based organizations? We have a US based organization which has transactions in EU. I am not sure whether GDPR affects us. Does it? And I thought NetSuite usually notify you of this kind of big impactful change - listing what is…

Hi Olivier Gagnon NC 1. I am actually not sure which exact script it is when IF record is created via suitelet context. But I know it is one of the WMS suitelet scripts that is doing this. Each time it is creating a new fulfillment record in the Picking status. As far as I can tell, it does not edit any existing ones. 2. I…

rmacias It sounds like you may have a specific script issue. Contact NetSuite support - they should be able to help you on this. One thing to note - We mocked the creation of item fulfillment record via a suitelet and our workflow executed successfully in "On Create" event only. But in real IF records created via WMS, our…

Hi Olivier Gagnon NC here is a code snippet of my user event script (beforeSubmit function). Any suggestions to improve this so that the suitelet triggers this script successfully? function xyz(context) { try { if (context == 'create') { var department = ['1', '2', '3']; var x = nlapiGetLineItemValue('item', 'department',…

pcutlerThank you for your input! For non-sample orders, I am talking about the entity status on the opportunity record - not the document status. The entity status of the opportunity gets updated to the default customer status right now. Our sales team wants to make sure the opportunity status and customer status are…

Thanks for your reply Oliver. We are already enforcing the orders to not allowed be fulfilled if the "Sales Hold" checkbox is checked on the Sales Order.

Hi Amy, We are going to be using ODBC connector as well. High-level: ODBC connector will be installed on a server and we connect to the server to access Tableau.

Oliver and j.j. - thank you both for your input - Instead of putting a button, we are now trying to just send the saved search results every 4 hrs to some users. And once the orders are sent - these orders should not appear in the next email - basically every email should have unique orders in them. Do you know if we can…