Send remittance to different email than purchase orders?

SUGGESTED

Hello,

A supplier of ours wants their remittance emails sent to their account's email, but their purchase order emails sent to the purchase email.
We have their purchase email working fine, when we send a purchase order it goes to the correct email.
However, when we send a remittance email it also goes to the purchase email, because it is pulling through the first email in their account file.
How can we send the remittance to a different email address?

Thanks,
Danny 

  • 0

    Hi Danny,

    To edit a layout to pick up the address preferences if it doesn't already, please do the following;

    1) In Report Designer, on the menu bar click Report then click Email Settings.

    2) Click To then next to the Expressions that define the people you want to send the report to box, click Add

    3) Copy the following expression into the box:

    ((SALES_DEL_ADDR.ADDRESS_TYPE <> 2)||(COMMUNICATION_ADDRESS.PREFERRED_EMAIL = 0)) ? SALES_DEL_ADDR.E_MAIL : ((COMMUNICATION_ADDRESS.PREFERRED_EMAIL = 1) ? SALES_LEDGER.E_MAIL2 : SALES_LEDGER.E_MAIL3)

    After this, click OK > File > Save > File > Exit and test out the email.  Any issues please let me know.

  • 0
    Hi Adam,

    It wont let me save the above.
    I presume it's because you are referencing SALES, however the remittance layout I am editing is using PURCHASE email.
    I tried changing it to the relevant purchase code but still wont let me save the expression.

    Thanks,
    Danny
  • 0
    SUGGESTED
    Hi Danny,

    Apologies, i think Adam meant to send you this one:

    PURCHASE_DEL_ADDR.ADDRESS_TYPE <> 2 ? PURCHASE_DEL_ADDR.E_MAIL : COMMUNICATION_ADDRESS.PREFERRED_EMAIL = 0 ? PURCHASE_LEDGER.E_MAIL : COMMUNICATION_ADDRESS.PREFERRED_EMAIL = 1 ? PURCHASE_LEDGER.E_MAIL2 : COMMUNICATION_ADDRESS.PREFERRED_EMAIL = 2 ? PURCHASE_LEDGER.E_MAIL3 : "Unknown"

    This one should allow you to just copy and paste.

    Regards,

    Michael

    Sage UKI

    Sage Business Community Team