Skip to Content
0
Former Member
Dec 18, 2008 at 10:36 PM

Finding document number from SOST

162 Views

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 :>)