NKusiak Bronze Medal

@Angelica Mae Segador-Oracle I am Nick Kusiak and I work with Tammy who originally opened this discussion. We are opening a Case with NS but I wanted to add a little more clarity on our request. We are trying to modify an existing Email Template. We want to add potentially 2 custom fields from the Transaction record in the…

Thank you I was able to extract the data by using a saved search on Employee record and using formula fields for the Login Audit Trail data.

Thanks, @Angela Bayliss I am able to access the data in NetSuite. The challenge is trying to access this data via extraction tools or IPAAS products. Login Audit Trail data has not been available through the API that these tools use which is the limitation of NetSuite. Please add more information if I am not understanding…

Thank you, @Alex Joves -Oracle. I had read those before. My question regarding those is which 'country! Field drives which form is used? Is it the subsidiary or the address of the entity record?

Thank you. @Patrick Fresnosa-Oracle We are using BRHUB. Here is a screenshot of the UK form Here is the Brazil form - there are many different fields

Thank you, @Able Wilson . Here is what the Brazil form looks like - it has different fields than normal Here is the United Kingdom If I merge them together into one and have both countries on it does that become the default for each country? How do I denote a form to use in this special situation? Thank you.

Thank you, @Clarisa De Torres-Oracle . Still no joy. Is the behavior any different in a SandBox environment? However, your information on roles, I was using administrator, was helpful. If you do not have any other sugestions then we can close this.

Thank you @Clarisa De Torres-Oracle That is what I was hoping would happen but it doesn't seem to be working. Do you know of a definitive SuiteAnswer that will go through set up action? I set the limit at 30 and created 2 invoices, both over that amount and no message.

@Edwards_05 I narrowed down the issue to the <img src= statement. I have just found if I hard code the whole url that it works. Previously, I would pass the URL in the saved search. That is the part that seems to have changed. I will add this information in the ticket I have open. Thank you for responding.

Thanks, @Angela Bayliss I have opened a ticket. I was also wondering if anyone else had/has this problem. I appreciate your responce.

I should add that we do not use the LOGO(Forms) or LOGO(Page). We have a custom field on the subsidiary record. We pull this field into the saved search that feeds the template. Again, this has worked well up until 3 weeks ago.

@Dominica Sevilla-Oracle Thank you for your help.

@Niks Blando-Oracle Thank you. When I uncheck the Charge for Shipping checkbox on the Shipping preferences, the integration creates the Sales Order. In these cases, the Shipping Cost and Shipping Method are both empty.

@Dominica Sevilla-Oracle Thank you. Does this mean that if I leave the shipping cost out then this issue will go away? I am not adding or changing any fields on the Sales Order which is where the error is occurring. It may happen on the Invoice but it did not get that far. I was able to successfully add the Sales Order in…

@Dominica Sevilla-Oracle The process to take WooCommerce transactions and import them into NetSuite ran on January 1. I had checked the Charge for Shipping to be True before it processed. One tansaction processed successfully that did not have a Shipping Amount. The others had an error that was the same for all of them.…

@Dominica Sevilla-Oracle Thank you for responding. I am probably not going to be able to do that until after January 1. We have an integration that runs that creates Sales Orders, Invoices and Payments. It only runs once a month on the first of the month. I will check that box again to trip the error. Then I should have…

@Nicole Mendoza-Oracle Here is the formula field under the current Formula(text) '<a href="https://system.na2.netsuite.com/app/common/search/searchresults.nl?searchtype=Transaction&Transaction_FORMULATEXT='||REGEXP_REPLACE(CASE WHEN {recordtype} = 'journalentry' THEN {name} ELSE {mainname} END, '[0-9]', '')…

@Micah Timbol-Oracle Thank you! We will try that

@Clarisa De Torres-Oracle We are using Advanced Taxes

We are having a similar issue when using Chrome. We are getting time out issues on loading scripts. We noticed that it happens on slower network speeds. However, FireFox seems to work okay. Is there a known issue with Chrome?

@Joahnna Given Uy-Oracle Thank you for your response. In my original request - Our user community wants to add the discount amount on each line item on the Invoice Advanced PDF form. There are SuiteAnswers about adding Discount Rate but I have not seen anything on the amount. This is not on the header but on each line item…

Thank you, @Joahnna Given Uy-Oracle . This looks like it will only provide the discount amount for the total invoice as it is a body field. We need the amount of the discount on each line for each item. Some items may have a volume discount in pricing and they want to show that on each line. Will this solution provide that…

@Nicole Mendoza-Oracle Thank you, Nicole! I am waiting for our user community to get back to me. However, I am still unsure what to expect. How many schedules can be on one report? The goal here is to change the owner not create a new schedule unless the new one replaces the original. This is where we feel we are not…

@Nicole Mendoza-Oracle When we went to the report and selected Schedule, we put in the 3 values that it asked for. Schedule Name, Date, Start Time. Using the same values as the original Schedule. While it would save the schedule, it did not retain the other configurable options such as Recipients and message. Please…

@Patrick Fresnosa-Oracle @Ivy Lopez-Oracle Thank you for this solution. Pretty cool. You are both the BEST! May I ask one follow up question? I have found that it is possible that the email address may not have been entered the same on every employee record. For example. Nicholas.Kusiak@cru.org Nicholas.kusiak@cru.org…

@Patrick Fresnosa-Oracle I use a formula. I have tried both text or numeric but here is the description and a screen shot. CASE WHEN {custentity_ccc_termination_reason} = 'Death' THEN 0 WHEN {custentity_ccc_termination_reason} = 'Ministry Termination' THEN 0 WHEN {custentity_ccc_termination_reason} = 'Resignation' THEN 0…

@Patrick Fresnosa-Oracle Thank you, Patrick! I do not think I was very clear on my requirements. My use case is that I have an employee record in 5 subsidiaries using the same email. I need to check all 5 employee records that are associated to my email address and to check the conditions I list above, All 5 employee…

@Mikko De La Fuente-Oracle Mikko - you may have answered my question but I am not sure and need a little more granular answer. Yes - I can place the tax amount in a custom field. It is getting visibility to the Item : Tax Amount field that is my question. Since we are not on SuiteTax do I have any other options? Also,…

@Patrick Fresnosa-Oracle I marked your last comment as a Yes to solving my issue. I have gotten several examples to load successfully. However, my original need is to have this available for an IPAAS to integrate with WooCommerce. We use Celigo and the Items : Tax Amount does not exist. I realize that you do not support…

@Patrick Fresnosa-Oracle Thank you for your help. We have the International Tax bundle and use Legacy Tax. I am including my import file and screen shots of my results and the csv mapping. The import has .80 for the tax amount but it calculated the tax and ignored the import.