Articles tagged #SAVED SEARCH
Articles tagged
#SAVED SEARCH
Scheduled Saved Search of Inactive Employee Not Sending Email
A scheduled saved search is not sending emails.
Create a Report That Shows Breakdown of Landed Cost for an Item
User need a report that shows computation of the landed cost added to an item through Item Receipt Transaction to help better understand the breakdown of costs of inventory and a summary of landed costs. However, this report is currently not available and logged under Enhancement 138943.
Saved Search for Fixed Assets and Their Remaining Lifetime Before They Fully Depreciate
User wants to see a list of the asset records and their remaining lifetime before they fully depreciate.
Create Saved Search of Fixed Assets Without Asset Values
Asset Value records are normally generated by NetSuite upon Asset creation. User needs to find Asset records that do not have any related Asset Value records.
Saved Search to Fixed Assets Future Depreciation
User would like to create a report or saved search that projects the remaining depreciation for each asset into the future
Saved Search to Compare the Base Price and Purchase Price of Items
User would like to compare the Base Price of an Item against the Cost of the Preferred Vendor set in the Item record.
Saved Search for System Notes Notification When Purchase Price Field Is Modified
The user has an existingItemSaved Searchthat would notify him every time thePurchase Pricefield of any item is modified. But when the report runs, users gets an email of anySystem fieldthat has been modified.
Create Saved Search for Drop Ship Items with No Purchase Price
A user would like to create a Saved Search that displays Drop Ship Item with Purchase Price empty.
Item Saved Search for Purchase Price History
User wants to create a saved search for Purchase Price History of items
Saved Search to pull up Bill Credits with Unapplied Amount
User wants to create a saved search that shows Bill Credits that have an unapplied amount.
Create Saved Search to Show Items Which are Not Component/Member of Any Assembly
Saved Search to show Items Which Are Not Component/Member of Any Assembly.
Transaction Saved Search to List Files Attached to Invoice Records
Create a transaction saved search to list files attached to Invoice records.
Display Amount Net of Tax (Foreign Currency) on Transaction Searches
Currently, there is no standard field to show Amount Net of Tax (Foreign Currency) on Transaction Searches.Enhancement 207815has been filed to keep track of the process of making this functionality a part of standard NetSuite Features.This article will tackle how to expose the Foreign Currency Amount of Foreign Currency Denominated Transactions (Net of Tax) entered in NetSuite in a Transaction Saved Search. Also, this serves as an alternate solution for the aforementioned Enhancement.
Transaction Saved Search > Type: Payment > Total Amount is using the Base Currency of the Parent Subsidiary > To be able to see the Amount in Foreign Currency
Payment Saved Search > Total Amount using the Base Currency of the Parent Subsidiary > To be able to see the Amount in Foreign Currency
Why is the amount of Balance and Balance (Foreign Currency) column on Vendor Saved Search different from the amount in the Balance fields on the Vendor Record
If theSubsidiaryselected under theHome>Set Preferences>Restrict View tab>Subsidiaryfieldis the same as thePrimary Subsidiaryselected on theVendor record, the amount showing up in theBalance (Base)field on theVendor Recordis the same as theBalancecolumnon theVendor Saved Search,the amount showing up in theBalancefieldon theVendor Recordis the same as theBalance(Foreign Currency)columnon theVendor Saved Search.
Create a Transaction Search with Foreign Currency Balance and Base Currency Balance
Users can create a transaction search that shows the Base Currency of and Foreign Currency amounts.
Amount showing under Amount (Foreign Currency) column is not equal with multiplying Amount with Exchange Rate
When doing bank reconciliation of bank accounts, accounts with Amountshowing 0.00 have values showing on the Amount (Foreign Currency) column greater than 0.00.
Display Items with Negative Stock (Quantity On Hand) and Send Monthly Email Alert
The user needs to set up a report/search that gets emailed once per month which displays all of the stock negatives at that time.
Show User Who Logged in Using at Least 2 Different IP Addresses in a Day Via Login Audit Trail
Scenario
Solution
- Navigate toLists>Search>Saved Searches>New
- New Saved Search:SelectLogin Audit Trail
- Search Title:EnterTitle
- Criteria:ClickSummary
- Summary Type:SelectCount
- Field:SelectIP Address
- IP Address:SelectGreater Than
- Value:Enter1
- ClickSet
- ClickAdd
- ClickStandard
- Filter:SelectDate
- Date:Selectwithin Today
- ClickSet
- ClickResults
- Field:SelectFormula (Date)
- Formula:EnterTO_DATE({date})
- ClickAdd
- ClickSave & Run