-
Saved Search formula
I want to do multiple case when and return the following If trandate is prior to Last year, return "LY" If trandate is current year, return "Current" if trandate is future years, return "LT" I am trying to get a report that returns the total amount of our amortization schedules are being current vs LT. I was trying to use…
-
Saved Search that shows records where Bill To and Ship To Customers are different
Hi Experts, What NS Saved Search Function can I use to pull a Saved Search to show Sales orders where Bill To Customer (Standard NS entity field) is different than Ship To Customer/End User (NS Custom field). Both the fields are linked to NS Customer record! Thanks in advance!
-
REGEXP_SUBSTR - JSON DECODE
Hi, I'm trying to decode a JSON to get a field for a saved search, but i would like to go through the structure of the JSON this is my JSON "committente": { "cf": "00180940041", "denominazione": "S.A.I.S.E.F. SPA", "piva": "IT00180940041", "indirizzo": "VIA VITTORIO VENETO N. 4", "cap": "12084", "comune": "MONDOVI'",…
-
Report or a saved search to pull the details of transactions that hit cash account
Hello, is it possible to generate a report or saved search that retrieves the details of the counterpart transactions associated with cash entries? For instance, if a transaction credits cash with 5k and has a debit side with 10 lines across different accounts totaling 5k, is there a method to extract the detailed…
-
SuiteAnalytics Calculations
I have a pivot table with two columns Item Quantity I am sort based on quantity What I really want is a % of the Total column (like old fashion reports can do) Any suggestions?
-
What is the Saved Search Formula for Most Recent Value?
Saved Search Formula Formula (Date) | MAXIMUM | CASE WHEN {item.inventorylocation} = {location} and {type} = 'Item Receipt' THEN {trandate} ELSE CASE WHEN {item.inventorylocation} = {location} and {type} = 'Inventory Adjustment' THEN {trandate} end end If an Inventory Item has both Item Receipt and Inventory Adjustment…
-
How to setup SUM of Quantities on Item Search?
Hi all I have this same problem before on a Transaction Search and a solution was provided. But now I have the same problem on an item search. The criteria of the item search includes transaction lines. It is a summary search and when I try to SUM the location available quantities it adds a line for every transaction I…
-
How to display Return Authorization Number when Applying Transaction is Credit Memo?
I wrote a transaction type saved search where the CRITERIA contains Type = Return Authorization (among other criteria). IN the RESULTS I created two formulas, one that should display the applying transaction if the TYPE = Credit Memo and the other should display the applying transaction if the TYPE = Item Receipt. The…
-
How to set up a Workflow that sends the appropriate email based on the value of a Line Item Field?
We have a quote based workflow that includes the send email action. On the quote form we populate the fields “Quote Type” and “Price Level” (at the line level). What we are hoping to do is send an email to a specific recipient if a certain quote type and price level are selected. For example: if the (quote type = project…
-
TO_NUMBER creating error
Hello, I have a number stored in a text field of an inventory item ({custitemcustitem_s2kdesc23} = 25). I am trying to use this number in a calculated formula. TO_NUMBER works if I use the function before the calculation. For example, TO_NUMBER({custitemcustitem_s2kdesc23})*2 = 50 However, 50 /…