Gab JS

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…

in Availability value on Check Item Availability Comment by Gab JS Aug 31, 2022 5:15PM

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…

in Planning Time Fence not showing on Save search Comment by Gab JS Aug 16, 2022 8:37PM

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

in Planning Time Fence not showing on Save search Comment by Gab JS Aug 16, 2022 7:34PM

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:

in Invoice Sales Orders - to be emailed options Comment by Gab JS Aug 16, 2022 3:43PM

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…

in Invoice Sales Orders - to be emailed options Comment by Gab JS Aug 15, 2022 4:52PM

I think i got the workflow to work.

in Invoice Sales Orders - to be emailed options Comment by Gab JS Aug 15, 2022 4:07PM

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.

in Invoice Sales Orders - to be emailed options Comment by Gab JS Aug 15, 2022 3:08PM

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…

in Invoice Sales Orders - to be emailed options Comment by Gab JS Aug 12, 2022 8:27PM

Dominica. Thank you for checking on this.

in Bulk Delete Item Location Configurations Comment by Gab JS Aug 5, 2022 2:23PM

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…

in Bulk Delete Item Location Configurations Comment by Gab JS Aug 3, 2022 3:01PM

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!

in Bulk Delete Item Location Configurations Comment by Gab JS Aug 1, 2022 7:40PM

just additional info. Here is the save search.

in Bulk Delete Item Location Configurations Comment by Gab JS Aug 1, 2022 3:13PM

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…

in Item Availability save search get qty on PO by weeks Comment by Gab JS Jul 5, 2022 2:26PM

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

in SQL Statement for combining LIKE conditions Comment by Gab JS Jun 21, 2022 5:04PM

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

in Item Fulfillment CSV upload Comment by Gab JS Jun 21, 2022 2:43PM

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.

in Item Fulfillment CSV upload Comment by Gab JS Jun 15, 2022 8:56PM

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

in Item Location Configuration form Comment by Gab JS Jun 15, 2022 8:05PM

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.

in Item Location Configuration form Comment by Gab JS Jun 14, 2022 4:28PM

Problem solved. We have to delete the portlets and add them again. Thank you!

in users with same role unable to see reminders Comment by Gab JS Jun 13, 2022 6:18PM

James. Besides that we notice some of the user portlets are empty like the image for the reminder even if there is a selection. I will open a case on the support site as well.

in users with same role unable to see reminders Comment by Gab JS Jun 13, 2022 5:58PM

Hi James. You are correct. The user in question is not getting any errors. The reminder looks like this: They both have selected the same like this image. Also that user is not able to check the box for Show reminders with zero results.

in users with same role unable to see reminders Comment by Gab JS Jun 13, 2022 5:54PM

More info. It is not the browser. The user currently use chrome and we tested opening netsuite with firefox and same issue the remainders are not showing.

in users with same role unable to see reminders Comment by Gab JS Jun 13, 2022 5:43PM

Dominica. I just tested your formula. It worked really great. Thank you!

in Printing Pick Tickets in a bulk from Save Search Comment by Gab JS Jun 4, 2022 4:25AM

Thank you Michelle.

in Saved Search > For all of (Month) New Customers Comment by Gab JS Jun 3, 2022 5:47PM

This is the link for the printing Pick Ticket. https://XXXXXX.app.netsuite.com/app/accounting/print/NLSPrintForm.nl?printtype=pickingticket&trantype=salesord&method=print&hotprint=T&title=Sales+Orders&whence= and I tried to do the next but seems the link is not working. Formula (text) and Group. '<a…

in Printing Pick Tickets in a bulk from Save Search Comment by Gab JS Jun 3, 2022 5:22PM

and update on this. I created a user event script that will update the recent user notes on the customer record when the user assign a company on the contact. This are the steps that I followed. 1- Created a test contact. (no adding company yet). 2- Save. 3- Edit the contact to be able to add the notes under communication…

in Contacts User Notes sync with Customers User Notes Comment by Gab JS May 31, 2022 5:17PM

Michelle. Thank you that other formula worked. Thank you so much!

in Date Formula to combine two dates on the Criteria for Save Search Comment by Gab JS May 31, 2022 2:28PM

Michelle. The formulas provide me a good start. I modified the formula to provide me all the calls before and after the sales order. Now what I am trying to do is to summarize that results by month. For example on the second screen shot the SO was made on the 4-15 so I would like to show the calls for that month and will…

in Saved Search > For all of (Month) New Customers Comment by Gab JS May 31, 2022 2:26PM

Michelle. I started with Customer save search because on the customer record we could find the different transactions, sales, activities on the subtabs. what I am struggling is to compare the two dates for example on this one: how many had phone calls before they purchased. I am trying to compare the dates of the…

in Saved Search > For all of (Month) New Customers Comment by Gab JS May 26, 2022 2:12PM

Michelle. Seems like worked. showing me the results for this year. What could be the combinations for Last year, this Month, last year?

in Date Formula to combine two dates on the Criteria for Save Search Comment by Gab JS May 26, 2022 2:03PM

Gab JS Blue Ribbon

Comments