See below link
https://community.dynamics.com/forums/thread/details/?threadid=f1ab65ac-16db-ee11-904d-000d3a574f8a
Text from the above link :
My objective is to speed up customer payment entries into D365 by use of templates, or import of files from customers and EDI at a practical easy way for an AR person
There is a template in D365 based on the Customer Payment Journal which you can use with D365 EXL addon, but not on the Customer Payment Settled line as not preconfigured, and even if you can do you cannot add to templates so they appear under /open lines in Excel/ ( 1st Screen shot in the above link)
I need this to get one payments settled as one line on the Bank and Customer account
In ver 10.0.32 there is the /Ability to post detailed vendor and customer payments, but summarize amounts to bank account/, not customer , and this doesn't assist in the import process in any case
You can create a template via the D365 XL addin to the required data entity, but I discovered and from another forum ( link below) any data entry either via this or via data management import ( not easy for day to day for an AR person to follow ) requires /Due Date / to be completed for some counter-intuitive reason ( 2nd Screen shot in the above link)
You can use the Customer Payment journal via the D365 XL addin and publish into D365 with the 10.0.32 functionality, but i noticed the published Invoice Number and the amount is not triggering the line to be settled ( 3rd Screen shot in the above link), so the consequence is the posting of the journal is not settling the lines
I suspect even using power automation will fall down due to the Due date issue / and the trigger on marked for settlement
Any tools/methods to achieve daily bulk import from customer remittances ( PDF) , other file formats would be good as this is a basic need for most enterprises