Edo_Aroni Red Ribbon

Hi @Harsha Kumara, Thanks for tip 🤨 However, I tested your solution and found that to correctly compare the two dates, the .getDate() method should be removed. The comparison should be done directly between Date objects: nlapiStringToDate(nlapiGetFieldValue('trandate')) > nlapiAddDays(new Date(), 90) The code above works…

Hi pcourtemanche2023, I agree with @Wee Ming. It is not possible to use {today} in the "Show Message" action because this action only triggers on client events, and {today} is a server-side function. However, you can use {today} in a server trigger action. For instance, with a server trigger if you want to return a user…

Hi @Veronica Steluta Mincior-Oracle , I might be overthinking this, but while your answer makes sense to me, it still doesn't clarify which three record types have online form capability as stated in the study guide for the Admin exam. Thanks Edo

Hi @Patrick Fresnosa-Oracle , Thanks, I appreciate your post. I was aware of the "copy" scenario, but in my case, the situation was exactly as described in the SuiteAnswer mentioned by @Wee Ming. I later found out that an enhancement request has already been logged for that as well. So, I voted for both of them 😊 Fingers…

Hi @Wee Ming Thank you for your assistance. While I found information about raising POs for inactive vendors, I wasn't sure if those specific steps were always necessary. I was able to replicate the issue without following them. Upon closer inspection, the reference material seems to focus on finding inactive vendors. I'm…

Hi @Vajrala Madhu Reddy , Yes, it is definitely the same vendor account.The system notes confirm the vendor was inactivated on June 24, 2024 , while the purchase order (PO) for the same vendor was created two days later on June 26, 2024. This discrepancy is indeed puzzling. Thanks

Hi @User_84VR3, Did you try to reset the 2FA settings? Setup » Users/Roles » User Access Reset Tool I hope this helps 🙂 Edo

HI @Nicole Mendoza-Oracle, Great! I'm finally on top of it. I really appreciate your help with this matter. Many thanks, Edo

HI @Nicole Mendoza-Oracle, Via SOAP API it seems that date fields are stored as a date-time, and we are unsure how this date-time is converted to a date. Please see below example: on the UI and PDF document we can see custbody_eii_contract_start_date: "21/6/2021" But accessing it via API we can see…

HI @Nicole Mendoza-Oracle, Thanks for the information about the SOAP endpoint. Now, I would like to know which time zone is used on the PDF documents. Is it the same as the one in the UI? Or is it the one selected in the Company record?

Hi @Elina Kourouzidou, Multiple Units of Measure (Enable Features » Company » ERP General ) must be enabled to use Statistical Accounts. I hope this helps. Thanks Edo

Hi @Angela Bayliss , Thank you for the tip. I have created a saved search based on System Notes, using the criteria FIELD with the values: File and Folder. Thanks Edo

Investigating on the issue I have found out that the source bills don't have selected amortization schedules. It is not possible to edit those records and add them now. I believe this is because the full amount of the bill has already hit the Prepaid G/L account.

Hi @Edwards_05, My understanding is that you have already customized Advanced PDF/HTML check templates set up in NetSuite and you would like to switch between different templates in order to get the related different print out. Not sure if I got if right. Anyway, any Advanced PDF/HTML check template is linked to a…

Hi CK43213, We had a similar issue and it somehow disappeared when we unticked the EFT check box, saved record , edited the record, checked the EFT box again and saved the record. You might want to try that. I don't see any risk doing that. Thanks, Edo

Hi @Jack Daryl Espiel-Oracle , Correct I was referring to a check box . It must have slipped in my mind. 🙄 Curiously, also in my solution I called it exacly simply email sent 😉 Thanks for confirming it. I much appreciated your feedback. Thanks, Edo

Hi @Gabriel Jarillo Soto, A solution that I have used for a similar problem was to create a custom text box in the record (in my case was the invoice record) that change the value to true (tick) when the email is sent out the first time and a simple condition based on that check box that skips the email action when the…

Hi @Patrick Fresnosa-Oracle , Your solution helped me to find the report with the option allow web query enabled but when I disabled it and run the saved search again I come across inconsistent results: that report was still listed in the saved search Anyway I have figured out how to resolve the issue and I take this…

Many thanks @Patrick Fresnosa-Oracle , Fantastic! 👍️You helped me to resolve my query and also teach me another method to retrieve data using the Analytic Audit Trial. 😊 Much appreaciated your help, Regards, Edo

Hi, I was able to find the invoices with no revenue arrangement using the following criteria on a transaction type search: Cheers, Edo