Using the Country-Specific Reports SuiteApp

To create new reports and display already existing ones, go to Reports > Financial > Country-Specific Reports. This simple dashboard contains the Report dropdown list enabling you to perform the following basic actions:

To display an existing report:

  1. Select a report that you would like to view from the Reports dropdown list.

  2. Click the Show Report button.

  3. Selected report is displayed. In case there are any issues with this report, corresponding error messages will be displayed. Also, if this report contains any undefined variables, you will see them highlighted in red.

To create a new report:

  1. Go to Customization > List, Records, & Fields > Record Types, locate the CSR - Report row, and in this row, click the New record link. If you click the List link in the same row, you can view a list of already existing reports (and edit them).

    Alternatively, go to Reports > Financial > Country-Specific Reports and select the New item from the Reports dropdown list (or click the plus button next to this list).

  2. A new dialog is displayed. Fill in all required data:

    • Name - Enter a name for your report.

    • Inactive box - If you check this box, your report will be inactive (it will not appear on your list of reports).

    • Template File - Select a template file for your new report. Every report is based on an HTML/XML report template stored in NetSuite File Cabinet (Documents > Files > File Cabinet). You can create and edit them within NetSuite application itself, or upload them from your own computer. To load a new template file, select the New item, and fill in required fields in the File popup window.

    • 2nd Column Definition - Use this field to define a second column of your report (or leave it blank if you want your report to contain one column only). The second column displays the data from the past. This version of the SuiteApp only supports showing data from one year ago (by selecting Minus One Year from this dropdown list). Based on selected period filters, one year will be subtracted and corresponding data will be displayed in the second column.

    • NetAmount Calculation Method - When creating a math variable using the Country-Specific Reports SuiteApp, you must select its type (using the Credit/Debit/Net dropdown list). For the Net amount type, multiple methods for its calculation exist. Most reports use a method set in General Preferences (go to Setup > Company > Preferences > General Preferences, click the Custom Preferences subtab, and view an option selected in the Country-Specific Reports section). If you want to use the default Net Amount calculation method for this report, ignore this field. However, if you want this report to use a different method, select it from this dropdown list. We recommend overriding the default method only if you have a good reason to do so.

    • Accounting Context - If at least one accounting context exists in your account, you can select it from this list to apply it to this financial report. If you leave this field empty, no accounting context will be used for this report. This setting will be always applied to this report even if you have a different accounting context set for your account (in Home > Set Preferences). To create a new accounting context, go to Setup > Company > Preferences > General Preferences and click the Accounting Contexts subtab (only available in OneWorld accounts). To learn more about accounting contexts in NetSuite, see Accounting Contexts.

      Note:

      You can change the accounting context even for original NetSuite reports delivered by the Localization SuiteApps (which are otherwise locked and not editable).

  3. If you want your report to be exportable to a certain format, click the Export subtab and fill in the data. If you don’t want to create any exports, you can skip this step (and add exports to this report later, if necessary). To learn more about handling exports in the Country-Specific Reports SuiteApp, see Creating exports.

    Important:

    For the Export subtab to work properly, make sure you are accessing it via Customization > Lists, Records, & Fields > Record Types (see above).

  4. Click the Save button.

  5. Your report has been created. You can start adding variables and filters to it. Also, it appears on the Reports dropdown list, so you can display it using the Show Report button.

Note:

Whenever you create a new report, the unique link is assigned to it. This link enables to you to display the report directly, without going to the Country-Specific Reports dashboard. To access the link, you must either view or edit your report.

Go to Customization > List, Records, & Fields > Record Types, locate the CSR-Report record type, and click the List link. Then, find the corresponding report record and click the link next to it (either View or Edit). Alternatively, go to Reports > Financial > Country-Specific Reports, select the report from the Reports dropdown list, and click the Open button next to this list.

The link to your report is displayed in the Report Link section in the upper part of the screen. It is predefined and cannot be edited. You can either click it to view the report directly or use the Copy this link to clipboard option to store it for later use. If you decide to paste the link to the address bar of your browser, make sure to insert it after the NetSuite account specific part. For example, if your NetSuite account number is 1234567, remove everything behind https://1234567.app.netsuite.com and paste the link there.

Administrators and users with the Creating Center Links permission can use every copied report URL to create a center link. For more information, see Creating Center Links.

To view a list of variables assigned to a report:

  1. Select a report that you would like to view from the Reports dropdown list.

  2. Click the Open button next to the dropdown list.

  3. A new CSR-Report page opens.

  4. On this page, click the Variables subtab.

  5. The CSR-Variable subtab contains a list of variables assigned to this report. If the report is not locked (which is the case with original NetSuite reports delivered by the Localization SuiteApps), you can also use this list to add or remove variables to this report (or to edit the existing ones).

To delete a report, a filter, or a variable:

  1. To delete a record created by the Country-Specific Reports SuiteApp, go to Customization > List, Records, & Fields > Record Types, locate the record type (CSR-Report, CSR-Filter Block, or CSR-Variable), and click the List link. In case of variables, you can also display all variables assigned to a certain report (see the procedure above).

  2. Find a record that you would like to delete and click the Edit link next to it.

  3. On the record page, under Actions, click Delete.

  4. At the prompt to confirm the action, click OK.

Note that you can only delete unlocked records (for example, reports delivered by Localization SuiteApps are always locked). Also, you cannot delete a record that has dependent records (such as variables, filters, or exports in case of reports or values in case of variables). These dependant records must be deleted first.

Related Topics

Country-Specific Reports Overview
Enabling Required Features the Country-Specific Reports SuiteApp
Installing the Country-Specific Reports SuiteApp
Creating a Template for the Country-Specific Reports SuiteApp
Adding NetSuite Data to the Template File
Adding and Editing Report Elements
Working with Reports
Roles and Permissions

General Notices