News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... D365 Finance - Settlem...

Finance | Project Operations, Human Resources, ...

Answered

D365 Finance - Settlement of Invoices/Payments

(0) Share

Report

Report

Posted on by James-Mc

195

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

All responses Img

All responses (2)

Answers Img

Answers (1)

André Arnaud de Cal... 291,602 Super User 2024 Season 2 on at

Like (2)

Report

D365 Finance - Settlement of Invoices/Payments

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.
Verified answer

BillurSamdancioglu 15,811 Most Valuable Professional on at

Like (1)

Report

D365 Finance - Settlement of Invoices/Payments

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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,602 Super User 2024 Season 2

#2

Martin Dráb 230,340 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans