D365 Finance - Settlement of Invoices/Payments

(1) Share

Report

Posted on by James-Mc

215

Hi All,

I have an environment where invoices have been created through invoice journals and payments have been posted similarly through GL journals. This has led to a scenario where customer's have the correct balance on account but there are 1000s of open invoices as they haven't been settled off against each other. Is there a way to bulk settle transactions? This needs tidied up and a manual activity would be possible through the settle transactions view but would probably take weeks as opposed to hours.

Thanks

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

BillurSamdancioglu 20,521 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

There is no option for that OOB. As a workaround, use payment proposal and select all but while the balance will be 0 and can't post the journal fill with for example 0.01 amount and offset the same vendor with auto settle. This may create some additional transactions but the balance will be correct.

1 people found this reply helpful.

Was this reply helpful? Yes No
André Arnaud de Cal... 303,461 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi James,

For how many customers do you need to settle the transactions? Per customer, you can mass-mark the transactions and then post the settlement.

1 people found this reply helpful.

Was this reply helpful? Yes No
Jake17 2 on at

Like (0)

Report
Copy link

Link copied!

Is there a way to automate the action in the screenshot above?

Was this reply helpful? Yes No