Articles written by John David Dy
Articles written by
John David Dy
Custom Segment > Making a Value Inactive by Clicking Manage Values
In some cases, you may not have permission to edit segments, but you do have permission to edit values for a segment. In these cases, to make a value inactive, you must open a page designed specifically for managing the value. You get to this page by viewing the segment definition and clicking the button labeled Manage Values.
Custom Segment > Making a Value Inactive by Editing the Segment Definition
In some cases, you may have a set of permissions that includes the ability to edit the segment definition. In these cases, you can make a value inactive by directly editing the segments Values sublist. One advantage of this approach is that you can view all values as you modify the list.
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
Importing Fixed Asset Records
Go to Setup > Import/Export > Import CSV Records.
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
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.
Saved Search to Pull up Base Price and Other Price Levels for a Specific Currency
User has multiple currencies setup under theSales/Pricingtab of item records and would like to create a saved search to pull up theBase PriceandPrice Levelfor a specific currency.
Accept Customer Payment for Invoice in Different Currency
It is currently not possible to directlyaccept Payment in different currency from the Invoice (as well Bill) currency. This is because NetSuite is not capable of double conversion of Currency. We only have a single Exchange Rate field on a single transaction.This feature is requested underEnhancement112956.The alternate solutionis applicable when a Customer Payment (in USD) and an Invoice (in Euro) were already created and it consists of 4 steps.Step 1: Create Customer Payment for Invoice inEuro. This is the original unapplied Payment based on the Invoice currency.
Saved Search to Expose all Currencies Associated with a Vendor
When users enableMulti-CurrencyforVendor, theCurrencyfield on Saved Search will only point toPrimary Currencyselected on theVendor record.
Multi-Currency Transaction > Bill Payment > Save: An unexpected error has occurred. Please click here to notify support and provide your contact information
The error is due to absence of setup in your Variance Account Mapping. This can be accessed inSetup>Accounting>Foreign Currency Variance Posting Rules.
Saved Search To Show Price Level in a Currency other than the Base Currency When Multi-Currency Feature is Enabled
A user needs to show a Price Level in a Currency other than the base currency set on the account.