-
Tax per transaction line
I have an issue with VAT reporting. I’ve been trying to use PowerBI to do the tax reporting as we cant get all the fields from saved search. The reporting works apart from that the VAT is group for each transaction and put onto 1 line By this I mean if the vendor bill is posted to multiple accounts/cost centres etc and…
-
NSC | Using NS_CONCAT as Summary Criteria
The NS_CONCAT function is typically used for Formula fields in the Results tab of a Saved Search to show a list of values in only a single row. Refer to this article I wrote that discusses more about this. However, did you know that NS_CONCAT can also be used in the Criteria tab > Summary subtab of the Search? Note: If you…
-
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'",…
-
NEXT_DAY expression in Saved Search cannot accept field as second parameter?
Hello, all, I'm trying to get the NEXT_DAY expression in a saved search formula to accept a record field as its second paramter (for "day of the week"). In other words, instead of passing a constant string value: NEXT_DAY({startdate}, 'MONDAY') ...I'm trying to pass a field/variable. NEXT_DAY({startdate},…
-
WATCH: Search Formulas SQL Expressions CASE syntax
This video contains a solution on how to create a Saved Search that will include results depending on a CASE clause SQL expression formula. Here is the formula used in the video presentation: CASE WHEN ({isperson} = ‘T’) THEN ‘Individual’ ELSE ‘Company’ END