-
Custom Formula Field in Financial Reports – Possible or Alternative Solutions?
Can we create a custom formula field in a financial report, similar to how we create formulas in a Saved Search or a SuiteAnalytics dataset? If not, is there an existing enhancement request for this feature? Are there any alternative methods to achieve the same functionality within financial reports? Looking forward to…
-
DataSet Criteria AND/OR parenthesis
Hi All, I'm trying to replicate a saved search in Analytics to see if I can produce a graphic representation with layered values. I have 2 issues. My "base" saved search Criteria is using expressions and parenthesis as I am interrogating transaction field "type" in 2 parenthesis. When I try to create the 2 parenthesis the…
-
Analytics formula field
Hello, I am trying to create a formula field in my dataset on SuiteAnalytics but i'm not getting the results. I am wanting a formula field to show projected total when the status is Won. This is my formula, output type is FLOAT Case when {status} = 'won' THEN {projectedtotal} ELSE 0 END I have tried changing 'won' to 'job:…
-
Gross Profit Percentage Value in Email Alert
Hi, Trying to add a GP% formula WITH a percentage format (see 3rd line below) in the body of a notification, but coming up with nothing but errors. Can anyone help? REVENUE: ${netamountnotax} GROSS PROFIT: ${tranestgrossprofit} GP%: <%=${tranestgrossprofit}/${netamountnotax}%>
-
Saved Search - Custom Formula Error
Trying to divide the Duration Decimal (Hours) by formula created to know how many hours they actually worked based on work factor however it doesnt work. Please suggest how to proceed Formula - ({durationdecimal}/((40/100) * {item.custitem53})) Duration Decimal - Gives us value in decimal also, also it has zero also, if…
-
How to move decimal places in a saved search result?
I have a field as a result in my saved search which i'd like to move the decimal places. I have tried to research and can see i need to use formula numeric and potentially to_char but really struggling on getting this right. Could someone help at all please?
-
Is it possible to retrieve values of custom fields with Store Value checkbox unticked using SuiteQL?
Is SuiteQL able to return results for fields where the values are calculated dynamically based off a formula and/or where the "Store Value" checkbox for the field is NOT checked? When attempting to pull the value out of formula-based field, I get the error Search error occurred: Field 'custcol_XXXXX' for record…
-
What to do when I'm getting the Error When Using Case function to divide?
Hi All, I'm trying to calculate DSO (Days sales open) according to the formula below: Average of last 12 months / payment terms days (For example Net30 = 30 ) I'm getting an error when i'm using the formula from the screenshot below: If, you have solution please share with solution how to do it custom field as well
-
Can I add location safety stock to order item screen
Hi Guru's, I am trying to add the safety stock to the order items screen. The option does not come up in the list to add, so I am trying to create a custom field that just copies the value from the inventory location safety stock value. I feel like I am close, but I can not get the formula to work on the field. Here are…
-
How do I convert a field to another currency via Workbook Analytics?
Hi experts, I have this problem, I have advances to suppliers in different currencies and I need a report that allows me to estimate the net amount of debt to suppliers in the same currency. In Analytics I prepare a dataset and try to convert the values in foreign currency to local currency. I use the…