Announcements
I have subcontract payment request with status of completed that will not pull over to review and approval screen. An additional pay request for same vendor and project was entered at same time after change order was added to subcontract. This one was available for approval. The previous one is still showing as completed. Unable to enter additional pay requests against line time-get message over line amount even though it is not. The "completed" request is populating some tables in project controller. If I override the amount limit I think it will effect committed costs tracking. Any suggestions?
Jeanne Fischer
*This post is locked for comments
Worked like a charm. Thank you so much!
The only way I know out of this involves serious tweaking through SQL. Please take this as a last resource and keep an eye on your backups before doing it.
It's something like:
update pjpayhdr set status1='I' where project= @theproject and subcontract= @thesubcontract and payreqnbr= @therequest and status1='C' and batnbr='' update PJSUBDET set prior_request_amt=prior_request_amt-pjpaydet.curr_total_amt from pjsubdet inner join pjpaydet on pjsubdet.project=pjpaydet.project and pjsubdet.subcontract=pjpaydet.subcontract and pjsubdet.sub_line_item=pjpaydet.sub_line_item where pjpaydet.project= @theproject and pjpaydet.subcontract= @thesubcontract and pjpaydet.payreqnbr= @therequest
This will reverse the missing payment request to its initial state. The prior_request_amt field is supposed to do the trick limit wise. Check out the additional conditions on status1 and batnbr. I put it there just to annoy you, if there is already a batnbr then you better track it down.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156