-
No Data Available showing in the Report Detail page
So we encounter an issue where from a financial summary report (balance sheet), we will view the detail report. on some lines, when we view the detail report, the data is showing up. On some lines, the data don't show up and instead this message is displayed: No Data Available There is no data available for the date/period…
-
Expense Category for Items sitting in Prepaids
Wondering if anyone knows how to run a report that contains the details of the expense account an item sitting in prepaids will be amortized to. When you run a Balance Sheet detail report there are options for "Expense Account Name" but it unfortunately does not contain the name of the expense account that was originally…
-
Different amount on Balance Sheet and Reconciliation Summary
Hi team, I have an issue regarding the amount in the balance sheet and the reconciliation detail. Why is there a difference between these reports for this bank account? And how to solve it? Your ideas would be helpful, thank you.
-
NSC | Custom BS > Is It Possible to Show Revalue Checkbox on Account Record
Scenario User wants to customize the balance sheet report and to add a column that indicated if the account is revalued or not. Solution The "Revalue Open Balances for Foreign Currencies" checkbox is unavailable in the Balance Sheet Report. However, users can try to build a custom Balance Sheet in Workbook/Dataset and add…
-
NetSuite Admin Tip | How to Display the Line Memo Field in a Balance Sheet Report
Finance teams often need to review the details behind specific Balance Sheet entries such as transaction line memos to understand the context of each line item, especially in Journal Entries. By adding the transaction line memo to the Balance Sheet report, administrators can ensure these important details are displayed…
-
Updated Asset Account on inventory item doesn't get updated with value.
Hi, We updated the asset account on some of our items with a newly created account. For example the one that was there before was a 1200 Inventory Account and we created a sub-account 1210 under 1200 and assigned it to some of our inventory items. What we expected was to get the values of those inventory moved to the new…
-
Customized balance sheet showing opposite amount on customized financial sections
Hi team, I have been working on a Customized Balance Sheet and I had to add financial sections to it. I noticed that the report is showing exactly the opposite amount for these new financial sections on the balance sheet, for example: This JE is debiting account 16410 for USD 13,589.04, but I have this JE being displayed…
-
Trial Balance and other reports not showing proper account balance for certain roles
Hello, I am experiencing an issue where my Balance Sheet is showing improper balances for multiple accounts and subsidiaries. I have confirmed that this is an issue with my user role as other roles are not experiencing the same issues. What is the solution to this problem?
-
Financial Report - Cash Equivalents is overdrawn, auto appear as a liability
I have no doubt this is an enhancement - the idea of a conditional formula within the row format. If positive - it is an asset; If negative, aka overdrawn, it is a liability. Can someone help me to find the enhancement!
-
Amount (fx currency) showing zero when Amount is not zero, balance sheet
Hello, We have an issue where the currency revaluation is not as expected. We have some transactions in foreign currency and then we used a JE (in USD) to move the impact from one account to another as there was some items set up with the wrong account. In retrospect, we realize we should have used JEs in the currency of…