Articles written by John David Dy
Articles written by
John David Dy
Consolidated Reporting in OneWorld
With NetSuite OneWorld, you can view data consolidated from multiple subsidiaries on many reports.
Restrict Your Subsidiary View
If you are using the Advanced Employee Permissions feature, restrictions set on the Role page are applicable only to the Employees and Employee Administration permissions. The Employee Public and Employee Confidential permissions ignore the restrictions set on this page.
Currency for Multiple Subsidiary Search Results
When you view search results for multiple subsidiaries, results are converted (consolidated exchange rates) into the currency of the lowest common parent (LCP).
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
Special Characters Are Not Displayed Correctly in the CSV Error File for Failed Bank Data Import
You are using a non-English language as your preferred language in the NetSuite user interface, or your bank statement file contains special characters. Example, .
Bank Statement CSV File Upload Failure Reason: Unexpected Error
A Microsoft Excel CLEAN function can help to efficiently check and remove all the nonprintable characters from string in the Memo column.
Select a Default Folder in File Cabinet for Uploaded Expense Images
Select a Default Folder in File Cabinet for Uploaded Expense Image.