Ivan Babiichuk Red Ribbon

I would like to clarify something. Although I marked @Sailo Antony answer as the solution, it turns out that the Item Fulfillment field (Field ID: itemfulfillment) in the Item Receipt form is populated dynamically. By dynamic population, I mean that the field receives its value only when the Item Receipt record is opened.|…

@Sailo Antony Thank you, that's a very helpful answer!

Hello everyone! Unfortunately, I couldn't figure out how to accomplish this task using a workflow. Therefore, I decided to use a scheduled workflow that triggers a script instead. I'll share the script in case anyone might need this solution: Adding the script in NetSuite Navigate to Customization/Scripting/Scripts/New and…

@Angelica Mae Segador-Oracle Hello! Thank you for the information provided, I will take a look at it to better understand the work processes.

I had to change the approach and do it a bit differently from what I initially planned. I have created an additional field IsCustomerChanged and hidden it from view, in which I store information with an array of items that have the price level I want, and a boolean value whether the customer has confirmed that he wants to…

@Richard James Uri-Oracle Hi! Sorry for disappearing for a long time, I had a lot of university work. 'Have you tried undeploying the other scripts to verify if the issue lies within the concerned script?' Yes, I checked this before writing the question here, and I didn't find anything that could affect the script…

@Richard James Uri-Oracle Hi, yes, I understand that. But the problem is different. When selecting another customer, my script and some internal NetSuite function are running in parallel, which is most likely a higher priority, and does not allow to change the fields that I mentioned above.

@Richard James Uri-Oracle Hello! I tested my query, which I provided earlier, and it didn't work in any of the cases. Although I referred to the Records Catalog and all the joins were correct in theory, but the REST API query didn't return any results. To get the default shipping address I needed for a specific customer, I…

@Nicole Mendoza-Oracle Hello! I'm sorry to bother you. Even though I closed this discussion, I'm confused. I conducted a test where I created a simple WorkflowActionScript (see SetLastCountDate.txt) in which I manually assign a value to the Last Count Date field (id = lastinvtcountdate). And as a result, it set the value…

@Richard James Uri-Oracle Hello! I'm sorry, it was my mistake, I mixed up the technologies when I wrote the question. I reviewed it, and in fact, I am using REST web services, not SOAP web services.

@Elychelle Gulen-Oracle Hello! I have reviewed the suggestions above. They are not exactly what I needed. Based on my task and the suggestions provided by @Tigran Shahnazaryan, @Elychelle Gulen-Oracle, I implemented SuiteSQL that selects the fields I need. To find the last purchase date, I used a subquery to find the…

@Tigran Shahnazaryan Hello! I have reviewed the saved search. It's a good solution, but not exactly what I needed. Here, we get a list of items and their last dates of use. What I needed was to take items from the Items Tab for specific transactions and get their last dates.

@Elychelle Gulen-Oracle Hello! I tried to replicate your example, but Formula(Numeric) and similar fields do not support the MAX function. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N2833020.html#bridgehead_N2834645 Therefore, it will not work in my case.

@Angela Bayliss @Nicole Mendoza-Oracle Thank you so much for your help and detailed explanation!

@Angela Bayliss Thanks! I wanted to clarify if it is possible to change the value of Last Count Date using scripts or workflows?

I have solved my issue. Note: The solution is only needed if you have the ACCESS TYPE - REQUIRE CUSTOM RECORD ENTRIES PERMISSION parameter set in the custom record type. If you have a custom record type, for example, mine is Competitor Pricing, the parameter in the ACCESS TYPE field will be automatically set to REQUIRE…

@Nicole Mendoza-Oracle Hello! No, I have looked at the examples you provided and have already solved my question, thank you!

@Nicole Mendoza-Oracle I would like to take this opportunity to clarify one more thing. Is it possible to use Formula (Numeric) and similar fields in creating Saved Search with SOAP? Also I am using wsdl 2020_1_0 - https://webservices.netsuite.com/wsdl/v2020_1_0/netsuite.wsdl in my C# project. And I do not have access to…

@Nicole Mendoza-Oracle Thank you very much for the valuable information! I will definitely review it all.🤗

@Robert Nedelkow-Oracle Thank you! Everything is working now. I apologize for bothering you.

@Robert Nedelkow-Oracle Good time of day! I'm sorry, but I'm having permission issues again. I've already cleared the cache, but it didn't help.

@Richard James Uri-Oracle Hi! I tested your script, and it worked: Although I don't fully understand why my script, but only with the afterSubmit function, wasn't working. I simply copied all the content from my file into yours, and everything started working. Thank you!

@Richard James Uri-Oracle Hello! What trigger is specified in your script? Because I set it to 'afterSubmit,' and nothing happened. Here, I will provide you with my example: An SO and IF were created using the WMS feature, here are these entries: Then, after the IF was created, my script should have executed, but it didn't…

@Joahnna Given Uy-Oracle Yes, this is exactly what I needed, for some reason I missed it when I was looking through the documentation. Thank you so much! 🙂

I apologize for taking your time. At first, I cleared the cache, but the error persisted. However, later I changed the password for my account and refreshed the page, and now everything is fine. I can't say for sure if it was specifically the password that was causing the issue with file uploads, but thank you very much!!!…

@Robert Nedelkow-Oracle Hello! Thanks for your answer, but the problem still remains https://i.imgur.com/tU1Hc0o.png

Hello @Katerina Winklerova-Oracle, yes, sorry, didn't notice that the translator was enabled. I've changed the main text.

@Ivy Lopez-Oracle Yes, indeed your advice was correct, thank you very much! And sorry to keep you waiting for an answer🤗

@Ivy Lopez-Oracle Hi. I apologize, we just have a problem with the SandBox, all my work is still there and I do not have access to check it :( I believe I can give you an answer as soon as possible.

@Ivy Lopez-Oracle Hi, thanks so much for the advice! I will try that and give an answer a few later