Hi @Jack Daryl Espiel-Oracle , We using the SuiteAnalytics Connect Browser Itzik

Hi @Jack Daryl Espiel-Oracle , I think we are using the legacy Netsuite.com Data Source. com.netsuite.jdbc.openaccess.OpenAccessDriver Regards, Itzik

@Joahnna Given Uy-Oracle - Hi Joahnna, Actually, after trying what you wrote, I am not getting any results for the saved search (only the average number for apparently all the customers) Criteria: Results: Final result: Also when I try to search for the saved search under the custom entity field, it is empty. I have no…

Hi @Katerina Winklerova-Oracle, @Kristoffer Viray-Oracle , Apparently, the SuiteBuilder team was the one handling my case. And they also told me that the implementation I'm asking from them is outside of their responsibility and can be done only via ACS or PS. I'll be happy to hear if you have any idea of how this can be…

Thank you @Katerina Winklerova-Oracle , this was very helpful. Itzik

I see, that maybe a better option, so I can remove irrelevant deals. Thank you!

Hi @Katerina Winklerova-Oracle, @Kristoffer Viray-Oracle , Thank you for your answers. I asked NetSuite support to move the case to the SuiteBuilder team. Hopefully, this will help us to get our answers. Your help is highly appreciated. Itzik.

Hi, I already approach the NetSuite support team. They said the issue is with the code we did in the Statement template. I have an open case for it. Any ideas on how this can be escalated to the right team? Thanks, Itzik

Thank you @Katerina Winklerova-Oracle We don't use Discounts so I don't see any effects on payments. But I have one issue I can't solve as I have a Payment term that was set as DATE DRIVEN and I want to change it to STANDARD. Can I do it w/o inactivating it and creating a new one? And if I need a new one, I need it to be…

Hi Micah, I understood that the change needed is to change the departments from the parent subsidiary+include children --> mark all subsidiaries separately. I just would like to make sure that this change won't affect anything else. Thanks, Nir

Thank you Patrick, I voted for this enhancement. hopefully it will be developed soon.

Hi Patrick, that very helps, however, it is still not enough, I'm talking about a few thousand revenue arrangments that need to be updated in 2 sets of books. In parallel, I'm working with a developer to build a script that does that. any other thoughts? Do you know if there's a plan in the future to add CSV import to…

Hi, thank you for the answer. It's not that the bank account was assigned to Child Subsidiary but the role was limited to a child subsidiary. after changing "including Children" to mark all subsidiaries in the department it worked. My concern is if there are any additional effects of changing the setup like that. I would…

Hi Patrick, Thank you for the detailed explanation. the issue I'm facing is trying to figure out how I do a massive update to the revenue arrangement days, and then later how to uncheck the compliant in many revenue arrangements, I know the reallocation can be done in a bulk of 200 each time. Thanks Nir

Hi Leonard, I didn't try Sales Orders created via NetSuite UI manually and it won't help me since all SOs are created via web service. Thanks, Nir

Thank you, appreciate it. waiting for updates. Nir

Hi Ely, I tried to import only 1 sales order as a sample before importing a bulk of Sales Orders. The Sales Order was created by a Web Service I didn't try to do so with this specific order but we opened old Sales Orders in the past by removing the "Closed" checkbox from the Sales orders' lines. The system information…

Hello, I was able to find the solution for my issue - choosing Custom Record as import type and choose the correct Custom Record. Thank you!

Hello, "End Customer" and "Amount (USD)" are both custom records. End Customer is type "List/Record - Customer", Amount (USD) is type Currency

Hi @Ivan Griggs UK, Yes, I'm using this bundle and yet, I see the values I mentioned in my original message. any clue what could cause it? Regards, Itzik

Hi @Lea Celosa Columna , Thanks for your reply. Can you tell if this SDF can be exported to a DEV environment and not SB environment? Thanks, Itzik

Hi Patrick, It worked! Thank you so much. Nir

Hi Patrick, The fields are not mapped via the Revenue Field Mapping. It is an Auto-Expansion type. And no, revenue plans are not started yet, and there are no Revenue Recognition Journal Entries for the Revenue plans. hope that will help. Thanks, Nir

I didn't mention that when I started the discussion. when I do the change trough the UI it works as expected.

Hello Joy, thank you for taking the time to answer me and for the details link you sent over (Very helpful!) I was actually asking if we could have in a same and unique column predefined value and formula (for empty value)

The formula did not work for me. However i used the below ones: NVL({taxtotal},NVL(((NULLIF({amount},0) - {netamountnotax})/NULLIF({amount},0)),0)*{fxamount}) for calculating the amount of tax and NVL({netamountnotax},NVL(({netamountnotax}/NULLIF({amount},0)),1)*{fxamount}) to calculate the subtotal. It worked. thank you,…

Thank you for taking the time to explain. I was actually referring to a different issue. In my saved search, I need to indicate: foreign transaction amount in USD without VAT foreign transaction VAT amount in USD Total amount of the transaction in USD. I wanted to check with you what formula can be used to show the data…

Good day @Dominica Sevilla-Oracle :-) This is exactly what I did. I first edited the Customer record, added a new address, and saved the record. Then I created a new Sales Order and wanted to select the new address added but it wasn't available to be picked yet. another concern I have is regarding the Lable field. It's…

Hi @Dominica Sevilla-Oracle , I was just creating a Sales Order to the Customer I added a new address yesterday, and all Addresses were available in the picklist for both Bill To and Shipp To. Are you familiar with this behavior when an address is added to a customer, not immediately available in the transaction, but only…

Hi @Dominica Sevilla-Oracle , Thank you for your quick reply (and apologies for my late response). As I was checking the example I built in my SB environment, I can now see all addresses I added to the Customer when creating a new Transaction (Sales Order). But when I added a new address to the Customer and right after I…