Michelle Jabanes-Oracle · Account Admin/CRM Guru & Oracle NetSuite Community Admin · Admin

You're welcome, @User_75YL8.?

Hi @JohnCirocco We're looking into it, and we'll update you as soon as possible. Regards,

Have you tried setting it to Count? For reference, please see SuiteAnswers Defining Summary Types to Roll Up Search Results. Thank you.

Thank you for checking. Please confirm the following if it will remove the duplicate amount. Set the Summary Type into Groups Remove fields that could possibly add up the duplicate amounts in the search. Applying Transaction : Amount (Transaction Total) Applying Transaction : Delivery Date (Custom Body) Let us know how it…

Hi @emcee_uk , Per checking, this is related to Enhancement # 152697 Ability to show more than 10,000 records of exporting to CSV/Excel File. I suggest voting for this enhancement at SuiteIdeas and please add notes that you're also encountering the same issue when exporting the dataset from SuiteAnalytics. Thank you.

Hi @User_75YL8, Here are the Password Reset Tips for Administrators. If an account administrator resets your password, your previously saved security questions are erased and you must set up these questions and answers again. Security questions and answers are shared across all NetSuite accounts associated with the same…

Hi @Dwight Schrute, Yes, this is possible through Advanced PDF/HTML Templates. Make sure you use html when sending the email. For reference, please see SuiteAnswer Id: 63077 | Advanced Templates for Printing Saved Search Results. Thank you.

Hi @MarkCRobinson Thank you very much for creating this thread! Allow us to check on our Gurus who specializes in this area and we will get back to you the soonest time possible. Any members who has an insight on this, please feel free to reply to this thread.

Hi @User_HPB3I, Try setting the Summary Type to Sum. Thanks,

Hi @GaryR Thank you very much for creating this thread! Allow us to check on our Gurus who specializes in this area and we will get back to you the soonest time possible. Any members who has an insight on this, please feel free to reply to this thread.

Hi @User_DPS2Z, By default, new sandbox accounts are accessible only to NetSuite account administrators. If you are not an administrator and do not have access to your sandbox account, contact your NetSuite account administrator for access. All of your roles can be found on the My Roles page. You can identify each account…

Hi @emcee_uk , I would like to follow up on this thread. Please confirm how many fields you added to the dataset. In my testing, I had 150 fields and 2,002 rows, and it successfully exported fine. Does using a different browser or deleting your cache help? Thank you.

Hi User_HPB3I, In Criteria tab > Standard subtab > Add Filter: Main Line is true. I hope this helps.

Great! You're welcome. ☺️

Hi @User_HPB3I, Have you tried using case when? This example worked fine in my testing. CASE WHEN {fieldname}='T' THEN 1 ELSE 0 END I hope this helps.

Hi @emcee_uk , How many fields did you add in the dataset? In my testing, I had 150 fields and 2,002 rows, and it successfully exported fine. Have you tried using a different browser or deleting your cache?

I'm glad it worked!☺️

Can you try adding this criteria below to eliminate duplicate item lines in the result? It worked fine in my testing. Formula (Numeric) = {transaction.line} = is equal to 1

Hi @Dwight Schrute, Yes, it is possible. You can use <#list> to get the line item fields. Please see example below. <#list transaction.item as listItem> <tbody> <tr> <td> ${listItem.item}</td> <td> ${listItem.description}</td> <td> ${listItem.quantity}</td> </tr> </#list> </tbody> I hope this helps.

Hi @User_HPB3I, Enable the Show Totals checkbox to sum the Transaction : Amount column. I hope this helps.

Hi @User_EKY01 Thank you very much for creating this thread! Allow us to check on our Gurus who specializes in this area and we will get back to you the soonest time possible. Any members who has an insight on this, please feel free to reply to this thread.

Hi @Manuel Dambo I would like to follow up on this thread. Please let us know if you need further assistance. If there's none, kindly click "Yes" on "Did this answer the question?". This will aid others with the same question to easily find the correct answer. You will also earn points and may unlock the Answer Accepter…

Hi @User_HPB3I, Do you want to sum the amount in the search? If so, you can group the other fields and sun the Transaction : Amount field in the Summary Type column. I hope this helps.

Hi @Manuel Dambo This is possible if the employee record of the user's class field is blank. However, if you only want this to apply to the Transaction record > Communication > Files, you can setup a workflow and make sure that the Execute as Admin checkbox is enabled. I hope this answers your question. Thank you.

Hi @Camila O Thank you very much for creating this thread! Allow us to check on our Gurus who specializes in this area and we will get back to you the soonest time possible. Any members who has an insight on this, please feel free to reply to this thread.

Hi @User_IJB6M Thank you very much for creating this thread! Allow us to check on our Gurus who specializes in this area and we will get back to you the soonest time possible. Any members who has an insight on this, please feel free to reply to this thread.

Thank you for updating this thread, @JohnCirocco. Can you uncheck the email notification settings and resave, then change back to email? Let us know if refreshing this setting helps.

Hi @nag_m Yes, I indicated above that if the Journal Approval permission is set to at least the "Create" access level, it allows usage of the Approve Journal Entries task. If it is set to only "View" access level, it only allows usage of the Journal reminder. In addition, here are the following permission levels are…

Hi @nag_m The following are general definitions of possible access levels for permissions. VIEW - User has access to view existing files only. The user cannot create new, edit existing, or delete existing files. CREATE - User can create new and view existing files. The user cannot edit or delete existing files. EDIT - User…

Hi @SanjeevV Thank you very much for creating this thread! Allow us to check on our Gurus who specializes in this area and we will get back to you the soonest time possible. Any members who has an insight on this, please feel free to reply to this thread.