Hi Mik@Micah Timbol-Oracle , One more question, we don't remember there was Excluded Type options before. Is this something new after 2020.2 release? Thank you, Lily

Got it. Thank you, Micah! Lily

Hi Mik, Thanks for your response. We didn't reconnect in Bank Feeds. I suspect it might be caused by the recent release of the expanded functionality of Bank Reconciliation? We already matched all bank data in May. Why old transactions in May came now? We didn't see them when we did bank match for May, Jun, July and…

Thank you, Jack. Yes, it works now.

Hi Michaelle, Sorry for the confusion. I don't think this issue is caused by per email 25MB limitation. Each email attachment plus email body is less than 25MB. Lily

In the saved search, total result is 40k. It includes 189 different locations, each location has its own location email. Each location has around 200 result. Recipients from Results: Location Email So each location should only see its own result (around 200) in pdf or excel. Now each location can get email with pdf or…

Hi Michelle, 25MB limitation on emails sent from NetSuite is for one email or for one scheduled emails total attachment? The saved search need to send 189 emails, each email attachment is around 20k. Thank you, Lily

Thank you, Michelle. I tested again. It seems when I have a few hundreds result, the scheduled email works the fine, the same as I get from UI. But when the saved search result is large, for example 40k, the scheduled email result will be incomplete. Is there any size limitation for saved search scheduled email? Lily

I tested to send scheduled email in excel format. The result is also incomplete. It seems that there is a size limitation for saved searches to send scheduled emails? Thank you, Lily

Thank you, Michelle! This is a transaction saved search. Transaction type is Bill and Bill Credit. The email recipients are from results (Location Email), and the email is scheduled. When I tested to send email to myself (specified recipient), the result is correct, complete results are in pdf. Lily

Hello, I'm Lily Wu, located in Vancouver, Canada. I have been working in NetSuite customization for more than 8 years. I would like to share and learn more NetSuite customization experience with like-minded people. I like gardening and zumba. Thank you, Lily

Thank you, Michelle. I already created task saved searches to display in the dashboard. They work well. What I'm looking for is to display task due day in My Calendar. Currently my calendar can show task created day (I created 3 testing tasks on Jun 19, 28, 30 as showing below). I would like to show task due day.

Thank you Shamaine. I understand that "Tax Code" is a main field in vendor record. But "Vendor Code" is a item list level field in vendor record and Item record. Any clues to find a line level field name? Lily

Yes, I added the Vendor Code field in the saved search. As you mentioned, the challenge with this field is that it will display multiple lines depending on the number of Preferred Vendors set on the Item record. I tried to add criteria for {item.othervender} = {item.vendor}. But the same vendor could belong to multiple…

Thank you, Shamaine.

Thank you, Jack.

Thank you very much, Jack! Yes, it works. Definitely the right answer!

Hi Jack, Great! It's very helpful. I think you gave the right answer. Thank you, Lily

I did some research and found the answer. To display current time and user name, the following formula works: nlapiDateToString(new Date(), 'datetime') + " " + nlapiLookupField('employee',nlapiGetUser(),'firstname') Hopefully it can help others who have the same request. Thank you, Lily

Yes, it works. Thank you very much, Michelle! Lily

There is no error info. Scheduled script deploy status shows 100% completed. 'quantityuom' is in a formula. It doesn't work. 'quantity' field works.

Thank you, it's very helpful.

Yes, you are right. I just found that Subsidiary is renamed as Company. Thank you very much! Lily

Please see below our Subsidiary Navigator: Please see below saved search screen shot. I can't find subsidiary fields.

Hello Pauline, If not check STORE VALUE box, it won't display data in printing form or saved search. It just displays data in the transaction record. Thank you, Lily

Thank you very much, Pauline! It's very helpful! I think the transaction line field value can be default as or source from the custom field that store preferred vendor price. It is not necessary to create the workflow that will copy the value from the custom item field where the value is stored to the transaction line…

I'm using the following formula, but the custom field in Transfer Order shows blank. Case When {vendor.entityid} = "xxxx" Then {vendorcost} End

Thank you, it fixed the errors. Lily

Thank you very much, Erick! I tested the client script and deploy it on Item Fulfillment. But when I edit a Item Fulfillment, the error window display as the below:

Hello Pauline, Can you please advise more details regarding how to use a user event script to pull the value of Transfer Price and Amount from related Transfer Order for custom transaction line fields in Item Fulfillment? The custom transaction line field ID is custcol_price_commercial_invoice It should be in a loop to…