With the Multiple Calendars feature enabled, you can have more than one fiscal calendar to roll up accounting periods for reporting purposes. The dates for the report range selected are based on the accounting period rollup in the context of the fiscal calendar assigned to the subsidiary. For consolidated reporting, when you run reports for… Continue reading Reports for Subsidiaries with Multiple Calendars
Tag: report
Add Tax code and The Amount (Tax) field in General ledger Report
The Amount (Tax) field is not available on General ledger report. However there are two alternate options for this. Create a formula column that calculates GST (tax amount) Customize the General Ledger Report. Under Edit Columns tab, add the following fields: Transactions > Sales Tax Item > Name. Transactions > Sales Tax Item > Tax… Continue reading Add Tax code and The Amount (Tax) field in General ledger Report
Comparative Trial Balance Report
Client requested for a comparative trail balance report similar to comparative balance sheet report Solution: Navigate to Reports > Financial > Trial Balance > Customize Select the Debit /Credit column Click Remove Column Add Fields: Expand Trial Balance Click Amount Alternate Period Range Type: Select Relative to Report Date Cumulative Value: Enter Checkmark Alternate Period Range: Select the Last Fiscal Year Add Fields: Expand Trial Balance Select another Amount field Alternate Period Range Type: SelectRelative to Report Date Cumulative Value: Enter Checkmark Alternate… Continue reading Comparative Trial Balance Report
Financial Report results show different results when filtered by period and date.
A financial report shows different balances for a chart of accounts when run by two different users. One user has the report filtered by period and the other user by date. So when the same financial report is opened by both users, the results are different. A potential issue will be when a transaction date… Continue reading Financial Report results show different results when filtered by period and date.
Generate a report that will display all transactions of a specific account or multiple accounts for a specific period
1. Navigate to Reports > Financial > Transaction Detail > Customize2. In the Filters link, set Date Range3. Expand the Transaction folder to select Account and set it equal to a specific account4. Rename the Report5. Click Save
Trial Balance period-wise report
This article provides the details on how to prepare a trial balance report that can show the YTD balance per accounting period in individual columns in NetSuite.
Sorting Data on Reports
In NetSuite, all reports are automatically sorted by default, either based on a single column or multiple columns. However, users have the flexibility to modify or remove these default sorting settings and introduce new sorting options to customize their reports according to specific requirements. Important Note Regarding Financial Statements: For financial statements, it is recommended… Continue reading Sorting Data on Reports
Proposal – Display the Sales Order Data on Invoice/Sales Report
Display the Sales Order Data on Invoice/Sales Report
Custom Field is not shown in the Report
Custom Field is not shown in the Report
show or create a saved search to show the list of parent and child projects
show or create a saved search to show the list of parent and child projects