Gab JS Blue Ribbon

@Joy Noreen Magoling-Oracle I think we could use the "Item Defined Cost" to accomplish what are we looking for but how could I se the custom field of our "Custom Standard Cost"? or what is the field to set the "Item Defined Cost" ? this is our custom field that we get the standard cost:

@Joy Noreen Magoling-Oracle We dont use Drop Ship but I see the Special Work Order Item is check. our Cost Estimate Type it's Average Cost. we created a custom field in the circle and we would like to get that into the line item on the transaction. Or what do we need to do?

here is an image of what do we see in our opportunity line item transaction. we have the cost feature enabled.

@Elychelle Gulen-Oracle Hi, We are using our custom sales order that we build from the Sales Order - Invoice not the cash sales. This is more related to "Cybersource" after processing the payments with CC on a Sales Order, this Sales Order gets converted into a Cash Sale transaction instead an Invoice. I understand that we…

Hi, We are experience the same issue, Our customer doesn't have the default CC but when we process the transaction goes to Cash Sale instead Invoice. Any suggestions?

@Angelica Mae Segador-Oracle Yeah, I been trying to do a couple things, a workflow or script but I having no luck. Thanks!

@Elychelle Gulen-Oracle I have that already selected. Has i mentioned in the previous message, we already found the following solution: We created a save search to get all the items to be sold. Editing the transaction form, we selected that save search on the Item Filter under the Sublist Field. That is working for us.

@Elychelle Gulen-Oracle Won't work, i notice the first pop up window doesn't show but when we started entering the first characters of the part number and press tab the search window pops showing the same list starting with the numeric list. Thanks!

@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!