Skip to Content
avatar image
Former Member

List of all Purchase Order sent to Vendor as FAX

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 13, 2015 at 07:25 AM

    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 ?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Jan 13, 2015 at 08:51 AM

    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)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

      T Code - SOST.jpg (26.8 kB)