User entered a custom description on the Description column on the line item of the Sales Order. They then wanted to show this description on a transaction saved search. There is no Description field on a transaction saved search. If you will use Item Fields: Description, this will pull up the Sales Description on the Item Record. To show Line Item… Continue reading Display Line Item Description on a Transaction Search
Tag: transaction saved search
Saved Search for show the Related Records of Transactions
We have created a transaction search with Criteria set as :- FILTER DESCRIPTION Main Line Is false Tax Line Is false Shipping Line Is false COGS Line Is false Under Results > Columns , enter the following fields:- FIELD SUMMARY TYPE Internal ID Group Type Group Name Group Document Number Group Date Group Amount (Foreign Currency) Amount (Transaction Total)… Continue reading Saved Search for show the Related Records of Transactions
Search to get inventory details of Lot Numbered Inventory Items
/** * function to search inventory details of lot numbered inventory items */ function invtDetailSearch(itemArray) { //An array of lot numbered item is passed as argument to this function. try { var searchResultArray = []; var JJ_invtDetailSearch = search.create({ type: “inventorydetail”, filters: [ [“item.internalid”, “anyof”, itemArray], “AND”, [“expirationdate”, “after”, “today”], “AND”, [“itemcount”, “greaterthan”, “0”], “AND”,… Continue reading Search to get inventory details of Lot Numbered Inventory Items
Calculating Subtotal amount for transaction saved searches:
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:
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.