- Go to the Analytics menu.
- Create a new Dataset for Transaction by clicking on New Dataset button.
3. Select Transaction dataset and add the following criteria and columns:
- Criteria:
- Account Type: Income, Cost of Goods Sold, Expense, Other Income, Other Expense
- Posting is True
- Columns:
- Account Type(Transaction Line: Account: Type)
- Location(Transaction Line: Location)
- Class(Transaction Line: Class)
- Department(Transaction Line: Department)
- Subsidiary(Transaction Line: Subsidiary)
- Posting Period(Transaction: Posting Period)
- Account(Transaction Line: Account)
- Amount(Transaction Line: Amount)
4. Click Save with a Dataset name.
5. Then click on Apply to Workbook button.
6. Select Pivot option
7. Add the Type and Account to Rows, Subsidiary to Columns, Amount to Measures
8. Click save button
Limitations:
- Limited customization: While NetSuite’s workbook provides some flexibility in terms of formatting and data manipulation, there may be limits to the level of customization you can achieve. For example, you may not be able to easily create custom formulas or pivot tables to analyze your data in the way that you need.
- Data accuracy: When generating an Income Statement layout using a workbook, it is important to ensure that your data is accurate and up-to-date. If your data is incomplete or inaccurate, this can lead to errors in your Income Statement, which can have significant implications for your business.
The workbook displays the reverse signed amount when compared to the standard report. - Workbook displaying the reverse signed amount when compared to the standard report
Benefits:
Possible to show the different subsidiary columns based on the base currency in different columns.
