Workflow-Help: Set Invoice Status after email is sent to customer

[snoo]

Hi,

I have troubles getting the workflow set for the following:

After i create an invoice the status is set by default to "created".
When i click on "E-Mail PDF" and select the template and send the mail to the accounts email, after successful delivery I want to set the status in the invoice entity to "Unpaid" via workflow.

The Worklow looks like this:
Trigger-Type:
After record updated
Conditions: Status equals "created" (and.. email is sent!?)
Update Target Entity: Status = Unpaid.

How can I check for a sent email for this invoice?

Thanks in advance!

[dimyy]

Without additional customization impossible.

Sent email and Invoice has no any relations.


If you want you can customize function getAttributesForEmail (/application/Espo/Modules/Sales/Services/Quote.php) and return parentType and parentId accordingly to Invoice.

Then workflow should triggered on email.sent and check parentType status...

[dimyy]

May be control creating Attachment and check parentType = Email and relatedType = Invoice.

[snoo]

Thanks for the hints.
But i cant set up a workflow for the Attachment, only for an E-Mail. And to check if that email has an Attachment is simple. Unfortunately you cant check if that email belongs to an invoice... just to an account.. but this will get complicated.

And i dont want to modify the code, i just want to use the tools and workflows provided.

[dimyy]

You can get attachmentsIds, then loop and check record/attribute relatedType, relatedId