Clarisa De Torres-Oracle NSC Guru

thank you for providing your insights, @Wee Ming! 😊 Hey @User_MFH4I, were you able to check the comments above? :)

Hi @Fabss, Per checking, the ability to delete a transaction on a closed period without re-opening the period is currently a system limitation logged under Enhancement #35188 Accounting Period> User would like to ability for the Admin to be able to create new and edit transactions for Periods that are closed. Once the…

Hi @Kedalene, As per explanation in the SuiteAnswers article: Cumulative Translation Adjustment-Elimination (CTA-E), Answer Id: 64445, NetSuite adds CTA-E to your Chart of Accounts when you enable the Automated Intercompany Management feature. Cumulative Translation Adjustment-Elimination (CTA-E) is a general ledger equity…

Hi @Rick Cobb_2, I noticed that the screenshot on the item record is "Expense Account". The Expense Account on the Item record is used for non-Intercompany transactions. The Expense Account to be used for Intercompany Transactions, is the account selected under Intercompany Expense Account field on the item record. When…

Hello, everyone! We ask you to help our member @User_7NK3Q with your valuable knowledge and support. Your input is highly valued. Thank you for your assistance! In the meantime, in case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is…

Hello, everyone! We ask you to help our member @Gab JS with your valuable knowledge and support. Your input is highly valued. Thank you for your assistance! In the meantime, in case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is…

Hello, everyone! We ask you to help our member @User_JPTT1 with your valuable knowledge and support. Your input is highly valued. Thank you for your assistance! In the meantime, in case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is…

Hi @Rick Cobb_2, may we know if the intercompany expense created has been associated with all subsidiaries? :)

Hi @User_4R80Z, were you able to check the comment above? Kindly let us know should you need further assistance. Thank you! :)

Hi @User_MFH4I, I understand that you would want to display who created and approved the transactions on GL Report. Upon checking, this is currently a system limitation logged under Enhancement #146210 Report / Search Customization: Please add Set by or Created by fields. An alternate solution provided is what @Tigran…

Hi @Elizabeth Vance, I investigated this on our test environment and unable to reproduce the unexpected error when another user drills down on the custom detailed report and tries to apply a filter. This seems to need further checking on your internal environment. We have no ability here in the Community to check on the…

You're welcome, @User_H5C1K! We would also appreciate it if you can provide the case number once filed. Thank you! 😊

Thank you for your insights, @Wee Ming! 😊 Hi @User_P6PVX! That is right. This preference can be changed anytime by the user as preferred. Kindly let us know should you need further assistance regarding this. Have a nice day! 😊

Hi @User_P6PVX, we noticed you created a separate thread for this with similar concern: Kindly let us know should you need further assistance on this. Thank you! :)

Hi @User_H5C1K, I was able to replicate your concern on my end wherein I added a date filter from the portlet but the data didn't change even though the filter was updated. Here's the sample portlet with only the 2023 date filter applied: Updated the date filter to include 2022: We noted that the chart data didn't change.…

Hello, everyone! We ask you to help our member @User_VZN29 with your valuable knowledge and support. Your input is highly valued. Thank you for your assistance! In the meantime, in case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is…

Hello, everyone! We ask you to help our member @Yumiko Fourbs with your valuable knowledge and support. Your input is highly valued. Thank you for your assistance! In the meantime, in case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is…

Hi @User_H5C1K, Thank you for the added information. Here's the detail of our testing: Sample Chart Workbook without filters: This is how it looks like on the portlet: --Noted they're the same: Added date year filter on the workbook: This is how it looks like now after Refresh: Save the workbook then Refresh the portlet:…

Hi @User_4R80Z, thank you for your response! I tested this on our test environment by doing the following: Created open bill in prior period (2021): Run Task: Revalue Open Foreign Currency Balances (2021) --It generated an Unrealized Currency Revaluation which used the system generated Unrealized Gain/Loss: Then I tried…

Hi @Elizabeth Vance, were you able to check the comments above? Kindly let us know should you need further assistance. Thank you! :)

Hi @ALTAF BHOON, Were you able to check this? 😊 Let us know if the information provided in my previous comment was helpful. Thank you! 😊

Hi @Varonis inc., Were you able to check the comment above? 😊 Let us know if you need assistance with case filing. We would also appreciate if you can provide the case number once filed. Thank you! :)

Hi @User_Q1DPO, Were you able to check this? 😊 Let us know if the information provided in my previous comment was helpful. Thank you! 😊

Hi @User_4R80Z, may we know if the type of unrealized gain or loss that was still posting to old account is a rounding gain or loss? The Foreign Currency Variance Mapping feature enables you to create foreign currency variance posting rules that determine the accounts into which foreign currency variances are posted. Upon…

Hi @Elizabeth Vance, were you able to check the comment above? Another way to troubleshoot is - can you try recreating the customized income statement report and detailed report from the standard reports then link them with each other and see if it's still reproducible even from newly created one? Hope to hear from you! :)

Hi @ALTAF BHOON, Per checking, the usual cause of the error is the incorrect account type of the Income Account set on the Item record. For example (sample scenario only): In a sample Invoice #XXX, item used is Test Item. If you will open the item record, the Income Account is set to XXX Other Selling And Admin Expense…

Hello, everyone! We ask you to help our member @KaylaM with your valuable knowledge and support. Your input is highly valued. Thank you for your assistance! In the meantime, in case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is…

Hi @Varonis inc., scripts can be found on the scripted record used. You mentioned that you have already undeployed all the scripts, but it is still reproducible. Since you still encounter the error despite having it undeployed, it is recommended to file a case to NetSuite Customer Support, as they have the tools to…

Thanks for the clarification, @User_H5C1K! Sure! Here's a sample chart I created from the workbook: I added it on my dashboard as Analytics Portlet: However, based on the screenshot above, I can't seem to click anywhere from the portlet where I could add filter on it? May we know where or which part do you select the…

Hi @User_Q1DPO, for your first scenario, by advance invoice - do you mean creating vendor bill with tax on your end? You can create a bill with the vendor for this scenario: 1. Navigate via Transactions > Financials > Enter Bills 2. Select the Vendor and Account you wanted to use: 3. Under the Expense line item - you can…