Open Forum

 View Only
  • 1.  Targeted Rebuild of RM00401?

    TOP CONTRIBUTOR
    Posted 11 days ago
    Edited by David Morinello 11 days ago
    Does anyone have a SQL Script to manually do a limited repair/rebuild of the RM00401 ?
    In this case, one payment record is in RM20101 but is not present in RM00401.

    I just want to rebuild the one, not look through the 35 million.

    Why not do Check Links? 35 million rows in Receivables Open Transactions. (Don't get me started on why...)


    Thoughts?

    ------------------------------
    David Morinello
    Senior Developer
    TruckPro LLC
    Cordova TN
    ------------------------------


  • 2.  RE: Targeted Rebuild of RM00401?

    GPUG ALL STAR
    Posted 10 days ago
    Hey @David Morinello
    I've never tried these options but I'm wondering if one of them might be just enough to add your missing record to the table.
    First thought - Utiliies\Reconcile for just this customer.  You might could add more restrictions if this customer has a ton of transactions.
    If that doesn't work, I'm wondering if you could use PSTL to unapply the payment, then reconcile, then re-apply the payment.
    Nothing really says that either of these options will update the RM00401 table, but they might be small enough options you could try.
    Thanks
    Windi​

    ------------------------------
    Windi Epperson
    Customer Support Manager
    Njevity, Inc
    Norman OK
    720-870-9700 x104
    ------------------------------



  • 3.  RE: Targeted Rebuild of RM00401?

    GOLD CONTRIBUTOR
    Posted 9 days ago
    I've always just added these manually to RM00401, but this should work.  Just fill in your payment number and un-comment the second row.

    SELECT DOCNUMBR, RMDTYPAL, 2 AS DCSTATUS, BCHSOURC, TRXSORCE, CUSTNMBR, CHEKNMBR, DOCDATE, 0 AS NEGQTYSOPINV
    --INTO RM00401
    FROM RM20101
    WHERE (DOCNUMBR = 'PYMNT7593302')

    ------------------------------
    Jim Harris
    Director of Information Systems
    ExamWorks, Inc.
    Atlanta GA
    ------------------------------



  • 4.  RE: Targeted Rebuild of RM00401?

    TOP CONTRIBUTOR
    Posted 6 days ago
    Thanks everyone!

    Had a few days when I couldn't login to reply. All the responses were great!

    ------------------------------
    David Morinello
    Senior Developer
    TruckPro LLC
    Cordova TN
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role