Hello @Nicole Mendoza-Oracle I have added the snippet for the script Thank you

Thanks, I was able to pull Billing field but I am trying to create this report similar to the Project saved search that I created. And I was unable to display few fields like ACCOUNT MANAGER, ACTUAL WORK, ESTIMATED WORK and PERCENT TIME COMPLETE into the report but they are available in the saved search. Please advice.

There is no standard fields present in the Customer record. But the fields are added to the customer record through the custom Sublist. I have attached the screenshot below.

The issue is resolved. Thanks!

The way I have to calculate age is by subtracting today with the first INV date of that customer. I have attached below the formula that I am using to calculate date in saved search. I am able to calculate it and use BEFORE LOAD script to paste this value in the field called "Age" in customer record. Only when the Age…

@Jack Daryl Espiel-Oracle It's Customer Payment.

Hi @Mikko De La Fuente-Oracle , you have mentioned that "I also agree on using Saved Search to be able to get the desired data." Could you please let me know how to get the monthly budget figures in saved search. I tried it but I am getting the same error, as mentioned by @PaulFleetwood

I need a year filter as I highlighted in yellow colour . When I change the year the new data should get updated in the chart

Hi @Ivy Lopez-Oracle Could you please advice?

The Administrator role's Inventory Number subtab has the following serial number. The Custom role's Inventory Number subtab has the following serial number. It displays only the serial numbers with location. I tried checking the "Available as Sublist View" checkbox in the search too but still the search does not display…

In administrator role, an Item displays a serial number with no location (Inventory Detail > Inventory Number subtab). When I logged into another role I couldn't locate that serial number, item displays only the serial numbers with location. Please advice.

Hi @Mikko De La Fuente-Oracle , Yes, It is working on other machines and also on mobile I have tried it with same User/Role.

@Dominica Sevilla-Oracle Any update on this? Could you please help me out?

Here is the Inventory Detail page from the Item Receipt record. When I try adding the same serial number that's in the claim record, it throws the following error. When I add another serial number that's not linked with the item, it throws the following error when clicking on SAVE on the item record. Even if I use Standard…

I hid the Inventory details field in RMA and it got saved. When I click on RECEIVE in RMA, it takes us to the Item Receipt page and it asks for Inventory Detail there too. I tried hiding it there but it throws error while saving IR. Could you please advice?

I found the reason for the issue. When User is checking the checkbox in saved search, at this point of time checkbox value is coming as empty is the user event script . Can anybody tell the solution for this issue.

The checkbox is shown in all the required forms and the User Event script is set to execute as "Administrator" role. Yet the checkbox returns empty value.

@Tiru Chembeti The accounting period is open and still I'm not able to edit the amount field to make it as zero.

Now, it displays only the subtotal but still the values are getting duplicated.

I tried but still the values are getting duplicated.

I have added that in criteria as well but no help

Sure, Thank You @Mikko De La Fuente-Oracle

Hi @Mikko De La Fuente-Oracle I am using Data Warehouse Integrator (DWI) role to connect Data Grip with NS. The connection URL I am using is jdbc:ns://<AccountID>.connect.api.netsuite.com:1708;ServerDataSource=NetSuite2.com;Encrypted=1;CustomProperties=(AccountID=<AccountID>;RoleID=57) . Did I need to change anything in…

Hi @Mikko De La Fuente-Oracle Now I am getting "[S1000][214] [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Your account was locked for 30 minutes due to too many login failures in a row. Please try again later or contact your administrator for assistance. Error ticket# l4cfr3ap1l9wm62rromlf[214]"…

Hi @Mikko De La Fuente-Oracle I am starting it right now and I also tried the NetSuite2.com but still getting the same error (Internal network error, connection closed) Thanks, Siva.

Hi @Mikko De La Fuente-Oracle , 1.I am working on Microsoft Windows 11 . 2.Yes, I have tried using other application(IntellJ) for testing connection, it also received the same error 3.No, I am not using VPN 4.I am using NetSuite.com data source

I am getting a different error. Please see below " you cannot delete the end of group line. You must delete the group" .

Hi @Mikko De La Fuente-Oracle , Yes, I have checked and undeployed all the script and workflows before tested my UE Script.

Hi @Erick Dela Rosa-Oracle Please find the code below: /** *@NApiVersion 2.x *@NScriptType UserEventScript */ define(['N/record'], function (record) { function beforeSubmit(context) { try { //if (context.type == context.UserEventType.CREATE) { var currentRecord = context.newRecord; var shipMethod =…

Thank you for inputs.