Hi, I have a migrated Accounts Receivable open invoice balance that was paid by the customer after the data migration. Although the payment has been received and fully settled against the migrated open invoice, the system is still generating collection letter for the customer.
At the customer account level, I can confirm that the payment has been received and settled against the migrated open balance. However, on the Customer master record, under the Credit and collections tab, the following collection letter fields are not being updated:
Collection letter
Collection code
Collection letter date
Valid collection note
There is also a batch job configured to generate collection letters. In this case, the customer payment settlement occurred after the collection letter creation batch had already processed. Could this timing be the reason the collection letter was generated as the invoice was subsequently settled?
Please advise why the collection letter is still being generated despite the invoice being fully settled, and why the collection-related fields on the Customer master record are not being updated for this migrated transaction?
Could this behavior be related to the fact that this is a migrated AR open balance? If so, are there any additional steps or validations that should have been performed during or after the migration?
Also, what is the recommended approach to prevent collection letters from being sent to this customer?
Thanks
