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…

Thank you for the update and clarification, @Martha Hakes! May we know the case number filed for this?

Hi @User_H5C1K, i tried testing and reproducing your concern on our test account by doing the following: Add Analytics portlet Set Up Analytics and searched for a sample workbook: Sample data without filters: I filtered the Date for 2023 data only: Click Apply: As you can see, the data shown was filtered accordingly. Since…

Hi @Martha Hakes, yes if the customer has initially been set as non taxable then user needs to manually update the record since importing the tax table only updates the tax rates and not the tax selected on the customer records. Hope this clarified your concern :)

Hi @User_HHNEL, how's it going, were you able to check the comment above? :)

Hi @User_H5C1K, may we clarify if the data doesn't change once you apply the filter? or does it change once you refresh it? Per SAID 87383 Viewing Workbook Data in the Analytics Portlet - "Filters applied to the underlying workbook are available from the portlet. You can modify these filters or add new filters in the same…

Hi @User_HHNEL, would mass deleting the journal work? You may refer to SAID 33955 Mass Delete Journal Entries Through Inline Editing for reference. If not, you may consider making a manual adjustment instead on the affected accounts. Please make sure to test this first on Sandbox account - please note that the deletion…

Hi @Martha Hakes, how's it going? were you able to check the comment above? :)

Hi @User_YMWNR, were you able to check the comment above? :)