@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

@RS_RS - instead of filtering by each person, I believe you can set the filter to "Mine" and it adjusts the results based on the user that's viewing the search/report:

@nir.levy - I would try: CASE WHEN {vendorline.internalid} in (20637,21564) THEN TO_CHAR({vendorline.internalid}) ELSE NULL END or CASE WHEN {vendorline.internalid} in (20637,21564) THEN TO_CHAR({vendorline.internalid}) ELSE ' ' END

@RS_RS - Glad you were able to resolve it!

@Richard Appleford OB - you need to fill in the summary label

@RS_RS - You have an extra } Remove line 32

This is my start:

@RS_RS - this worked for me: function afterSubmit(context) { if (context.type == context.UserEventType.CREATE) { var customer = context.newRecord; var custCreate = record.load({ type: record.Type.CUSTOMER, id: customer.id }); var salesRep = custCreate.getValue('salesrep'); var task = record.create({ type: record.Type.TASK…

@User_NG5TG- maybe this will work for % Won Field: Formula (Percent) Summary Type: Sum Function: Round to Tenths (SUM(CASE WHEN {entitystatus} = 'Order Received' THEN 1 ELSE 0 END))/COUNT({number}) It should be taking the formula you used for the Opps Won / Count of Opps

@Micah Timbol-Oracle - no, the Reconcile Bank Statement page.

Oh - that's weird. I've only see that happen if I'm doing it in the sandbox account and the quote was imported vs created in the sandbox account. For system notes, you'd set the criteria to System Notes: Type = Create Results field: System Notes : Set by

@Tom Dalton - did you try the Created By field and it didn't work?

Have you checked SuiteAnswers? There are a few that might be what you're looking for. Answer ID: 43130 Answer ID: 72170