You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to query the latest pdf contract from purchase agreements after a change order

edited Apr 15, 2024 7:59AM in Reporting and Analytics for SCM 1 comment

Summary:


Content (please ensure you mask any confidential information):

Hi Everyone,

I currently have a query where I am selecting the Contract Number, Description, Start Date, End Date, File Name associated with the PDF, and Document ID which I am using to get the actual file through SOAP Web Service. I get the original PDF's associated with these purchase agreements, but when a change order is done, I do not get the latest PDF and I cannot seem to find it in any table.

For example, the original pdf could have the file name: PA_3000000000004_C24070_0.pdf and after a change order is done, it then changes to the file name: PA_3000000000004_C24070_1.pdf.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!