Subtotal of a transaction record cannot be retrieved by using it’s internal Id, instead we need to use a formula. In a transaction saved search, add all required values in criteria tab and result tab.For subtotal, add either of formulas shown below: Formula = {amount} – nvl({taxtotal},0) – nvl({shippingamount},0)Label = Subtotal Alternative for Formula (Currency):… Continue reading Calculating Subtotal amount for transaction saved searches:
Tag: Saved search formula result
showing more… in the text area field in the saved search result
Reason for showing more… in the text area field in saved search result
Common SQL Expressions For Saved Search
Character Functions Function Syntax Description CONCAT CONCAT(char1, char2) returns char1 concatenated with char2 LOWER LOWER(char) returns char, with all letters lowercase UPPER UPPER returns char, with all letters uppercase LTRIM LTRIM(char [, set ]) removes from the left end of char all of the characters contained inset RTRIM RTRIM(char [, set ]) removes from the… Continue reading Common SQL Expressions For Saved Search
Transaction saved search to find the quantity fulfilled and quantity available in multiple locations.
Saved search to show the quantity fulfilled, quantity available from item record and quantity shipped per day of a particular item in different locations from a transaction type search.