cancel
Showing results for 
Search instead for 
Did you mean: 

List of all Purchase Order sent to Vendor as FAX

Former Member
0 Kudos

Hi,

We are creating Purchase Orders and sending the PO to Vendors as FAX on daily basis (using Scheduled Job).

Our Purchase HOD wants a list of all the POs sent to Vendor as FAX with their Status (Sent or Failed).

We tried to develop Report using NAST & SOST tables, but we could not get the desired Result. We could not established the Link between the NAST & SOST tables

Need your help in this. Please suggest the Tables from where we can extract the Data.

Regards,

PK

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

You do have above details available in NAST. Are you missing something . You can easily develop a report based on the above details.

Sent method- NACHA(in your case 2 or 4)

Purchase order-OBJKY

Sender-USRNAM

Receipient-TELFX (alternatively you can get the details from NAST-ADRNR and put the same in ADRC to get TELFX details)

Send Date-Processing date(DATVR)

Send Time-Processing time(UHRVR)

Former Member
0 Kudos

Hi,

Thanks for your reply.

Yes, we can get the maximum information from table NAST, but we are not able to find the “Message Sent Status”.

As per understating, this we can get from table SOST, fields MSGNO and MSGV1.

Just to repeat, we want to develop a report similar to T Code SOST, please refer the attachment.

Regards,

PK

Former Member
0 Kudos

Can you elaborate what exactly missing in NAST table which your require to be sent to HOD. DId you try NACH which provides detailed output data ?

Former Member
0 Kudos

Hi,

Thanks for the Reply.

We want as below; Basically, these data can been seen in T Code SOST;

Our HOD wants these information on mail on daily basis.

Sent MethodPurchase OrderSenderRecepientSend DateSent TimeStatus
via Telefax4510194472Pramod KumarUS 00-586-296-00721/12/20153:25:10Waiting for communications service

Regards,

PK