Hello HarrisSeeds,
Based on your description, the Cash Receipt is likely damaged. Two possible records that would need to be looked at.
The RM00401 is the Keys Record. Every transaction should have one. If it is missing, it can cause the inquiry window to not display the transaction.
The work record is missing. (RM10201 - Cash Receipt Work, RM10301 -RM Sales Work, RM20101 - RM Open and RM30101 - RM History). This record is what the inquiry window looks like. If it does not exist, it will not show in the window.
You will need to review the tables for this transaction and see how the data looks and make corrections as needed. If it is only the Key Record that is missing, Check Links will recreate this. If the Transaction record is missing, the rest of the transaction will need to be removed, Reconcile on Outstanding Document Amounts to correct the Invoice Amount Remaining. The transaction can be recreated.
NOTE: Any troubleshooting is recommended to be done in test so further problems don't occur in live until the end results can be verified.
As you state this was a CC Payment, you will also need to review the CC Customer to determine if this customer got updated with the Invoice from posting a CC Payment.
If you need assistance with reviewing the data, please create a support request and we can look at your data for this transaction.
I hope this helps!
Thank you!
Brandon Jarrett | Microsoft Support Engineer.
