Gab JS Blue Ribbon

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:

Remember that first I created an Entity custom field named Email Address for Invoices on the customer record. On the customer record i set the Preference tab to Send Transaction Via Email. Here is the workflow and worked. Here is the action: So when I process the the invoice using the page: Invoice Sales Orders with the…

I think i got the workflow to work.

Hi Joahnna. This is my workflow from the SuiteAnswers Id: 42975. I manipulated a little to see if I can accomplish this: action: From field, I selected the custom field. But when creating the invoice doesn't set the email address into the "To Be emailed" Field. here is the email on the custom field on the customer record.

Michelle. The steps on the solution in the number 9 says to set and static value and in that example seems to require an email address. 9. Parameters: Field: Select Email Value: Static Value: Enter Email Example: test@test.com 10. Click Save Trying to understand, there I need to set the "custom field" instead? Everytime…

Dominica. Thank you for checking on this.

Hi Dominica. No, I want to delete the items location configuration not the items, that's it I cannot use the mass update option. In the following image there is the item: 0980-0010 and the location that is inactive is E.... - MRB What is happening a user copy an old Item and that brings all the locations for that item but…

I deleted the script file. I am going to start from the beginning. I still appreciate if somebody figured out something to accomplish this. Thank you!

just additional info. Here is the save search.

I Dominica. Sorry for the late response but I was out of the office. Our POs we have a custom date on the line items (expected receipt date) that is the date the vendors promise we will receive the items. After the user confirms with the vendor that date the user also checks another field (date & qty confirmed). But the…

Tybrneryan As Ivy suggested try this: CASE WHEN {shipmethod} LIKE '%FedEx%' THEN 'FedEx' WHEN {shipmethod} LIKE '%USPS%' THEN 'USPS' WHEN {shipmethod} LIKE '%UPS%' THEN 'UPS' WHEN {shipmethod} LIKE '%LTL%' THEN 'LTL' END

Dominica. Thank you for the response, I used map/reduce script to accomplish these changes. Thanks!

Dominica. Do you happen to know how to update a field that is on the line item for the fulfillment? I am looking to update the CLASS. I followed your steps but I don't see that field.

Well. NS support didn't found the solution, they advised like always to try by script.

Jack. I have to open a case on Netsuite support because I can't find the way edit and save the Item location configuration records into the New form.