Print & Delivery - Mass Delivery updates a UDF when run

Rob

• 30 de junio de 2022 12:01

I am trying to determine how I can run mass delivery and update a UDF to indicate that the document has been sent?

We are trying to implement a 2-stage order acknowledgement. Customer receives sales order receipt once order is approved. Later they receive an acknowledgement when delivery date is confirmed.

If we use mass delivery to send receipts we can exclude documents already handled by print and delivery. When it comes to sending the acknowledgement the documents have already been processed so there is no way to determine which ones have been sent and which haven't.

I was hoping to update a UDF on all documents when the mass delivery processes them.

Does anyone know of a way to achieve this?

Vote

0

• 

  Nili Bergfroind

  • 9 de agosto de 2022 07:42

  for your report action - Choose "Multiple Actions", define the first as "Email report" and do your thing, then define the second as "SQL Action" and write in your update (For example - "update ordr set u_sent='Y' where DocEntry=@DocKey and u_sent='N'")

Iniciar sesión para dejar un comentario.