Finding document number from SOST

[Former Member]

Hi:

I am trying to find document numbers starting from records in table SOST for reporting on failed faxes. Documents can be order confirmations, ship notes, invoices, or several other types.

I tried searching NAST by date/time to pull from field OBJKY, but this fails when two or more faxes are sent at the exact same second (time is hh:mm:ss format).

Any pointers, advice, leads on figuring this out will be GREATLY appreciated! My guess is that I need to work backwards from SOST to a table related to the specific document type.

Thanks in advance for any assistance anyone may be able to provide.

John :>)

[Former Member]

Hi:

I am trying to find document numbers starting from records in table SOST for reporting on failed faxes. Documents can be order confirmations, ship notes, invoices, or several other types.

I tried searching NAST by date/time to pull from field OBJKY, but this fails when two or more faxes are sent at the exact same second (time is hh:mm:ss format).

Any pointers, advice, leads on figuring this out will be GREATLY appreciated! My guess is that I need to work backwards from SOST to a table related to the specific document type.

Thanks in advance for any assistance anyone may be able to provide.

John :>)

[Former Member]

Hi John,

You may try these tables:SOFFCONT1 or SOCVPC.

Regards,

Venkat.