Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Answered

How to delete subcontract payment request

Posted on by 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

  • Jeanne Fischer Profile Picture
    Jeanne Fischer 205 on at
    RE: How to delete subcontract payment request

    Worked like a charm.  Thank you so much!

  • Verified answer
    Erich Strelow F Profile Picture
    Erich Strelow F 1,642 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans