Thank you

Ok noted

its ok. I found the solution, we just need to create a custom field as store value so that the option "mine" is displayed to be used on saved search

Hello @Patrick Fresnosa-Oracle , I managed to do it. See below the correct formula: case when {type}='Journal' and {transactionlines.cseg_sl_contractid#display} = 'N/A' then 'NULL' when {type}='Journal' and {transactionlines.cseg_sl_contractid#display} is NULL then 'NULL' when {type}='Journal' and…

Hello @Patrick Fresnosa-Oracle , Thank you for the info. But it still do not work because on the journal line there is no column 'project' which is being used unlike customer column which is filled by the user. So, I am wondering how to use the column 'contract id' and use it to filter in the table 'project' using a…

hello, I managed to get the customer (entity) values using the contract id on the journal line using the below formula. However, I struggle to do the same for project. Any idea please? Thank you. CASE WHEN {type} = 'Journal' THEN CASE WHEN {transactionlines.cseg_sl_contractid#display}='CM24312 CNT-00031754' THEN…

Hello, No. Following further investigation, it seems that only for journal that the value is not being displayed but for other transaction type ex. invoice, bill, etc it works fine. Does anyone have any idea why it is not only working for journal? below the suiteAnalytic formula : case when {type}='Journal' and…

Hello all, I managed to get the item description it was in the following path:Transaction Line/Transaction Accounting Line/Transaction Line/Item

Hello, The report will not be useful for the budget validation saved search. We need to add the budget category for customisation of budget validation on Requisition. Can anyone help please? Thank you

Hello, Yes we noticed that there was an existing script and workflow causing this issue. We deactivated both and it works. Thank you

the issue has already been solved. Thank you

thanks a lot

Hello, No. I still need to work on it.

Hi, I no longer got the error message with the modify formula below: CASE WHEN TRIM(TO_CHAR({locationconfiguration.nextinvtcountdate}, 'DAY')) = 'MONDAY' THEN ( CASE WHEN {locationconfiguration.nextinvtcountdate} BETWEEN TO_DATE({today}) AND TO_DATE({today} + 5) THEN 1 ELSE 0 END ) ELSE 0 END However, there is something…

hello, You spot on my exact requirement. However, I still receiving error message "formula has an error". Any idea please?

Yes I was looking for that but I did not see it in the filter. I see it only when I type "today" instead of scrolling down. Thanks a lot.

Hi, We would like the date to be set to the current date instead of entering a specific date. How can we achieve this please? thank you

Ok thank you

Yes. I already did the same. Thanks a lot.

Issue already solve. When I change my netsuite password, I did not change password on the ODBC connection. Its ok now.

Hello, Yes exactly the same record type as the standard vendor record type

Hello, So you mean, it is not possible to apply the bundle functionality to another custom record, isn't? thank you

Yes. Thank you. But this does not meet my requirement. I do not want to make a copy of a record transaction but a copy of the record type.

Hello, The script cannot be edited.

yes thank you

hello, thank you for your prompt response. We got the issue because we were not filling the the proper column for the vendor intercompany. Thank you.

see screenshot below:

Hello, thank you for your prompt response.

Yes. I wanted to do it via a workflow but if there is no other way then I will need to create a client script.

Hello, Thank you for your response. However, we should not hide the column price level otherwise other uses will not be able to change the price level or use another form because there should be only one form. I was thinking about a workflow but workflow does not seem to be working…