How to delete subcontract payment request

(0) Share

Report

Posted on by Jeanne Fischer

205

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

All responses (2)

Answers (1)

Jeanne Fischer 205 on at

Like (0)

Report

RE: How to delete subcontract payment request

Worked like a charm. Thank you so much!
Verified answer

Erich Strelow F 1,642 on at

Like (0)

Report
RE: How to delete subcontract payment request

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.