Hi
Can any one please suggest for is there any setup that collection letter should not be excuted if customer has zero and -ve balance.
Thanks
Hi srikaanth,
Do you mean that if a customer invoice has been paid (Balance = 0), the invoices should not be included in the next run for collection letter?
Yes Alireza and also for over payment if any should not be execute.
Thank you for your response
Hello Srikaanth,
If I understand correctly - you do not care whether customer invoices are settled with payment or not. You would like to create a Collection letter ONLY according to customer balance.
Collection letters are based on open customer transactions - not on the customer balance. In the collection letter setup you can define "Minimum overdue balance", but it is minimum amount for the overdue transactions. The letters will be generated and sent to the customers only if this amount is reached.
You will need to develop your own customization to meet this requirement.
As per my investigation in 10.0.24, once an invoice is settled with a payment, it will not be included on collection letter generation.
The customer transaction will be locked and you cannot edit it.
Please test in your test environment
Thank you Michal Krejza for clarify that Collection letters are based on open customer transactions.
Thank you Alireza Eshaghzadeh for response.
My Last doubt is that however we enter the grace days in the Days field in the collection letter sequence form, then system which days will take to generate the collection letters 1, 2 & 3 either based on Days field in the form or invoice due date in the transaction?
Please suggest
On "Set up collection letter sequence" you can choose a Terms of payment for your collection letter sequence.
Example:
You have not define terms o payment 10Days and Collection letter 1 is set up to 2 days.
Then collection letter 1 can be generated as follows:
Customer invoice due date + 10 days + 1 days
Ref to Microsoft docs https://docs.microsoft.com/en-us/dynamics365/finance/accounts-receivable/tasks/create-collection-letter-sequence :
In the Days field, enter the number of grace days that you will allow. This is the number of days after the due date that a collection letter can be generated. The due date that is used for the calculation depends on the position of the collection letter in the collection letter sequence:
Thank you Alireza Eshaghzadeh
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 813
André Arnaud de Cal... 738 Super User 2025 Season 2
Sohaib Cheema 566 User Group Leader
