r_bharose
1st April 2004, 18:56
I was thinking if there is way to capture the field in the report? eg. supplier code.

This is my requirement.
Purchase order to be send to supplier, when the print purchase order is fired. I would have a table to maintain email addresses by supplier.

When the user fires the report, the report is send to the supplier using the stored email address. I would have a custom "ttstpconv" invoking "BLAT" in background. The problem with this approach is to find the Purchase Order code for which the print command is fired. Once I know the purchase order code I can send email to predifined email address of the supplier.
(This can be extended to other reports as well)


Anybody with hint or idea.

Thanks and Regards,
Ram:confused:

r_bharose
1st April 2004, 19:04
One way could be change the report script to capture the information.

I would like to have a more generic solution.....

tools123
1st April 2004, 19:49
There are many 3 rd party tools for email and fax which allow for
the kind of outputs you are expecting.
Streamserve is one of them.
Also check the board for many posts on the email capability for reports.

Hitesh Shah
2nd April 2004, 09:15
The problem with this approach is to find the Purchase Order code for which the print command is fired.

U can write following code in the report script and use the from to purchase order number.


declaration:
domain tcorno fromorno,toorno

before.program:
import("orno.f",fromorno)
import("orno.t",toorno)

mark_h
2nd April 2004, 17:46
I did something like this, but with out the Email option. Since Print Purchase Order is one of our order steps I created a separate session to run the print purchase order. What the program did was allow the user to enter a purchase order range. It always ran the batch "accounting", so the user(auditors or accounting folks) could not actually finalize a purchase order. This way I knew if it made it to the report it was already sent to the vendor. In your case you may need to check the purchase order status, so that way they did not send the PO multiple times to the vendor. Each PO from this session was handed individually to the print PO session - 1 report per purchase order. Also I prevented them from sending it to devices like file or display - nothing like getting 100 reports on your terminal. :)

You can check out things like Nazdaq tools for emailing or faxing.

Mark