-
Add Journal Entry Account Number in Customer Statement PDF
Hi Team, I am trying to add the account number from the journal entry line level in the customer statement PDF. When I add the memo field, it populates correctly, but I am unable to retrieve any other values. Additionally, from the account record, I need to retrieve one custom field value in the PDF. Could you please…
-
Age in Days Function in Saved Search
In Saved Search results, we have the option of Function including operations like Rounding, Week, Year, etc. Among them, we also have Age in Days and similar functions. NetSuite notifies that this function can only be used for date type fields. Could you give an example of how to use this 'Age in Days' function? Thank you
-
Date/Time Math in SuiteQL
Hello, I am extracting data via SuiteQL using the Suiteanalytics Connect ODBC driver. Some of the use cases include various date and datetime output columns as well as date and datetime predicates. This article by Tim Dietrich implies that we can simply add a fractional day to a DATE datatype.…
-
Run a function on button click
I want run a Script on a button click (because you cannot run a function in your script ona button click) I've followed the Suitescript documentation and am only able to get the first like (a log line) to run. Any idea? ` form.setScript('customscript_toloader') form.addButton('custpagetestbutton', 'TEST button',…
-
Report Filters
Hello everyone, I am trying to create a report in netsuite with a filter for a certain "transaction number" The filter is as follows: Transaction Number : Contains "ov" I was wondering if it were possible for me to add a "AND" function with it. For Example: Transaction Number: Contains "ov and q" As of now, I am unable to…
-
Where is a list of Wildcards and Operators
Hi all, I spent half the night trying to find an understandable list of wildcards and operators for NetSuite SQL and am stumped. I'm trying to remove everything to the right of a colon : including the colon in a formula (text) search result. ie., search result is "055 Vendor Name : Vendor Contact" I've used various trim…