Clarisa De Torres-Oracle Blue Diamond

Hi @Tim Keegan, Welcome to NS Support Community and thank you for being with us today. 😊 Kindly allow us to review your concern and we'll provide updates in this thread. To our members, please feel free to share your thoughts as well.

Hi @ksage, Thank you for posting another thread here in the Community! I'm tagging my colleague @Micah Timbol-Oracle so she can share her insights 😊 To our members, please feel free to share your thoughts on the thread.

Hi @Katelyn M Martin, Thank you for being with us today and for posting your question here! Kindly allow us to review your concern and we'll provide updates in this thread. To other members who may have insights regarding this topic, feel free to add your comments by replying to this thread.

Hi @Benjamin Paul - USA, Good day! I would just like to follow up on the additional information requested. Thank you! 😊

Hi @Emzo Alama-Oracle, Upon checking, Trial Balance Report is being generated using an "As Of" date and not "From" and "To" dates. We noted that it is the standard behavior in NetSuite for the Trial Balance Report that the as of balances is pulled-off on the report. The request to have the ability to run the Trial Balance…

Hi @User_FL4CK, Per checking, as per design, system reflects the difference of exchange rate types assigned to accounts (assets, liabilities, equity and revenue/expense), which may result to the use of different rates, in the Cumulative Translation Adjustment (CTA) account. CTA is for the purpose of balancing the…

Hi @User_P1XGI, Upon checking, there is an existing defect filed for this Issue 707606. You may refer to the filed defect. To give you an update, our engineering team is actively working on the problem encountered on the US Boston Data Center. We will provide updates soonest we have one. You can also…

Hi @Benjamin Paul - USA, can you provide a screenshot of a sample journal record? Please cover any confidential information. On that specific JE displaying -no entity- under entity (line) column on Report, can you confirm if it has customer/vendor under the name line item column like this: If none, may we know from which…

Hi @manuelsaomartinho, I tried to replicate this on our test account by doing the steps below: Periods: Dec 2021 (Dec 1-31,2021) Adjust 2021 (Dec 31,2021) 1. Run Tasks on Dec 2021 period checklist. 2. Check BS as of Dec 2021: ----183 Interco A/R = 0 3. Check BS as of Adjust 2021: ----183 Interco A/R = 0 4. Then tried…

Hi @User_M4JOC, Glad to have you with us today! Thanks for posting your concern here. Tagging our guru who has expertise on this: @Micah Timbol-Oracle, any ideas? To other users, feel free join in the discussion as well.

Hi @Deano_M, Were you able to check this? 😊 Let us know if you need further assistance. Thank you! 😊

Hi @manuelsaomartinho, Were you able to check this? 😊 Let us know if you need further assistance. Thank you! 😊

Hi @User_Q1DPO, Were you able to check this? 😊 Let us know if you need further assistance. Thank you! 😊

Hi @User_FL4CK, As per SuiteAnswer 7641 | Cumulative Translation Adjustment (CTA) Overview: Cumulative Translation Adjustment (CTA) is a special type of account that is required for consolidated balance sheets in NetSuite OneWorld accounts with multi-currency enabled. The account is necessary because consolidated exchange…

Thank you for providing your insight, @Excelsis Sia! 😊 Hi @Benjamin Paul - USA, have you tried Excelsis' suggestion above? Kindly let us know if it addressed your concern. Thank you! 😊

Hi @Kedalene, I did further investigation on our test accounts, however, we noted that this is currently a limitation of the system and has existing related enhancements logged under the following: #107839 Reports > System Notes fields are not available under Filters and under Edit Columns #146210 Report / Search…

Thanks for the update, @Rick Cobb_2! I'm glad it's now resolved. Have a nice day!

Hi @Rick Cobb_2, To further investigate, I would like to clarify the following: You mentioned "project income statement", does this mean this is a customized IS from the standard one? If yes, can you provide a screenshot of the report builder (filter tab) on the affected report? I would like to check how was the report…

Hi @Deano_M, Users can only post Journal Entries to an adjustment period. Adjustment periods are not available in the Posting Period dropdown for non-Journal Entry transactions. To answer your first 2 questions regarding its relation to revaluation and IC elimination, upon checking internally, it is noted that it is not…

Hi @User_FL4CK, per my understanding you wanted to know if there's a standard report/search in Netsuite which can pull future invoices that will need to be created and its expected creation date based on the billing schedule. Per checking on my test account and resources, unfortunately, the ability to create a Saved…

Hi @User_Q1DPO, yes that's right since amortization feature is only available on the following transaction types: vendor bill, vendor credit, and journal entry. Upon checking, the ability to amortize and defer revenue via invoice is not yet possible in the system. This is where the Advanced Revenue Management bundle comes…

Hi @manuelsaomartinho, Yes that's right. Based on standard behavior, reports would normally default to include the adjustment period if the date of the adjustment period falls within the same date covered by Dec period. Running them separately is still an enhancement request under #61915 Reports > Financials - add an…

Hi @Nickey, Per my understanding, you wanted to limit the saved search result by 25s, upon checking, this is currently a system limitation and is logged under Enhancement #263686 Saved Searches > To have a separate preference available on the saved search that will allow users to specify number of rows that will show per…

Hi @User_Q1DPO, Another thing I could think of is using the amortization feature if you want to defer the revenue. You may create a journal entry on Feb like the sample below and on the deferred revenue line account, input start and end date March 1-31 to indicate when the revenue will be recognized. This is the GL Impact…

Hi @CDuf, Glad to have you with us today! Thank you for creating this thread. Kindly allow our gurus some time to check this one for you and we will get back to you with our findings. To other members who may have insights regarding this topic, feel free to add your comments by replying to this thread.

Hi @Nickey, Thank you for posting a new thread! Tagging our gurus who have expertise on this: @Kristoffer Viray-Oracle / @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Richard James Uri-Oracle / @Nicole Mendoza-Oracle , any insights? To our members, please feel free to share your thoughts as well.

Hi @User_Q1DPO, I would like to clarify if you wanted the revenue to be deferred and recognize it the next month (march) - the same time as cost? Upon checking, this can be done via Advanced Revenue Management module (SuiteAnswers ID: 49167). With this, revenue for all items is deferred until revenue recognition journal…

Hi @User_USRCP, Thank you for posting your concern here in the Community! Tagging our gurus who have expertise on this: @Kristoffer Viray-Oracle / @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle , any insights? To our members, please feel free to share your thoughts as well.

Hi @Jack Goodwin, Upon checking, the ability to add timestamp on Financial reports to reflect the date and time the report was generated is not yet possible in the current version of NetSuite. Also, this is logged as Enhancement #332570 All Reports > Ability to display on the report result/printout the Datestamp/Timestamp…

Hi @User_FL4CK, were you able to check the comment above? Kindly let us know should you need further assistance on this. Thank you!