Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[David Morinello]

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

[Windi Epperson]

Hey
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 – UtiliiesReconcile 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
——————————
——————————————-

[Jim Harris]

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

[David Morinello]

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