Gab JS Blue Ribbon

@Angelica Mae Segador-Oracle Thank you for the info. I ended doing another trick. I created a save search to get the list of the call when the owner is -system- then I created an schedule workflow to update that field. Best!

oh,, I think I got something, I used 90 days ago instead 3 months ago. That made the trick.

@censys_sl I tested this but I see its doing similar what I got. Example Today is "Friday" May-26-2023 then six months ago was "Sat" Feb-26-2023, its not finding records because we don't work on weekends. What I would like to accomplish in the formula is look at today "Friday" to get the "Friday" six months ago. so, today…

@slarsen_1226 I will test that. Thanks!

@Elychelle Gulen-Oracle The Last Sales Activity field is a SuiteApp bundle. In the help section you can search for it: Setting Up the Last Sales Activity SuiteApp The way that i selected the 6 months ago was on the Criteria: Thanks!

there were more than one results on the save search. But after following your steps the save search preview worked again. Thanks!

I notice if i change the Output type to Report i can see the preview but in Normal opens a transaction.

I found that document on the UPS site that describe the fields. Hope it can be useful for someone.

@Ivan Babiichuk I have a question on your report, the linked transaction can be opened when you export the report into excel? We are trying to create a report and schedule to be emailed to our sales rep every month, when they open the report in excel they could click on the link and open the record in NetSuite. Thanks!

@Dominica Sevilla-Oracle And you guys know the first question? About what are the fields we need to fill to populate the red arrows in the original post.

@Joy Noreen Magoling-Oracle I figured out this part. I used this formula. CASE WHEN {status} = 'Shipped' and {custcol_ava_assetaccount} = 'Inventory- Finished Goods' THEN CASE WHEN ((TO_CHAR(TO_DATE({trandate}),'MON/YYYY')) = 'JAN/2023') THEN {quantity} ELSE NULL END END The only issue with this one is that for the next…

Hello. @Joy Noreen Magoling-Oracle I been working on the transaction save search to be able to get the correct results but i am experience some issues. here is the criteria on the transaction save search: The first parenthesis section is to get the items we purchase and the second parenthesis section is to get the items we…

@Joy Noreen Magoling-Oracle looking at these ones, thanks!

@Richard James Uri-Oracle Now is not generating an error but seems is not doing anything :), I was expecting to see the page previews at least.

@Richard James Uri-Oracle The weird thing is every time I try to update that script I receive this error. So I have to delete the script file and add it again with the modifications. That is the reason that I also tested with the other script in the article but both get the same error when I try to use the print button.…

@Richard James Uri-Oracle I just tried but got the same error. best!

@Jack Daryl Espiel-Oracle and @Edo_Aroni Edo, Your solution worked, I am still testing but so far so good. Thanks!

@Jack Daryl Espiel-Oracle and @Edo_Aroni I will try the solution but after creating the checkbox i have to update all the current items with that "email sent" T to avoid sending emails to all the current items. Thanks!

@Edo_Aroni Seems a easy solution and I am going to try that after the response for the support team. I think on the workflow creating a new state field as a checkbox will be similar. Lets see what is their solution. Thanks!

@Jack Daryl Espiel-Oracle this is the workflow and we will focus on the part in the red circle. in there i have an action to send the email to notify accounting there are a new product, also the other mails is to inform the manufacturing team about this new product. The issue that I am having is an email is send to the…

@Jack Daryl Espiel-Oracle Feel free to open another trend if need it. I have a similar question. I created a workflow for NPI process and by the end I have that worflow to send an email to some users. Well the workflow sent the email but everytime the user edit the item it will send another email again. So, this will be an…

@Joahnna Given Uy-Oracle We are going to create a new BOM revisions and I think I don't need to use the mass update script to delete the item on the BOM revision. But, I appreciate if somebody could put the solution just in the case that one day i need to that. Thanks!

An item on the BOM

Solved, We just removed the Adobe Chrome extensions and he is good

@Niks Blando-Oracle this also apply to my post above?

@Mikko De La Fuente-Oracle Hi, A user is trying to select DHL but seems there is not an option for us, I saw one DHL "inactivate" from the Ship items list and "activate" but still that is not an option for us to select. Only see the electronic/email only thanks!

@Elychelle Gulen-Oracle I just want to let you know the workaround provided by you worked. They decided to change the serial numbers so i have to create a new ones following your solution. Thank you!

@Elychelle Gulen-Oracle Elyechelle, So let me try to explain what we did. First we Opened/Edit our Work Order Completion and I was able to rename the Serial from -EM00 to -EM0B. I did the same thing on the Item Fulfillment. I tried to do the same thing on the Invoice and let me delete a character but I cannot type a new…

@Elychelle Gulen-Oracle Let me see if I understand you workaround. As an alternate solution, here are the steps you may take: 1. Edit the Item Fulfillment and select the original Serial/Lot Numbers first. Edit, select the original Serial/Lot Number(s) and save? 2. Then the Serial/Lot Numbers not showing before will now be…

@M.Lisa I am able to edit the invoice but I can't find the items with -EM0B that updated on the Work Order Completion or Fulfillment. The invoice is still open