You're welcome, @netsuite_whuser! 😊

Hi @netsuite_whuser, As an alternate solution, we can create custom fields that will source the Sub Account field to expose the account number and name on the saved search. Detailed steps to create a custom field are as follows: 1. Using Administrator role, navigate to Customization > Lists, Records, & Fields > Other…

Hi @netsuite_whuser, i tried testing this on our test accounts and was able to replicate the behavior. We could not locate any fields that could display subsidiary hierarchy column. One of the alternate solutions I could think of is creating an account saved search instead then export it and use it for your csv import.…

Hi @Jack Goodwin, Glad to have you with us today! Thank you for creating this thread. Tagging our gurus who have expertise on this: @Katerina Winklerova-Oracle / @Elychelle Gulen-Oracle / @Dominica Sevilla-Oracle , any insights? To other users, feel free join in the discussion as well.

Hi @Benjamin Paul - USA, Per checking, the fields used per entity is different and the records have different transaction type as well. Per testing, this is currently a system limitation on both reports and saved searches. The following existing enhancements are logged for this concern: #141280 Reports> financial> general…

Hi @Eklon Eleuterio, upon checking these accounts are system generated accounts. As per SuiteAnswers Id: 64402, the activation and inactivation of system-generated accounts is handled by the NetSuite system. Also, some accounts are automatically generated when some features are enabled (e.g. Multiple Currency Feature,…

Hi @manuelsaomartinho, kindly let us know should you still need further assistance on this. thanks! 😊

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…