Open Forum

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
------------------------------

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
------------------------------

Original Message:
Sent: Jan 25, 2023 09:47 AM
From: David Morinello
Subject: Targeted Rebuild of RM00401?

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
------------------------------

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
------------------------------

Original Message:
Sent: Jan 25, 2023 09:47 AM
From: David Morinello
Subject: Targeted Rebuild of RM00401?

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
------------------------------

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
------------------------------

Original Message:
Sent: Jan 27, 2023 09:54 AM
From: Jim Harris
Subject: Targeted Rebuild of RM00401?

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

Original Message:
Sent: Jan 25, 2023 09:47 AM
From: David Morinello
Subject: Targeted Rebuild of RM00401?

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
------------------------------