CDuf · Business Systems Analyst · Bronze Trophy

If when you say last 2 spaces you really mean spaces, you could try looking at: TRIM(TRAILING '1' FROM 'Test1'); //returns 'Test' and replace 1 with ' ' or the RTRIM('123000', '0'); //returns '123' and replace the '0' with ' ' See SuiteAnswer ID: 21503 RTRIM: Removes all specified characters from the right side of a string…

Great Jack, I'll give it a try and let you know. THANKS

Yes, thank you Michoel. We performed our required actions on November 11th continued using SuiteAnalytics Connect ODBC and all was working fine until we tried to use it again on the 20th. If anyone else is experiencing an issue using SuiteAnalytics Connect (ODBC) through the Microsoft SQL Server Management Studio("SSMS"),…

Yes, thank you Erick. I had already logged one. There is an outstanding "defect" related to the SSMS that I asked my case to be attached to but support thinks it is a Microsoft issue. Odd that it occurred immediately after the SuiteAnalytics connect for ODBC change was pushed. Would you interested if anyone else is…

You can also "set" or let default all appropriate roles Permissions>Lists>Items to "View". Additionally, with the workflow suggested, you can add a condition that would apply when User Role not equal Administrator, so that if there is a valid need to change the Item number, the Administrator can.

As Administrator I think you should be able to change the owner to yourself, Save, then inactivate or delete.

I added VIEW access to Manage Accounting Periods and could successfully edit the invoice.

Thank you Michele. I apologize for not finding this myself. I appreciate your time. Best Regards,

Thanks again Michele. I apologize for not being clear. I'd like (with my fingers crossed ) to be able to automatically send an email (schedule) to the Primary contact at each Customer (I created a dynamic recipient Group) that delivers only the result of my Contact saved search (listing all customer's contacts) that…

Have you tried searching by Document #? 2019.2 Release notes indicate Include or Exclude Transaction Numbers in Global Search New role- and user-level Global Search preferences enable you to include or exclude transaction numbers from your global searches. To include or exclude transaction numbers at the role level,…

RESULTS: the list of ALL contacts was included in the email and not just the contacts related to the Primary Contact's Company. How do I create a saved search of all contacts that will only deliver each company specific contact list to the Primary Contact on each Company (like a contact sublist view on Customers)? Anyone?…

Yes, Thank you Michelle. My apology, I had the dynamic Primary contact group created. I should have worded my question better. I want to email this dynamic group of Primary Contacts a list of all their company contacts. My goal is to ask them to review the list of contacts and either update the company contacts on the…

found this. maybe it will help. + was your July period must have still been open to allow July 31st posting. Billing Customers Using Billing Schedules Published 03/04/2011 11:52 AM | Updated 08/02/2019 08:52 AM | Answer Id: 9165 Order Management Billing and Invoices Advanced Billing Using the Advanced Billing feature,…

I have a Set Field Value after my Go To Record (Open in Edit Mode = Y). My workflow sends the value to my record but does not Set Field Value until I manually open and Save the record. I am looking for a Workflow Action or Workflow Action Script that will Execute my save and save the field value.

Yes, you likely already resolved this. wwinters is correct. Throughout NetSuite, Set Preferences is role specific so the path Set Preferences>General>User Profile section, needs to be completed for each role. Be sure to check the "Add Signature to Messages" box. Best Wishes. NICKNAME This setting applies to all your roles.…

opps sorry... this gets me the First Day (From Date) as the last day of the first month of last year(January 31, yyyy). I was trying to get the first day of the last year (January 1, yyyy). I am looking at your First Day: script and SuiteAnswers to try to figure out where to insert something that defines the 'dd' as 01 as…

Thank you Robert, This worked for me as well... I'll leave this question open for a bit in case... as you say... someone identifies a "cleaner" way.... but this is great for me... THANKS

Thank you CDobbins. This worked... Greatest just the play on words. THANKS!

Thank you JCirocco. This worked great.

I tried both and the BOTH work!!… THANKS!!! I appreciate it.

We are interested in something similar as well... We sell software and as part of our sales cycle, we provide the Prospect a "Trial" license/subscription that expires in a stated period of time for no cost. Since it is part of the Sales process and the Prospect has not made a commitment to purchase the license/subscription…

Thanks, as I went back to capture print screens, I previewed it again and audited some of my results. I audited more results and find I still have the same issue. My Summary Criteria is Summary Type = Maximum, Field = Expiration Date, Description = is not after today. I need a way to tell the system if there is NO…

Closest I could get was the ITEM Vendor not the PO Vendor.. Item "Vendor" information populated on the ITEM. in your Saved Search, scroll down to the ...related records for ITEM Fields... and select Vendor I think the Vendor Name on the PO transaction is too far away from the Sales Order. Attaching screen shots... as far…

Yes, Thanks... I've tried that... my Results have a Max Expiration date ITEMMAXIMUM OF EXPIRATION DATEMAXIMUM OF FORMULA (DATE)CUSTOMER STAGECUSTOMER STATUSCUSTOMER LAST SALES ACTIVITYForms : StateW4.com Access5/28/20165/28/2016CustomerWon4/18/2018 and the Summary Criteria is Summary PARENSSUMMARY…

If you go to the List of Saved Searches>Open the Filter> Show All Private Searches = Yes, the searches you have not been able to find are displayed in the list and are Editable... Thanks for the tip from a colleague.... :)

I see this old topic from 2012 with no activity. I now have a similar request. How can I remove the Set Preferences option from my Customer Center (Role). It looks like the only way to remove the Campaign Subscription Center link is to disable the related feature. I would like to also ADD a portlet. Thanks

Some NetSuite White Papers for your comparison - http://www.netsuite.com/portal/asset...itebilling.pdf & http://www.netsuite.co.uk/portal/ass...lling-emea.pdf There have been updates since these were published and SuiteAnswers can offer more information. [h=1]Subscription Management[/h] Published 03/24/2017 12:10 AM |…

.moved to private

I can create the link.... and I can get to my survey... I wanted the survey to capture the Customer id and Project id... but only they ${project.parent.id} and ${project.id} are captured... They display properly in the email Here is the link to the survey: (I masked it a bit)…

We are also a software company looking for this information but with more detail. We need to be able to determine; of our outstanding AR balance, how much remains in Deferred revenue(unrecognized revenue). We need this by Item(Class). Our formula ((AR Aging - Tax = Net AR Aging) - Revenue Recognized) = the amount of…