Clarisa De Torres-Oracle Blue Diamond

Hi @zkhan_45306 Unfortunately, I was not able to find any documentation for a workaround on this other than to use multi-books and set a secondary book where a different Exchange Rate can be set which also may not be feasible on your end. To our other members, feel free to share your ideas and suggestions on this. We…

Hi @User_93QUT The retained earnings account and net income account together reflect the cumulative retained earnings balance. Net income from the previous fiscal year appears in the retained earnings account. Net income from the current fiscal year-to-date is shown in the net income account. NetSuite does not post the…

Hi @Usernametaken, were you able to try Sakshi and Angela's suggestions above? :)

Hi @Vishnu M, I'm not sure how you checked yours but here's a detailed step on my end: Consolidated Subsidiary = Parent Company (Consolidated) - USD Child Subsidiary = Canada - New Brunswick - CAD Account = RAR Income Account using Average General Rate Type: There are 2 sample transactions under RAR Income account for…

Hi @User_S6FVQ, For further investigation, please answer the following questions: Are you both using the Admin role? Is the same form used to create the Sales Order? Can you share sample screenshots showing one order working correctly and the other producing an error? Kindly cover any confidential information. Looking…

Hi @Vishnu M, per checking, Consolidated reports use the Consolidated Exchange Rates table to translate child subsidiaries' amounts to roll up into consolidated parent subsidiary amounts. You can view this via Lists > Accounting > Consolidated Exchange Rates. The page includes consolidated exchange rates between the base…

Hi @Elina Kourouzidou I tried to replicate your concern but wasn't able to reproduce it on our test account. Please see details below: Sample SO with Billing Schedule = Quarterly: Then created the same Custom Billing Schedule as yours: Edited the SO above and changed the Billing Schedule: As you can see it updated…

Hi @User_PW1QK, per checking, this is also under the system limitation logged above #281398. The alternate solution is to Use SQL CASE WHEN function to isolate one date/period per column. Please know that we do not assist on creating Saved Searches from scratch. You may try reaching out to your Account Manager should this…

Your valuable insights would be greatly appreciated to assist our member, @KaylaM We truly value your expertise and perspective. If you know someone who is just starting their NetSuite journey, please guide them to explore our "New to NetSuite" category. It’s a great resource for helpful information and support to get them…

Hi @Yasmine BELAOUCH, to verify, may we know if the user ran the Revaluation of Open Currency Balances process? Per SAID 14972, You must run a revaluation process to calculate the unrealized gain or loss due to exchange rate fluctuation. You can generate revaluations as part of the Period Close Checklist or at any time,…

Hi @User_KAGURA, you're right, this is a standard behavior of the system. This is documented in SuiteAnswers ID: 79635 Currency Exchange Rates List Page, you can enter exchange rates with up to 15 digits before the decimal point, or up to 8 digits after the decimal point. As a support, we are limited to how the system…

Hi @User_64PY4 thank you for providing the screenshot. It seems that the rate provider is Xignite and this means this is being sourced from them. We suggest for you to reach out to Xignite if your objective would be to further verify the rates on their end as it is already outside our scope. Apologies for the limited…

Hi @AMay11, thank you for sharing the solution and update! Yes, you will need to make a copy of the layout since standard layouts can't be overridden. I'm glad it's now working on your end. Have a nice day!

Hi @Kedalene thank you for sharing the solution! Let us know if you need further assistance on this. Have a good day!

Hi @ZShah, may I know what are the specific entries you're trying to input in the journal? Can you share it here (please cover confidential info ex. subsidiary, names etc) so we could check? Are you trying to reverse the impact of SO and PO on the Journal Entry? In terms of GL Impact, SO and PO are nonposting as what…

Hello @Kedalene, can you further explain what do you mean by prepayment adjustment? Will you be adjusting the original amount on the transaction with associated amortization? Then you would like the remaining amount in the schedule to be updated/revised based on the new amount? You can also share screenshot of the…

Hello @User_ZEOUG, were you able to check Patrick's comment above? :)

このスレッドに関して確認をさせていただきます。 ご質問に関してさらにサポートが必要な場合は、お知らせ頂ければ幸いです。 また、コメントが適切な回答の場合は、「これは問題解決のお役に立ちましたか？」に「はい」のクリックをお願い申し上げます。 そうすることで、同じ質問がある方々が解決方法を検索する事が可能となります。 また、協力して頂いた事によって、ポイントを獲得し、回答者バッジのロックを解除することができます。

Hi @Elshami, per checking, the ability to run a Financial Report in currencies other than its Base Currency is not yet available. This is logged under Enhancement # 158516 Reports> Financial: Provide the ability to run and print Financial Reports in currencies other than Base Currency. For consolidated reports, the…

Hi @User_QQYFN, per checking and testing, this is a standard behavior of the system. The Quarterly Current Rate is calculated when the Consolidated Exchange Rates of periods that compose a quarter (ex: Jan-March) has been calculated/updated. Per further checking, it seems that there's no specific SuiteAnswer article /…

Hi @ZShah, to clarify, did you delete all the transactions? The invoice, fulfillment, and the intercompany SO and PO? If yes, then you will need to recreate them again if you wish to reverse the GL Impact. Can you provide a screenshot on which journal transaction did you use wherein you're unable to select other books?…

Hi @User_ZI55R, I understand that you wanted to change the revenue account on your Revenue Plan. As per checking, currently, we cannot anymore change the revenue account of revenue plan with revenue recognition journal entries. This is currently logged as an Enhancement #82016 Ability to update the Revenue Recognition /…

Hi @Elina Kourouzidou, were you able to try MJ's suggestion above? You can also try removing and reselecting the Billing Schedule in the Sales Order if it would work: 1.Edit sales order 2. Remove billing schedule 3. Click Save 4. Edit Sales Order again 5. Add back the billing schedule Let us know if it would update the…

Hi @User_64PY4 can you provide a screenshot which method was used for this so we could check? Currency exchange rates with blank rate provider and N/A Method is not supported by the rate provider. For instances like this, it seems that the Use Triangulation Calculation by NetSuite preference has been enabled under Setup >…

Hi @Panadick were you able to check the comment above? We would also appreciate it if you can provide the case number once filed. Thank you!

I'm glad it's working now, @User_Aysha! Thank you as well for sharing additional insights! This can be helpful to other members😊

Hi, Everyone! @User_J20V3 needs our help. Don't hesitate to contribute your knowledge and best practices. -- 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…

Thank you for providing your insights, @MJ Fernandez-Oracle ! 😊 Hello @Elina Kourouzidou, were you able to check the comment above? :)

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

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