Query Designer is a Smart View tool that enables you to create and modify ad hoc queries on General Ledger balances cubes. You can use Query Designer to select the dimensions, members, and filters that you want to include in your query, and then retrieve the data in a grid format in Excel. You can also save, open, and refresh your queries as needed. Query Designer is the best tool for producing an income statement on a regular basis using Smart View, because it allows you to easily access and analyze the income and expense accounts, as well as the ledger, period, currency, and other dimensions that are relevant for your report. You can also customize the layout and format of your grid, and use Excel functions and features to enhance your report. References:
Overview of Smart View
Creating an Ad Hoc Analysis in Smart View

Intercompany System options are used to set up intercompany processing rules at the enterprise level, based on your specific business needs. They help you standardize and simplify transaction processing, minimize disputes, and reduce administrative costs. The three factors that you should consider while specifying Intercompany System options are:
Automatic or manual batch numbering and the minimum transaction amount: These options help you control the numbering and the size of intercompany transactions. You can choose to use system generated or manual batch numbering, and you can specify a minimum threshold amount for intercompany transactions to prevent immaterial transactions. To use the minimum transaction amount option, you must also select an Intercompany currency option.
Whether to enforce an enterprise-wide currency or allow intercompany transactions in local currencies: This option helps you manage the currency risk and the conversion rate fluctuations for intercompany transactions.
You can choose to standardize transaction processing by selecting an Intercompany currency, which means that all intercompany transactions created in the Intercompany module are entered in this currency.
Alternatively, you can choose to allow intercompany transactions in local currencies, which means that intercompany transactions can be entered in the ledger currency of the sender or the receiver.
Whether to allow receivers to reject intercompany transactions: This option helps you handle the approval and dispute resolution process for intercompany transactions. You can choose to allow receivers to reject intercompany transactions if they disagree with the sender's information, such as the amount, the account, or the date. If you enable this option, you must also specify the rejection reason and the notification details for the sender.
Intercompany System Options
Implementing Enterprise Structures and General Ledger
Implement General Ledger