NKusiak Blue Ribbon

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.

Thank you, Patrick! I did try that but it did not work. However, I have an additional question on that. Do I need to override the Tax Code to be 0% as well. When I did the import the Tax Rate defaulted from the Item as '19%' and calculated that Tax Amount instead of using the one from the import.

@Patrick Fresnosa-Oracle Unfortunately, still no joy. I will need to dig behind the scenes somehow to even see where the 60.399 is coming from. In theory, it should work but not today. Thank you! Nick

Hi, @Patrick Fresnosa-Oracle I added USD as the Primary Anchor. Not sure how long it should take but no joy at this point. BTW - Here is a screen shot of the TRY - KZT exchange rate Nick

@Patrick Fresnosa-Oracle My team and I have been trying to get this to work. The document and your notes suggest that it should be working but we are still getting the incorrect exchange rate. We are getting 60.399 when it should be 32.45. I cannot determine how it is even coming up with that amount. We did not populate…

@Patrick Fresnosa-Oracle Thank you for responding. The users use this in expense reports. Here is an excerpt from their request to us. We have a problem with TRY to KZT, that's what we use, our staff have the receipts in TRY and they reimburse in KZT. If I do manual entering of the exchange rate, it works fine, but for the…

Thank you! I believe I have the necessary steps to get this to work. Update the Mobile Phone number by CSV Clear my cache. I am using scenario 4. I will convey these steps to my user and have them verify that everything is working. I spot checked a few and they seemed to work. Thank you!