Hi @hannahnsps, Thanks for reaching out to us in the NetSuite Support Community. Per our understanding, you wanted to edit the derived consolidated rates, however, you were correct that it's currently a system limitation logged under #374480 Lists > Accounting > Consolidated Exchange Rates > Inline Editing = T > To be able…

@User_HWW8S, thank you for your prompt response and patience during our investigation on this concern. 😊 Can you check it instead by navigating to Customization > Forms > Entry Forms, mark the Preferred box for Custom Customer Form then click Submit? Would also like to verify if you're on Admin role? Thank you! :)

@User_HWW8S, can you please check on Step 2: Import Options - if the custom form selected is "Custom Customer Form" - the one which you selected as preferred above. Thank you! 😊

thank you for the screenshot, @User_HWW8S! I would also like to verify if this form wherein the sales rep is set to normal, is the preferred form set for customer? :)

Hi @User_HWW8S, can you provide us a screenshot of the form on the UI with the sales rep field? Kindly cover confidential information. Were you also using a saved CSV Import mapping? Can you try importing from scratch as well instead of using the existing saved import? Thank you! 😊

Hi @Erez Storch, per checking, the link between a Purchase Order and a Vendor Bill is in the line items. If you remove all the items in the Bill and manually add them back, the link between the two transactions will be broken. Please note that it is not possible to link the existing Bill to another Purchase Order. The Bill…

Hi @User_HWW8S, Upon checking, if a user is an owner of a custom lists or custom record type, the user will automatically have full access to the custom record type or custom lists regardless if the role is not provisioned to access a custom list or a custom record type but will not be able to open the Record types that…

Hi @Alon2028-Oracle, Upon checking, the workaround stated in SuiteAnswers ID 33753 - Use Net Income From Cash Basis Income Statement in Balance Sheet is no longer applicable. With this, we'll have to revisit this documented alternate solution for Enhancement #20022: Be able to generate cash basis balance sheet - in case…

Hi @manuelsaomartinho, I'm not sure if I understand your concern well but per my understanding, the P&L GLs posted under Adjustment period did not eliminate/zeroed out when you ran the elimination in December? Then on Sandbox, when you edited the journals and changed the period from adjustment to December and re-ran the…

Hi @User_HWW8S, Can you check under Customization > Forms > Entry Forms, the preferred form used for Customer records? Then can you try creating customer record via User Interface and see if Sales Rep field is available? Usual reason why it's not available for mapping on CSV Import is that the Sales Rep field is set to…

Hi @AndreaK2, We performed several investigations on our test accounts but was unable to reproduce the behavior wherein the realized gain/loss record doesn't have a source transaction linked. For us to investigate further, your account must have an open case with NetSuite Customer Support as this may be a potential defect.…

Hi @OliverOO, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hi @Kitin Basilla, Glad to have you with us today! Thank you for creating this thread. Our guru/s will look into your concern and reply to this thread for any updates. To our other members, feel free to share your insights or suggestions by commenting on this thread.

Hi @Joe CW, Upon checking, user can only have the Canada transactions calculate with no/0 tax by doing the following: Navigate to Setup > Accounting > Set Up Taxes Click Canada tab Unmark the ENABLE TAX LOOKUP ON SALES AND PURCHASES Ensure DEFAULT TAX CODE is set to either "." or any tax group that has 0% rate Make sure…

Hi @Mathias_Netsuite, how's it going? kindly let us know should you need further assistance on this. Thank you! 😊

Hi @Mathias_Netsuite, upon checking the ability to combine these columns into one is currently a system limitation logged under enhancement #136735 Reports/ Search > Ability to Combine Columns. You can vote for this enhancement on the SuiteIdeas page. To our other members, feel free to share your ideas and suggestions on…

Hi @Mathias_Netsuite, were you able to check this? 😊 Let us know if the information provided in my previous comment was helpful. Hope you have a great day! 😊

Hi @Benjamin Paul - USA, were you able to check this? 😊 Let us know if the information provided in my previous comment was helpful. Hope you have a great day! 😊

Hi @Nickoletta Gounaris, can you try the formula below if it will work correctly? 😊 SUM{amount}/MAX(NULLIF({vendor.custentity_manufacturer_target},0))

Hi @Vernita, can you try testing creating one first in the UI and see how the date and time would look like when created via UI? As per SAID 72655, "Ensure the Date Format in the file for the Custom field is similar from how it was entered in the user interface (For Example: 30/06/2017 19:04:00)" If the value in the UI…

Hi @Mathias_Netsuite, yes that's right. you would need to edit and save as the new customization for the report every year. Hope this clarified your concern. Thank you! 😊

¡Se acabó el tiempo! ✨ La respuesta correcta y su explicación figuran a continuación: Respuesta correcta: C Explicación: Inicialmente, SuiteFlow solo admite la sublista Elementos en Registros de transacciones*. Pero, a partir de la versión 2020.1, se ha agregado soporte para la Sublista de gastos en los informes de gastos.…

Time's up, everyone! ✨ Kindly see details below for the correct answer and its explanation: Correct Answer: C Explanation: Initially, SuiteFlow only supports the Items sublist on Transaction Records*. But, as of release 2020.1, support for Expenses Sublist on Expense Reports has been added. See the clipping below from the…

You're welcome, @Curtis Beene! Glad to be of help 😊

Hi @ChrisG69, Do you have "Location (custom column) on your end? This is how it looked like on my end result: The column was able to pull the item line location instead of the header location. Hope this helps. Thank you! 😊

Hi @Vernita, on your excel file can you try using the dates only? i.e. 26/01/2023 only and remove the 0:01 after the date? 😊

Hi @Mathias_Netsuite, Yes, this is possible by customizing the balance sheet report. You may do the steps below: 1. On the Balance Sheet page, click Customize button on the lower left corner. 2. Go to Edit Columns tab, expand the Financial folder and click the Amount: 3. Set the following for the first column: Column…

Hi @Curtis Beene, Per my understanding, your concern is that you wanted to add quotation marks for the results in the saved search for customers. I tried creating a customer saved search with the following details: I used Formula (Text) to add quotation marks for currencies, date created, and entity name. Here's how the…

Thank you for providing your insights, @GauravAgrawal! ✨ Hi @Mathias_Netsuite, Gaurav is correct. You can only lock certain tasks (i.e. Lock A/R, Lock A/P, Lock All) on future periods by enabling the "ENABLE ACCOUNTING PERIOD WINDOW". Locking future periods prevents users from entering transaction data and journal entries…

Hi @Mathias_Netsuite, You can use the Multi-Book Balance Sheet and Income Statement for this. The reports would look like this: As you can see, the reports have 2 columns which shows 2 accounting books with their respective amounts. You may also check the following SuiteAnswer articles below for further details: 65633:…