on 01-13-2015 7:02 AM
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
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 Method | Purchase Order | Sender | Recepient | Send Date | Sent Time | Status |
via Telefax | 4510194472 | Pramod Kumar | US 00-586-296-0072 | 1/12/2015 | 3:25:10 | Waiting for communications service |
Regards,
PK
User | Count |
---|---|
98 | |
12 | |
10 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.