AR Receipt entry not came for Remittance

Hi All,

We are enter the Receipt Entry in AR, but some of the receipts are not came for Remittance screen while query in Remettance entry form. The Receipt Status also in "Confirmed". We are face this issue regularly, at this time we update the "selected_remittance_batch_id =NULL" in ar_cash_receipts_all table using the below said script.

Can any one help to provide the permanent soulition for this issue

Update Script

Update ar_cash_receipts_all
Set selected_remittance_batch_id =NULL
Where selected_remittance_batch_id = ' ID '
and CASH_RECEIPT_ID in =' ID '