Articles tagged #RATE
Articles tagged
#RATE
Missing Price Field in Generic Resource Page
Scenario
Solution
- Enable the Per-Employee Billing Rates Feature by navigating toSetup>Company>Enable Features
- ClickEmployeestab
- Time & Expenses:
- check the Per-Employee Billing Rates box
- ClickSave
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.
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.
Creating an Expense Category
Expenses can be grouped into expense categories that are associated with specific expense accounts.
Tax Rate in Purchase or Sales Transaction (Non-US Nexus) Is Undefined
When creating a Sales or Purchase Transaction, Tax Code is undefined. Provided the following set up on the tax code:- Tax Code is Active
Discount Item With Negative Rate Displays Positive When Used as Promotion in Transaction Records
Discount Itemrecordsthat indicatesNegative Rate(E.g.-20.0%) in Promotion records will indeed displayPositive(E.g.20.0%)in transaction records (E.g. Sales Order) by design.
Non-Inventory Item: Generate Accruals
Non Inventory Items > Generate Accruals = T > Item Receipt has no GL ImpactItem settings at the time the Purchase Order line iscreatedis the basis of whether accruals will be generated or not.Item receipt shows no GL Impact even if Generate Accruals is set to True on the item record.Note:In order for the new setting to take effect, the Purchase Order item line should be created from scratch. As such, making a copy of a Purchase Order that was created before Generate Accruals was enabled will still inherit the old settings. The old settings will also remain if you make a copy of an old Purchase Order, use Copy Previous button to make the new line, and save the Purchase Order.
Sales Order Saved Search That Do Not Have Item Fulfillment Records Generated Yet
Sales Order Saved Search that does not contain Item Fulfillment related records.
Unable to set Account for Corporate Card Expenses When Editing Expense Reports
A user is trying to select an account in the Account for Corporate Card Expenses dropdown field in an Expense Report, but when saving the record, the value under this field is missing.
Asset Split
Asset split enables a specified quantity to be separated from the original asset and creates new asset records. The Quantity field on the Maintenance subtab of the asset record tracks the number of individual elements that form the asset.
Enable the Currency Exchange Rate Types feature
Go toSetup > Company > Enable Features.
Currency Exchange Rate Types
The Currency Exchange Rate Types feature lets you store multiple currency exchange rates for a currency pair and date. Unless you enable this feature, you can have only one exchange rate for each currency pair and date combination. You cannot disable the Currency Exchange Rate Types feature after you enable it.
Rate Column on Sales Order Is Grayed Out
This article discusses on how to change the Rate on a Sales Order record.
Display Line Item Rate When Fulfilling Sales Orders
There are scenarios where users want to source the Item Unit Price (Rate) of an Item from their Sales Order form to the Item Fulfillment form. This can be achieved by creating a Transaction Line Field applied to the Item Fulfillment form.
Background Processing of Fixed Assets
To optimize application and database servers, mechanisms have been implemented to govern the usage of SuiteScript. SuiteScript thresholds are based on the volume of activity that a company's users can manually generate, as well as a provision for automated functions.
Generating Asset Reports
The fixed asset reporting tool uses the Advanced PDF format. This enables you to print the report or to view and download it in CSV (for Depreciation Schedule Report), PDF, or XML format. To generate the fixed asset reports, you must enable theAdvanced PDF/HTML Templatesfeature from Setup > Company > Enable Features > SuiteCloud.
Consolidated Exchange Rate Types for Transaction Searches
You can select the type of consolidated exchange rate to apply to results for each transaction search. The consolidated exchange rate type you select applies to amount fields in base currency, such as Amount, Amount (Credit), and Amount (Debit).
Consolidated Exchange Rate Automatic Calculation Example
The following is an example of the calculation that NetSuite uses to determine the consolidated exchange rates for subsidiaries with the following hierarchy:
Consolidated Exchange Rate Types
The Consolidated Exchange Rates table includes three consolidated exchange rate types. Current, Average, and Historical. Each accounting period, accounting book (when Multi-Book Accounting is enabled) and subsidiary pair has its own set of three consolidated exchange rate types. The value of a subsidiary account multiplied by its consolidated exchange rate provides the account value in consolidated financial statements.
Compute for the Average Consolidated Exchange Rate
How tocomputefor theAverageConsolidatedExchange Rate