@Patrick Fresnosa-Oracle, @Andy Galuski— I am also receiving this same error when trying to create a search for generating a payment bill file. I have followed the steps as outlined in the article that was posted earlier (Defining Transaction Saved Searches for Electronic Bank Payment), but still get this error despite…

Hello, @Judith Culanding-Oracle— Yes, your understanding is correct. In the end we went with option #2, because this Sales Order happened to be one that had been made quite a few months ago. If it had been relatively recent option #1 would have been preferable, but since it was from earlier in the year we would have had to…

Certainly, @Tris Mendoza-Oracle. Here you go: Criteria: Results: I should note that if we access the saved search on its own and export the results, then we DO get the correct information—that is, the list of Sales Orders. It seems to happen only when we use that search as a portlet on a customer's dashboard and then try…

Thank you for looking into this, @Tris Mendoza-Oracle! I will go and vote for that enhancement. It's a feature that we would use fairly often.

@Jeremy Guimaras-Oracle — We are in a similar situation as @User_2LD8N, but perhaps even more complicated, as the invoice has already been Paid in Full. Here is what happened in our account: 1. Sales Order 123 was made to Customer ABC 2. Sales Order 123 was then invoiced to Customer ABC 3. The sales team learned that Sales…

Hello, @Venice Jane Lejos-Oracle— Thanks for the article. That is what we ended up doing, but we had been hoping that NetSuite would have had better controls or capabilities for this sort of thing. Something even like the capability to only allow certain IPs to access or view the site would be welcome (like what NetSuite…

Thank you for looking into it for us, @Niks Blando-Oracle! I do know there is Outsourced Manufacturing, but that is overkill for our situation and introduces more complexity than we need into our system. We had been hoping that there would be an Outsourced Manufacturing 'Lite' or Outside Processing like we had described,…

Certainly, @Niks Blando-Oracle—more than happy to provide more information: Occasionally, we will send our items to outside processors to do some finishing work. The include processes such as anodizing, coating, painting, etc.--processes that we are unable to do in-house. These outside processers do NOT assemble our items…

Hi @Red Velasco-Oracle— Thanks for the tips. And that is what I was expecting to see on the Go To Record action (either Current Record, Current Record ID or Record ID as an option), but none of them appear as a choice: Which is why I am struggling to get this to work. What I am expecting to see is just not there. I would…

Thanks for chiming in and clarifying, @Matrim! And my apologies if my initial question was misleading, @Angelica Mae Segador-Oracle. I appreciate that you looked into the issue for us!

@Ivy Lopez-Oracle—we are also looking to incorporate this feature into our account, just like @Suitestallion. We have instances where we build a product here, but then send it to an outside processor for some finishing work before the product gets delivered to the customer. (Note: this is NOT the same as outsourced…

@Jack Daryl Espiel-Oracle — I am in the same boat as @Hormese Paul right now: we have a custom sublist on our Item Fulfillment records and would like to print that sublist data on some of our forms. I referred to both of the SuiteAnswer articles that you posted and used those for guidance, but no matter what we do that…

Thanks for the tip, @Red Velasco-Oracle! I think I'm almost there, but I'm struggling with the final step to open the same record again when the Save & Edit button is pressed. I used the article here for assistance in adding the Save & Edit option: The last step now is to instruct the Workflow which record to open, and I…

That worked! Thanks, @Clarisa De Torres-Oracle!

Thank you for all the time spent looking into this @Shiela Marie Villaluz-Oracle! I appreciate the effort you put into your testing and research. It's too bad that NetSuite doesn't have this functionality yet for Saved Searching and emails, but at least we know that we can use scripting to achieve the same. Have a good day!

Hello, @Angelica Mae Segador-Oracle— Yes, the code for the table is present in what I shared with you. The code does not look exactly the way that you are pointing out, though, because the code you are giving is from the Standard Estimate (Quote) Advanced PDF Template in NetSuite (the one available out-of-the-box). We have…

Hello, @Angelica Mae Segador-Oracle— That is the code for the item table, is it not? It begins with this line <#if record.item?has_content> And then goes through each item in the list via this line: <#list record.item as item> These lines corresponds to the item table, as given in the documentation here: Could you let me…

Hi, @Fleur Martinez -Oracle— Thank you for that suggestion. That's actually what we're using in in the interim: ${credit.appliedto} This works (to a degree) in the meantime since we can at least get the Bill #, but it still doesn't let us dig into the details of the bill itself. Nevertheless, it improves upon what we had…

Wow, @SouthernSun—you're right! Changing the field type to "Disabled" made it appear on the form. I would not have expected that to make a difference, but apparently there's something with the native behavior, like you stated? I'll throw the question to the support team that's been assigned to our case to see what they…

Hi, @Alex Joves -Oracle—thanks for the offer to help, but we're good! We filed the support case this morning.

Thanks for the suggestions, @User_8IOYS. I went through all our workflows and none of them explicitly set that field to be hidden, nor are there any scripts working behind the scenes that reference it. So it's a bit of a mystery still. Regardless, the Release Date Modified field does still get set on record create. Once…

Certainly, @Angelica Mae Segador-Oracle—we can start here and see where that gets us. Here's the code (it may look complicated and convoluted, but all it's actually doing is outputting different information depending on whether the line is a standard item or a subtotal item): <#if record.item?has_content> <table…

Similarly, is there a way to know what exactly changed in a bundle update? Such as improvements, bug fixes, new features, etc? We have a handful of bundles that we could update, but we don't know what is actually changing to know whether it's even worth performing the update. Most other software providers have a change…

@SouthernSun, @Niks Blando-Oracle—thanks for your input. To start, yes, this is a saved search that is just reporting information—nothing used in a script or a workflow. In our case, we can't start at the Sales Order level, because POs can be created two ways: From a line item on a Sales Order From a component item on a…

Hello, @Angelica Mae Segador-Oracle— Thanks for digging up those SuiteAnswers. However, those all refer to Parent:Child Customer relationships, or Parent:Child Item relationships. That same type of functionality isn't available when working with Parent:Child Class relationships. We can't get at the Parent Class fields,…

Yes, @Judith Culanding-Oracle—I'm in the same boat as Kiya: having the ability to include the Credit Memo information would be useful and welcome, but that's only one half of what's needed. We also want to be able to include the Bill information associated with those Credit Memos. So, like Kiya said, all the relevant…

Hello, @Niks Blando-Oracle — Yes, those POs are for dropship items. So, when we add those items to the SO, the system automatically creates a PO for them. Now, this is more of a tangential question (the real question for this post is still "Can we get line-level information in a saved search for a Purchase Order that was…

Also, what is the itprlrcds sublist that is listed on the Vendor Payment PDF/HTML Template (among others)? To what sublist does that refer? I can find neither documentation nor references anywhere to what it is.

Similarly, we have another search defined like so: 1. On the Criteria tab, we have a Formula (Text) field that looks at the {item.class} field: 2. On the Results tab, we have a Formula (Text) field that displays the {item.class} field. (We use {item.class} so that we can also get the parent class as part of the value.) 3.…

Thank you, @Jervin Nicholas Teopengco-Oracle. I appreciate you taking the time to look into this for us!