User_ZCWF3 Gold Medal

Ivy recently posted this: https://community.oracle.com/netsuite/english/discussion/4492184/nsc-transaction-saved-search-work-order-shows-assembly-and-components-in-the-same-row Not sure if this would meet your needs

Hi @Grace Catabian-Oracle and @Nicole Mendoza-Oracle , The workflow executed on the transaction, but not when there was a System update. Only when a user interacted with the transaction.

Hi @Jervin Nicholas Teopengco-Oracle Here are some screenshots:

From what I’ve found, you have to get the IF value back to the sales order since the invoice is created from that.

Hi @Jervin Nicholas Teopengco-Oracle , I have it triggering on after record submit. I do not have a condition for the workflow itself...I have the WF script deployments associated with Work Order and Sales Order. I have the work flow associated with Work Order and Sales Order. The wf runs the wfs after record submit. If…

I don't think so...we need to know as soon as the unallocation happens.

Ah - gotcha. I was looking at the formula you had in the 3/5 screenshots where you showed the criteria and results. Sorry!

I might double check that formula you have... If the recurring amount is Null then you want to put the value of the recurring amount? It just established it was empty, right? If it's not null, you're not putting a value here too...just END.

@Clamps123 - starting to get feedback from our users too

@Glan - the way you have it setup makes sense to me. You may want to include some filters for the Payment / Journal Status.

@Glan - did you scroll all the way to the bottom where the fields have ... after them: Once in t here you select the Name/ID: Using Customer (Main Line) fields will only bring in Customers and not Vendors. Can you send a screenshot of how your search is currently set up?

@Glan - have you tried this

@User_TRQT3 - I think Suite Answer 30880 would work for you Scenario Saved Search to Show the Last Item Receipt Date per Item and its Age as of Today Solution 1. Navigate to Lists > Search > Saved Searches > New > Item 2. Under Criteria tab, enter the following: a. Type | Inventory Item b. Transaction Fields..Type | Item…

@Jervin Nicholas Teopengco-Oracle - cancel is not one of the selected event types

@Jervin Nicholas Teopengco-Oracle - yes, I have tried that. The email still gets sent if I press cancel.

@User_2LD8N - we don't use the Manufacturing Task Scheduler. We could never get it to work the way were told we'd be able to. From what I recall, we enter work order completions at least daily and that moves the progress for the task.

Perhaps you need to uncheck the custom field's "Store Value" checkbox (if it's currently checked).

How is your sales order linked to the purchase order? Also kind of curious about this custom field: {purchaseorder.custbodypo_expected_receipt_date} I would expect the custom field id to be {custbodypo_expected_receipt_date}. I haven't come across any instances where I've used purchaseorder + "." + customfield. But we do…

Well that's not helpful - sorry! it's suite answer id: 29291 i've included a screenshot as well:

I haven't seen (or we don't use) a "Void" status for our POs, but we do have "Closed". To unclose it, we have to uncheck the Closed checkbox for each line item on the PO.

Came across this suiteanswer: https://suiteanswers.custhelp.com/app/answers/detail/a_id/29291/loc/en_US

{allocatedsupply.expecteddate}

It looks like the Sales Order Dependency is a required field. Is it getting populated?

I think you would then have to further filter the search to get what you want...only those that are open, those in the past 30 days, those created today, etc.

It would get added to the search filter section

maybe add "AND", ["mainline","is","T"] to the search?

You said your log showed three results, so I assume you have a loop set up somewhere. I think you need another one: if (invoiceResults.length > 0) { for (i = 0; i < invoiceResults.length; i++) { var invoiceId = invoiceResults[i].getValue({ name: 'internalid' }); } }

@jm4160 - great! Glad it worked. This forum is a great tool. Helped me so much when I first began :)

Have you tried putting the criteria in the Summary section:

You have an extra else: CASE WHEN {vendorline.internalid} in (22293,87622) THEN TO_CHAR({vendorline.internalid}) WHEN{vendor.internalid} in (22285,22287) THEN TO_CHAR({vendor.internalid}) ELSE 'Default' END