@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

Hello. We were able to figured out by a trick that got us the following formula: nlapiStringToDate(nlapiGetFieldValue('shipdate')).valueOf()==nlapiStringToDate(nlapiDateToString(new Date())).valueOf() Best!

@Micah Timbol-Oracle We figured out the field to use. {item.quantityreceived} Thanks!

@KNason76 Is this one marked on red?

@KNason76 Can you share the enhancement ID to vote for it. Thanks!

@Joy Noreen Magoling-Oracle I opened an enhancement ticket and they confirmed this is something missing on the supply allocation and seems like there are another enhancement request with the number: 485095 I already voted for it and hope Netsuite will take this on consideration soon. Thanks!

to get you a better idea let me show you how the Supply Allocation is not taking on consideration the Planned Work Orders. I have 3 work orders, two planned and one released. 150 for the released and 200 for the planned. We have set the Allocation Strategy to check for future inventory. Using the Earliest Item Availability…

@Jack Daryl Espiel-Oracle Yes. ☺️

Ivy. I am using the Release Preview account and I enabled the Supply Allocation But I don't see all the links on the image of Martha first post. Are we missing something?

Ibraam. Thanks for the tip, I will try that.

Michelle, Just to let you know, I am looking to have that proffered message to be the default on the "Invoices" transactions. I see that works when I created a new Sales Order and then the new Invoice and the message appears. Notice the message is there on the Sales Order but it doesn't get affected when the user send the…

Michelle. I did followed your steps but still not selecting the invoice message.

Niks, Thank you for the reply. I will open a support case on this. Best!

Here is other example why we are looking to get that Availability field figured out. Netsuite said we have 187 items available but the Availability show 1, I think uses all the open sales orders (committed or not committed). When we send to the customer the list of the items with the Available quantity, they see the 187…

Ivy. I know that. What I ended doing is one save search for the Item Location Configuration because I need the Internal ID from there. Then I created a save search for the Item containing that Planning Time Fence. Exported the 2 files and used excel vslookup to match the items with their correct Planning Time Fence. Seems…

Ivy, I tried already the For Planning Time Fence: {locationsupplytimefence} formula but got an error: Field not found. Thanks!

Hi. I just want to share that I created another workflow to "uncheck" the "To be E-mailed" field on all other transactions that are NOT Invoices. They want to manually continue sending emails to those other transactions: "quotes, sales orders, etc" This is the action: