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.