Open Forum

CN.PRA.00 - Subcontract Payment Review & Approval

  • 1.  CN.PRA.00 - Subcontract Payment Review & Approval

    BRONZE CONTRIBUTOR
    Posted 09-26-2018 04:31 PM
    We're working on our SL 2015 CU2 testing and are having an issue with the Project Subcontract Payment Review & Approval (CN.PRA.00) which is crashing when you mark a Pay Req to Approved and click Begin Processing.  The screen disappears and then pops a Windows GPF error.  I checked the Hot Fix list and don't see anything related to this screen.  Has anyone else had this problem?

    CN.PRA.00 Crash

    ------------------------------
    Joe Miller
    Director of Systems Architecture
    Harrison, Walker & Harper
    Paris TX
    ------------------------------


  • 2.  RE: CN.PRA.00 - Subcontract Payment Review & Approval

    BRONZE CONTRIBUTOR
    Posted 09-27-2018 02:46 AM
    We experienced an issue with this when the user would hit save before filling out the screen.  The only recurring issue I could find is the currency field would not be populated.  Check the table PJSUBCON and PJSUBDET to see if the CuryId and CuryMultDiv are filled out.  Once I updated those fields, the payment would work.

    Thad

    ------------------------------
    Thad Vesely
    Controller
    KBA, Inc.
    Bellevue WA
    ------------------------------



  • 3.  RE: CN.PRA.00 - Subcontract Payment Review & Approval

    BRONZE CONTRIBUTOR
    Posted 09-27-2018 04:19 PM
    Thad,

    Thanks for the suggestion, but this doesn't appear to be our issue.  The involved tables are PJPayHdr and PJPayDet, which I did review for missing entries (great suggestion!) and don't see anything out of order.  Hopefully someone else has some ideas.  Appreciate your efforts though!

    Joe

    ------------------------------
    Joe Miller
    Director of Systems Architecture
    Harrison, Walker & Harper
    Paris TX
    ------------------------------



  • 4.  RE: CN.PRA.00 - Subcontract Payment Review & Approval

    BRONZE CONTRIBUTOR
    Posted 09-28-2018 12:41 PM
    Do you have any customizations in AP?  We do, and sometimes we have to push through a Sub payment.  That issue, unfortunately, I have no clue what creates it.

    Good luck.
    Tha

    ------------------------------
    Thad Vesely
    Controller
    KBA, Inc.
    Bellevue WA
    ------------------------------



  • 5.  RE: CN.PRA.00 - Subcontract Payment Review & Approval

    Posted 10-24-2018 02:08 PM
    ​Hello - I am wondering if you were able to find a solution to fix the issue. We are experiencing the same issue in CN.PRA.00 screen and we cannot seem to find what the problem is.


  • 6.  RE: CN.PRA.00 - Subcontract Payment Review & Approval

    BRONZE CONTRIBUTOR
    Posted 10-25-2018 09:34 AM
    So in our case it turned out to be an issue with an add-on we use called SpitFire that is called in this process.  That process was looking for information from the Project Header, but couldn't find it do to a setting change needed for our new SL 2015 environment.

    We found it by running a SQL Profiler while releasing the batches and stepping through all the SQL that was being fired and running it by hand to see where it could be breaking down.  It's most likely a missing piece of information, like CuryID or CpnyID or something to that effect.

    Joe

    ------------------------------
    Joe Miller
    Director of Systems Architecture
    Harrison, Walker & Harper
    Paris TX
    ------------------------------



  • 7.  RE: CN.PRA.00 - Subcontract Payment Review & Approval

    BRONZE CONTRIBUTOR
    Posted 10-25-2018 11:32 AM
    Ok, I do have ONE suggestion and that is to check your database's PJSUBCON table for any records where BaseCuryVouchers isn't equal to 0 or 1.  If you find any that are blank (we had some in ours) this screen would crash.  The fix for us was to update that field to 1 and then the screen wouldn't bomb out.  The records in our case were VERY old contracts that were in place before this column came into being and the value never got initialized.  Here's the SQL to review and correct that we ran.  Make a backup before running the update script!!

    --Look for PJSubContracts where BaseCuryVouchers not valid
    SELECT * FROM PJSUBCON WHERE BaseCuryVouchers NOT IN('0','1')

    --Update the values with blank
    BEGIN TRAN
    UPDATE PJSUBCON SET BaseCuryVouchers='1' WHERE BaseCuryVouchers=''
    COMMIT

    ------------------------------
    Joe Miller
    Director of Systems Architecture
    Harrison, Walker & Harper
    Paris TX
    ------------------------------



  • 8.  RE: CN.PRA.00 - Subcontract Payment Review & Approval

    Posted 10-29-2018 09:59 AM

    Thank you so much for your reply. It was very helpful.

    The project that was causing the crashing screen was found after Rejecting all the payment requests, then Completing and Approving them one by one. The screen crashed again when this one project was processed.

    Before these steps, I was not able to approve/reject any of the payment requests displayed on CNPRA00 even if they were not tied to this "bad project",  so I had to update the Status to R by using SQL.

    The select statement from your reply returned exactly the project that was causing the screen crash;  BaseCuryVouchers = 'A' instead of '0' or '1'.