D365 Finance - Settlement of Invoices/Payments

(0) Share

Report

Posted on by James-Mc

201

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 19,703 Most Valuable Professional on at

Like (1)

Report

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... 300,911 Super User 2025 Season 2 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Jake17 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No