Clarisa De Torres-Oracle NSC Guru

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:…

Hi @SabranHameed, apologies for the limited assistance and inconvenience this is causing you based on the standard behavior of the system. Should you really need this functionality, you can discuss with your Account Manager or your ACS team if this is possible via customizations. You can also submit an enhancement request…

Hi @Benjamin Paul - USA, Per my understanding, you concern is that when you create PO via CSV import, the exchange rate being pulled is incorrect. I tried investigating your concern on our test account with details below: 1. PO Created on UI with exchange rate= 1.25: 2. CSV File used for CSV Import with details: 3. Field…

Congratulations, @Brian Stisser!! 👏

Hi @SabranHameed, As per checking, for your concern for you to be able to change the expense report project to the appropriate one, user has to un-approved the expense report. Moreover, users will not be able to un-approve an expense report if any of its receipts were already billed. So for users to be able to proceed,…

Hello @User_IJB6M, We're glad to have you here. Thank you for creating this thread. Kindly allow us to review your concern and we'll provide updates in this thread. To our other members, feel free to share your insights or suggestions by commenting on this thread.

Hi @User_NC62U, 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. To other members who may have insights regarding this topic, feel free to add your comments by replying to this thread.

Thanks for the clarification, @User_1FIUN. Since your concern is about the posting/entries of NCI, it seems that this is more of an accounting related one rather than about the system's behavior. We think it can be best answered by the other members here. To other members who have any thoughts, insights, or suggestions, we…

Hi @User_1FIUN, Regarding the posting of NCI, this depends on the practice of your accounting department. You can ask community members on how they post NCI. 😊 On the other hand, if you wish to customize your Financial Reports to show the percentage of Non Controlling Interest, you may check out the answer in this thread…

Welcome to NetSuite Support Community, @User_1FIUN! We're glad to have you here. Thank you for creating this thread. Kindly allow us to review your concern and we'll provide updates in this thread. To other members and users who also have insights that may help, feel free to join this thread!