-
Name in same column on Income Statement Report for Invoices and JEs
Hi All, Does anyone know of any way to get the Name from both Invoices and Journal Entries to appear in the same column on the Income Statement? Right now the stock Name column is populated for Invoices but blank for JEs. We then have to add the Entity (line) field to get the Name from Journal Entries. We then have to…
-
Reporting in USD
The subsidiary operates with INR as its base currency. We require consolidated financial reports to be generated in both INR and USD. Additionally, we would like the flexibility to input a custom conversion rate to USD, which will be used to translate all INR-based amounts into USD within the reports. This US amount is…
-
NSC | Customize P&L Report > Show Class & Subclass on Columns
Scenario The user requires assistance with customizing a P&L report to display classes and subclasses across the top. They want to know the process of customizing the report and whether it is feasible. Solution This can be achieved by following the step below: On the report footer, user can select Class (Hierarchy) on the…
-
Custom Report > Edit Layout > Account is Not Visible in Report
Scenario: Totals in the Custom Report are correct, but an account is not visible in the report Criteria: This is applicable for account sections that are configured to have “Header Label > Display Row = F” for formatting purposes. Solution: Go to Report > Customize > Edit Layout Click the Account Section (i.e., “Other…
-
Custom Role cannot access scriptlet report
I can access the custom script report on administrator role but cannot access it on a custom role. At first it gave a clear permission error but after adding the permission it had another error. Is this permission related or something else?
-
How to add a blank column in a custom Financial Report?
Hi everyone, I know we have an option to add a blank row in a customized Financil Report. However, is there a way to add a blank column as well? Thank you!
-
How to customize Trial Balance Report and Add Memo field?
Hello, Im trying to add the memo field to a Custom Trial Balance Report. In the below question is see it has been added at comment Jan 23, 2020 4:32AM. https://community.oracle.com/netsuite/english/discussion/comment/15539984#Comment_15539984 Im trying to do the same thing but cant find the memo field name. Also, we use…
-
NSC | Financial Report: GL Account with Zero Balance is Not Showing
Scenario User is having issues seeing a specific GL account on the balance sheet and income statement, even when user selected the "Show zero activity" option under report customization. In the trial balance, these GL accounts are listed as "active." However, for some reason, they do not appear in the reports. Solution The…
-
How to correct Date (Week number) data of the Schedule Report?
Per the client. I have customized and scheduled a report of Weekly Sales in NetSuite to generate in the 2 columns Current Year Last Week (column K) and Last Year Last Week (column L) in excel. The issue - when report is schedule, the report is not automatically generating the last week. Under the Customization - Filters -…
-
Customize a Report
Hello, Could someone assist with building a report. I would like to include email contacts to this report if possible. I can't find a field that would show this information. Thanks, Liz