Clarisa De Torres-Oracle Blue Diamond

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

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

Hi @Kedalene thanks for the update. That would make sense then if they have different currencies. Can you verify which currencies of the subsidiaries you tried to check in your original screenshot? Once you have their currencies, those are the ones you need to look up on the Current Foreign Currency Exchange Rates Source…

Hi @Barb_CF , may we know if you selected the Accounting Period at the column field in the footer? You can try selecting accounting quarter instead. Here's how it looked like when I selected Q1 and Q2 on the alternate period range and selected accounting quarter: Hope this helps! :)

Hi @Divya Unnikrishnan I tried to check the accounting period dataset, however, it seems like it doesn't have any system notes or other field to identify when the tasks have been specifically locked which could help filter transactions that have been created after it. Hope this clarifies. Thank you!

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

Hi @User_7NK3Q, thank you for your response. Have you checked out this article that might be helpful regarding your concern: NSC | Saved Search Formula to Show Same Value in NS_CONCAT with DISTINCT Formula — NetSuite Community Let us know if this works. Thank you!

Greetings, everyone! We have a fellow member @User_SCYT4, who could use our assistance. Please don't hesitate to share your knowledge and best practices to help them out. Your input is highly valued and appreciated! In the meantime, you might be interested in participating in our Weekly Quiz. You only have until May 8,…

Hi @Divya Unnikrishnan, unfortunately, upon checking, it appears that what you're looking for is not achievable through a saved search. There's no system notes available for selection under the accounting period join fields in the saved search, and it is not possible to customize the accounting period page to incorporate a…

Hi @Divya Unnikrishnan, you can also try the criteria below: The accounting period was locked on May 02, 2025, at 1:04 pm so the formula filters those that have been created after that date and time during the May 2025 period. I hope this helps!

Hi @User_IJB6M, per checking yes, here's also what the Avalara support chat stated: You can also utilize this by: Go to https://www.avalara.com/us/en/about/support.html Click Access GSP Hope this clarifies!

Hi @KaylaM per checking in our test accounts it seems that the latest available for Germany is from 2023: Hope this clarifies. Thank you!

Hi @Divya Unnikrishnan per checking, you can try checking the date and time the period was locked through the accounting period system notes then put that as a criteria to filter transactions created date on or before that time. For example: Formula Numeric = CASE WHEN {datecreated} > TRUNC(SYSDATE) + 13/24 THEN 1 ELSE 0…

Hello @User_S6FVQ Good day and thank you for posting this new thread! Hello everyone! We kindly seek your support. Your active participation in aiding a fellow member is genuinely appreciated.

Hello, everyone! We invite you to join the conversation and share your valuable insights with us. -- 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 specifically designed to offer them information and guidance and help them make the…

Hi @User_IJB6M, per checking, yes, you need to create the nexus records and assign them to the transacting subsidiary to avoid issues like the one outlined on this article: * Related Avalara article: https://knowledge.avalara.com/bundle/prv1665637602647_prv1665637602647/page/nzc1666066878941.html * Note: For NetSuite…

Hi @Elina Kourouzidou, per checking it seems that there's no way to filter the dates on the transaction to the available open periods only. I found a related enhancement regarding this logged under #85884 When entering a transaction (e.g. bill), system should warn (or prevent) when he is entering a transaction with a date…

Hi @emcee_uk i tried to replicate this on our test account by creating sample invoices in Parent and Child UK subsidiaries then running the VAT Tax International report: Invoice for Parent Sub: Invoice for Child Sub: VAT Report for Parent Sub with Group = T: Drilled Down Results: VAT Report for UK Child Sub with Group = T:…

Hi @emcee_uk , may we know what nexus is the report for? Is the top parent subsidiary the one selected under the Subsidiary field?

Hello @emcee_uk, To determine whether a revenue element or arrangement has been merged, check the following fields: 'Created from Merged Arrangements': Checked when the revenue arrangement is the result of a merge. Individual revenue element records include a 'Last Merged from Arrangement' field with a link to the previous…

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

Hello @emcee_uk, Per checking, the exchangerate field in the revenue plan table may not be the same as the exchange rate on the linked revenue element if the revenue element has participated in a merge. The Exchange Rate used in Revenue Element is based on the Currency Exchange Rate as of its transaction date. The Plan…

Olá @GHBAdm, A sua preocupação é geral e falta de pormenor, tornando impossível responder com maior precisão. Abra um caso diretamente com a nossa equipa de suporte, identificando o tipo de Sped que pretende gerar (Exemplo: Sped EFD ICMS IPI v19 With Block K) e informe exatamente passos dados até o resultado encontrado no…

Olá @GHBAdm, Por verificação, atualmente, na Localização do Brasil, não geramos o perfil B. Só geramos o perfil A para EFD de Sped. Se tiver um suporte "básico" (SuiteAnswers ID 68828), utilize a página SuiteIdeas (SuiteAnswers ID 30288) para registar um pedido de Melhoramento). Ou, se tiver um suporte Premium, pode abrir…

Hi @User_4DLQ8, per checking the Balance Transactions by Segments page it seems that there's currently no way to restrict it to run only for specific transaction types. I tried searching for existing enhancements but found none. If you have premium support, we recommend you file a case so our Support Team could log an…

Hi @nag_m upon further checking, the ability to add multiple VAT numbers for subsidiary in Legacy Tax was previously logged as an enhancement under #294936. Engineers closed the Enhancement and noted that it's now available in SuiteTax. For more information, please check 64718 Assigning Tax Registrations to a Subsidiary in…

Hi @Kedalene, per checking the ability to automatically update the Date Range, From and To, based on the date set on the Filters page of the custom saved report is still a system limitation logged under Enhancement #145776 An alternate solution you can try is: 1. On the footer level of the Report > Click on the field next…

Hi @emcee_uk , a possible reason for the difference aside from those transactions with different date vs posting period is when the report is a consolidated one. Opening Balance of Current Period does not tie up with Ending Balance of Prior Period on a Consolidated Report due to Consolidated Exchange Rates fluctuation…

Thank you for providing insights, @Akhil_k_t ! Hi @TEN , per checking, yes this is currently a system limitation logged under Enhancement #145845 Exchange rates should not be rounded off to 2 decimal places when exposed on saved searches and reports. You can try the alternation solution mentioned by Akhil above. You can go…

Hi @Gert Van Damme per checking internally the Baseline or Estimate at Completion (EAC) on Budget is indeed part of Advanced Project Budget. However, since the SuiteAnswer is a help topic, Support cannot update the SuiteAnswer article. They recommended that you could submit feedback on the article itself or on related help…