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!

Hi @manuelsaomartinho, Per checking, revaluation entry do not depend on the ending balance of the account but on the open foreign transactions posted on the account. The system currently does not have ‘Closed’, ‘Cleared’ or ‘Paid in Full’ status for Journal Entries. They will always be open and will be included on monthly…

Hi @Christopher Williams, were you able to check our comment above? Please let us know should you need further assistance on this. Thank you! 😊

Thank you for providing your insights, @M.Lisa! 😊 Hi @Jeroen Sprangers ZS, Lisa is correct. Unfortunately, there isn't a way to search user's preferences such as with the language set. Per checking, we have found a related enhancement to give the ability to search user's preferences logged under #253607 Saved Search >…

Hi @Benoit Cavailles, I checked both the Enhancements #134370 and #83426 and noted all are still in progress and not yet closed. As of the moment, there's no target date that we can provide when this Enhancement will be implemented. Per checking, currently, there is also no documented workaround or alternate solution for…

Hi @paula.courtemanche, We're delighted that you're 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 other members who may have insights regarding this topic, feel free to add your comments by replying to this thread. 

Welcome to NetSuite Support Community, @User_J46EA! Thank you for creating this thread. Tagging our gurus who have expertise on this: @Ivy Lopez-Oracle / @Joy Noreen Magoling-Oracle / @Elychelle Gulen-Oracle / @Dominica Sevilla-Oracle , any insights? To other members who might have encountered the same or might have any…

Thank you for sharing your insights, @M.Lisa! 😊 Hi @User_JJC0O, Welcome to NetSuite Support Community and thank you for posting your concern here! Our guru/s will look into your concern and reply to this thread for any updates. To our members, please feel free to share your thoughts as well.

Hi @brocha, Thank you for posting another thread here in the Community! Let me tag our gurus @Kristoffer Viray-Oracle / @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle , to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to you. To other members…