Great point! Yes, I saw the version in the sandbox is an old one. Thank you, Lily

Thanks Joahnna! Yes, the formula works as you explained. The url opens the file cabinet. But we would need the URL field to source the exact image. This field will be used to pass the image in our Shopify website. Can you please advise how to use a script to achieve it? Lily

Please see Partner screen shot. Ideally Doctor Photo Image URL can auto populated after Doctor Photo is changed. Ideally, Doctor Photo Image URL field should source from Doctor Photo Field. Unfortunately Custom field Doctor Photo is not in Source from list. I tried to use a workflow. The formula is…

FYI, I use the same formula in a saved search. It works. In saved search result, Image URL can be correctly populated. 'https://<accountID>.app.netsuite.com'||{custentity_doctor_photo}

Thanks Pauline! Yes, your solution works fine. Lily

I found it in google. It should be A - Transit Number Symbol. I tried it in the pdf. It works. Thank you, Lily

I tried to use a script to set the Rich Text Field Long Message Backup value. It doesn't work either. Long Message Backup = Message + Long Message Backup Long Message Backup field id = custevent_long_message_backup function beforeSubmit(type){ var backup = nlapiDateToString(new Date(), 'datetime') + " " +…

Thanks for your help! After 5 hours, the new elimination task was initialed, and after 5 more hours, the task was completed successfully. Lily

Thanks Pauline! Is it possible to provide a sample of getting and setting Adjustments sublist line value? If I would like to get the first line adjustment item class, can I use the code as the below? var lineItemClass = nlapiGetLineItemValue('adjustments', 'class', 1); Thank you, LIly

Thank you, Pauline. I just found Ref.Number is the field for tranid/Document Number in the workflow. It works.for me. Lily

Thank you very much, Micah! Yes, I can see period amount in the report after I follow your instruction. Is it possible to add Period in a saved search? Lily

Thank you, Joy! Yes, this workaround works. Lily

Thank you, Ivy! Lily

Hi Michelle, It's a item saved search. Our product team has been using it to extract data from Netsuie. It worked well before. The defect just started this week. 2021.1 new release applied to our account last Friday, Mar 19. Not sure if this defect is related to the new release. Thank you, Lily

It seems the defect will happen once there are more than 50 columns in the results. It works correctly when the column number is 48. After I increase to 51, the defect happens. Thank you, Lily

Hi Michelle, Thanks for your explanation. When the results are 650, it's not a big number. The exported file only include 157 lines. When the results are 25,380, the exported file includes 5418 lines. It seems odd. Lily

Hi Michelle, I tried both, they don't work. Actually the custom role can see all public saved searches. The problem is they can't see VIEW Drop Down. I found an alternate solution to bring these saved searched under Report as a Center Category page. And it works. Thanks for your help. Lily

Hi Michelle, Can you please confirm what "Purchase Orders Locations saved search" means? We are using Transaction saved search, Type is Purchase Order. I'm the owner of the saved search, when I switch to FYT Clinic Users, I can't see View Drop Down. Thank you, Lily

Hi Michelle, Yes, the FYT Clinic User role has the Perform Search Permission Full. In other roles, users could see many selections in View Drop Down menu. But in FYT Clinic role, there is NO View Drop Down menu available. I can only assign one preferred view for this role. If no preferred role is assigned, then it will use…

Hi Michelle, The problem is there is no View drop down display for the custom role. These saved searches have been set up as public. In other roles, we can use View Drop Down to select. I suspect that limited user might only have one view for transactions. Can you please review and confirm? Thank you, Lily

Thank you, Jeff! I will vote the enhancement. Lily

Thanks for your reply, Ivy! It's under Web store tab, Associated Images subtab. I would like to display the image name. I don't think it's a custom field. It's related to SuiteCommerce Advanced. Lily

Thank you, Michelle! We added use the domain sent-via.netsuite.com in SPF. And it works. Lily

@Pierre_Plourde @Michelle Jabanes-Oracle I checked our email preference page, it shows we enabled Domain Keys Identified Mail. Also, I clicked Verify DNS Entry button, it shows "Your DNS entry for DKIM has successfully been verified.". Send Email to DKIM Reflector works well, the email was sent successfully. The email…

@Pierre_Plourde, Thank you, Pierre! I checked our email preference setting. It shows we enabled Domainkeys Identified Mail. But I'm not sure if the setting for Domain Selector is correct. I will check further and keep you updates. Thank you, Lily

Thank you, Shamaine!

Thank you, Shamie. Lily

Got it. Thank you, Mik! Lily

Hi Mik, Yes, I cleared the cache and used Chrome and IE. The same issue with the pagination. Other accounting team members in our company have the same issue. We are in the new release 2020.2. I suspect all users should see the same pagination. Can you please send me a screen shot of your pagination? If it's just us, maybe…

Thank you, Mik. Yes, I saw it in release notes of 2020.2. Lily