Hi @Vernita, This is how we are appending URL in our codes. var s_Website = obj_JSON_Customer.Website; if(s_Website) { if (s_Website.indexOf('http') == -1) s_Website = 'http://' + s_Website } if (s_Website) obj_Customer.setFieldValue('url', s_Website);

Hi Dext3r, Can you show us the drop down value under "VIEW". If you select the Value as ALL is it showing all items ? By any chance is their 2 BASIC VIEW create? Can you confirm

Hi User_SLDIG, Havent found anything which can directly help in generating SQL. However, there is a chrome extension "Export Search" which helps in getting the basic expressions which can be helpful to get the SQL data set.…

Hi @Kedalene Hope this helps :

Hi User_27WTV, This typically happens if someone has created vendor/customer using OTHER RELATIONSHIPS feature. This is available under relationship tab. On edit mode, click on + sign and generate the entity

HI ONO4, Can you let us know the exact requirement for fetching the search URL. Do you want to give reference to URL for user to click.

Hi cduran, This may not be possible directly without script as class can be at both line and header level. We had a similar requirement earlier but with little different expectations. To overcome this, you can create a FIELD on class with dropdown values as ROLE. Dont forget to make the field as MANDATORY to avoid…

Hi User_CNLH5, This is NS standard behavior where if the bill payment amount adds to 0, system automatically changes the status to Paid in full but in system there is no reference to bill payment.

If you want to mark all accounts to checked, then you can direct add it in import assistant OR you can pass the values in CSV file as well. Either ways it will work

Hi @Kedalene I am able to see the field using Admin role with update scenario :

In your 1st screenshot, there is a condition box. put condition as USER = DEFAULT USER.

Option B, C and D.

Hi @Imzy_code The most simplest way will be to go to list of chart of accounts and identify accounts with 0 balance. Ignore the summary accounts as they will show balance but doesnt have any posting.

Hi, Can you modify the workflow. If yes, try performing following actions : Set the approval status as APPROVED when context = WEBSERVICES and USER = SPECIFIC USER ACCOUNT.

Unfortunately its not expected but its the way it is at the moment. The entire SO shows the status as closed.

Hi @Vikas Som , Adding on global search wont be possible. The other workaround will be to store the data in custom field and then expose it for global search. Store value should be checked for custom field.

Try using this formulae in saved search. DisplayName is standard field on Account saved search.

Yes, you can create a period and post all transaction to this period. Please make sure all previous period are closed and no future period are created.

Incase you are planning to use NetSuite for financial reporting or taxation, creating single period is not recommended. Accounting Period are created for every month. Keeping an accounting period open, will not run your month end processes like currency revaluation etc.

Admin can open or close any accounting period as it has full permissions as required. To open any accounting period, click next to period name there is a blue checklist field. and user will be able to see the REOPEN period button. Provide an explanation to re open the period in justification box.

Hi @AhmedM can you try : RTRIM(REGEXP_SUBSTR({displayname},'[^:]*')) in saved search to pull parent name.

Hi PaulFleetwood, This is currently an enhancement to pull current date/time in report. As a workaround, when the user download the report, they will have to rename the file appending with date time.

Hi Kedalene, Just pass the internal ID in CSV file and directly check the revalue checkbox on import page.

Hi User_Q1DPO, Unfortunately like Sales side, we don't have discount field. However, for total discount on PO once you have added all line items add a SUBTOTAL ITEM followed by DISCOUNT ITEM. This will add overall discount on PO.

Hi @Kedalene In this case, navigate to reports -> Banking/Budgeting -> Cash Statement.

Hi@Kedalene can you check the report " Bank Register" and confirm if it helps. Path : Reports -> Banking/Budgeting -> Bank Register.

can you create a saved search on account with CTA account. If yes, you can run a search in suitelet to pull the value. You might have to verify the balances once.

Hi @Dext3r The error shows that the coupon code field should have 5 characters only. Can you check the input value is exactly 5 in count.

As soon as you have updated the amount prior to running depreciation .

Using administrator role you will have to run the precompute asset depreciation and reset asset values button to update it.