You mentioned dividing numbers so maybe the value is divided by another value equal to zero which returns an invalid expression. To get around with this, add a condition to check if the value of {your_field} before the division. For example: CASE WHEN TO_NUMBER({your_field}) > 0 THEN TO_NUMBER(your_field} /…

Thanks for sharing the link. I'll ask the Web Team for an update.

Nice catch Chris. Please note that this may return to domain-specific at some point as well.

@"SeanSoaren",thank you for sharing that. I'll mention this to the ERP Team that manages the SuiteApp. I checked on the SuiteScript option and it looks like this is being considered for a future release as well - Enhancement Request: 154664 > SuiteScript > Expose Bank Statements Reconciliation

@"DavidMa", I found a similar case that references this error. The solution found that the error AN_ERROR_OCCURRED_WHILE_DECRYPT_PASSWORDGUID is due to the inconsistency between the parameters of createSecretKey. The parameters are encoding (encode.Encoding.BASE_64) and guid (fileContent of csd.key.pem). It is likely that…

@"Martha Hakes", I think it's related to the search id field, but may not be applicable in your case. The ID field is used as a script ID for this search. This will act as the internal ID of the saved search and must be unique. You can access this search programmatically through SuiteScript using this ID.

Hi @"Titei Dragos-Oracle", the Oracle NetSuite PBCS Sync SuiteApp enables you to extract accounting reports from NetSuite saved searches and use them in Oracle Planning and Budgeting Cloud Service (PBCS). This space will be made active soon, and will allow community members using this feature to post related questions.

@"SeanSoaren", the Announcements space is reserved for admins so thank you for posting here. Let me confirm the steps with our Advanced Accounting Team and I'll follow up with details.

I found a related SuiteAnswer 75282 that may help in this case: A GUID is generated using the addSecretKeyField() method (see example #2) for use with the N/crypto module's createSecretKey() method, but the AN_ERROR_OCCURRED_WHILE_DECRYPT_PASSWORDGUID error gets thrown regardless. Solution: The addSecretKeyField() method's…

@"DavidMa", I found a related SuiteAnswer 75282 that may help in this case: A GUID is generated using the addSecretKeyField() method (see example #2) for use with the N/crypto module's createSecretKey() method, but the AN_ERROR_OCCURRED_WHILE_DECRYPT_PASSWORDGUID error gets thrown regardless. Solution:The…

@"Martha Hakes", you should be able to use the "Never Empty" setting on the address book via Customer > Customize form > Sublists subtab. Click the Address tab and check the Never Empty option for the Address Book.

@"Antoine Lenoir", I found a similar answer that may apply in this case. The example provided applies to adding a Customer with Sales Rep when Team Selling feature is enabled, but you may be able to re-purpose this for the sales order. According to SuiteAnswer 42681: The Sales Rep may be set via Web Services using the…

@"razad", just to follow up, on the role under the Searches tab, is there is a specific search set up for this role that’s flagged as ‘restricted’? I asked around and no one could replicate this behavior - please let me know if you have a case number.

That's my understanding as well. It seems different from transaction searches but I'll ask the SuiteAnalytics Team for more info.

@"razad", reading up on Charge Rules I noticed the related permissions are tied to the Invoice permission. Just curious, what access level is set for Invoices on these roles and does changing Invoice access to Edit or Full makes a difference?

@"razad", charge rules are broken into different permissions: 1. Navigate to Setup > Users/ Roles > Manage Roles > Edit custom role 2. Under Permissions subtab > Transaction sublist > Add the following permissions: - Charge - Charge Rule - Charge - Run Rules 3. Set Access Levels. 4. Click Save.

@"Angel Chang", you can customize the financial ratios used to calculate turnover at Customization > Centers and Tabs > KPI Scorecards (Administrator), and click Customize next to Financial Ratios. You may be able to put together a custom formula using a variation of the Inventory Turnover and Days Inventory On Hand…

No, ID is the correct parameter. I don't see anything wrong with that link. Do you have a case number?

@"Paul Reading", is the leadsource parameter using the Campaign Id and not the Campaign Title? When I click the link, it redirects to http://www.lampspecs.co.uk/Manufacturers-Stores/Philips-Store

@"Antoine Lenoir", are you able to set the salesrep field in the UI with the same role? Also, is the Team Selling feature enabled in your account?

@"Chris Dobbins", a few things to consider: * Enable the Send if No Results option on the Saved Search Email subtab * Only one scheduled saved search can run at a time per user, with up to 200 concurrent scheduled saved searches per NetSuite implementation * When multiple saved searches are scheduled by a user for the same…

@"jono101", there was a performance issue reported around this time and normal service has been restored for all customers. If you are still experiencing problems please contact NetSuite Customer Support and reference Issue 556047.

@"Kenic", there was a performance issue reported around this time and normal service has been restored for all customers. If you are still experiencing problems please contact NetSuite Customer Support and reference Issue 556047.

@"roberth", the fix was released on 9/12 and Support is following up with attached cases. The notes indicate the unexpected error reported in Issue 550779 may still be reproducible. If you don't have a case for this, please submit a case with your details and reference Issue 550779.

3957212 wrote:Hello, I ended up just leaving as is for the one user and had to move on to a much larger project. I have been buried so I apologize for the late response. In this new forum, I can't figure out how to get replies emailed to me when I post. Hi @"3957212", To subscribe to your thread or other threads: * Open…

@"Martha Hakes", learning JavaScript is the logical first step to start developing scripts using the SuiteScript 2.0 API. A few other things to consider on the application side would be: * Automate a process such as defaulting values, validating fields, and executing scripts on a schedule * Speed up my client scripts by…

@"PaulFleetwood", it was filed under v2019.1. Support is currently following up with attached cases.

Just a follow up to issue 550779 - we are currently in the process of releasing the fix to all accounts.

@"MOvadia", thank you for sharing this here - 387723 Intercompany Purchase Order > Inventory Item > The currency for an intercompany PO/SO must be the base currency of either the purchasing subsidiary or selling subsidiary. Unfortunately, I don't see an alternate solution posted in the notes.

A quick check using SuiteScript shows the field is editable using: nlapiGetLineItemValue('packagefedex','packagingfedex',1)"10"nlapiSetLineItemValue('packagefedex','packagingfedex',1, 11)undefined