A Customer generally have multiple Sites/branches where users create multiple journals to post the customer payments for multiple banks, multiple transaction types, method of payment etc. and the bank statement provide total amount for a transaction type. This cause difficult, time-consuming and cost impacted to match the D365 transaction with Bank statement. The finance department also wants to see daily transaction summary in the system.

The parameter "Summarise amounts in bank account" available under Journal names is not sufficient due to its limited capability to summarize the transactions by journal name.

It would be quite helpful if this parameter would be extended to allow summarize the transaction for a given date range for multiple journal names based on criteria set by the functional consultant.

So, it should allow the consultant to configure the summarization by

1. Selection of required Journal names

2. Selection of other criteria such as Methods of payment, transaction type, document number, description, offset account, financial dimensions, financial tags, payment reference, payment id, reason code etc. The more fields available from the journal to select, the easier for the consultant to meet the client requirements.

3. It Should allow to run a daily batch job for the date range, relative dates like today, yesterday etc.

Another functionality available in D365 is Deposit slip generation. It can be tried extend the deposit slip functionality and make it for both vendor and customer with above mentioned change.