Finance | Project Operations, Human Resources, ...

Vendor Invoice Auto Settlement Issue (Historical + Future Transactions)

(2) Share

Report

Posted on by Rashid.Ali

329

Hi Experts,

We are facing an issue in our D365FO system related to vendor invoice and payment settlement.Since system go-live (2020), a large number of vendor invoices and corresponding payments are still open and not auto-settled, which is impacting the accuracy of vendor ageing and AP reporting. We would appreciate your guidance on the following:

Key Queries:

Is there any standard or recommended approach in D365FO to auto-settle all historical vendor invoices and payments in bulk?
Can this be achieved through any batch job or automation, without manual settlement?
For future transactions, is there any standard configuration or mechanism that ensures invoices and payments are auto-settled going forward?
Considering our business model is Hire Purchase, is auto-settlement of invoices and payments a feasible and recommended approach?

Important Considerations:

Our previous financial years are audited and closed
If settlement requires reopening fiscal periods:
- Is it mandatory to open closed periods for this activity?
- Will this have any impact on audited financials / trial balance?

We are looking for a controlled and audit-compliant solution that can handle both historical backlog and future transactions efficiently.Any suggestions, best practices, or real-world experiences would be highly appreciated.

Thanks in advance!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (8)

Answers (0)

Sort by

CU13040943-0 4 on at

Like (1)

Report
Copy link

Link copied!

Hello,

There’s no one-click option in D365FO to auto-settle all historical vendor invoices and payments, so companies usually handle this through a controlled bulk process using a custom batch or tool rather than manual settlement; standard functionality supports settlement but large-scale auto-matching often needs some customization. For future transactions, you can enable auto-settlement during payment posting to avoid this issue going forward, though in a hire purchase model it works best only when payments clearly match invoices.

Was this reply helpful? Yes No
Suggested answer

Bharath jain 1,567 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi Rashid,

For historical data, the Data Management option can be used. You will still need to download and map the data; however, this approach avoids the need to manually settle each invoice and payment individually. Settlement can be performed in the current open period, avoiding the need to reopen closed periods. If settlement is required based on the original transaction date, the closed period will need to be reopened.

For future transactions

You can enable Automatic settlement in AP parameters. When a payment is made, the system will automatically settle the transaction against the relevant open invoice(s).

Regards,

Bharath Jain.

Was this reply helpful? Yes No
Rashid.Ali 329 on at

Like (1)

Report
Copy link

Link copied!

Hi @Bharath jain,

Thanks for the reply.

Can you please tell me how we can manage through data management?

Regards,

Rashid Ali

Was this reply helpful? Yes No
Suggested answer

Damodar Naidu 20 on at

Like (2)

Report
Copy link

Link copied!
Hi @Rashid.Ali,

Bulk Settlement via Custom Job

Develop a Automated Settlement batch process using X++

Settle based on

Vendor

Invoice voucher number

Payment voucher number

For historical clean-ups:

Extract vendor open transactions

Match invoices & payments in Excel

Use custom settlement batch job

Run settlement vendor-wise

Suggested Control Going Forward

Option :1 : Recommended Business Process for Future

While creating payment:

Select vendor

Click Settle transactions

Mark invoice

Post payment

Option :2 : Enable Auto Settlement

Accounts payable > Set up > Accounts payable parameters > Settlement.

Auto settlement works well when:

Payment equals invoice

No partial payments

No complex adjustments

If partial payments are common, auto settlement should be controlled manually.

Important Recommendation

Before performing bulk settlement:

Test in UAT environment.

Validate vendor ageing report.

Run settlement vendor-wise in batches.

Regards,

Mandala Damodar Naidu

Was this reply helpful? Yes No
Rashid.Ali 329 on at

Like (1)

Report
Copy link

Link copied!

HiDamodar Naidu , Bharath jain

This is already enabled, but not working.

Was this reply helpful? Yes No
Suggested answer

Damodar Naidu 20 on at

Like (1)

Report
Copy link

Link copied!
Hi @Rashid.Ali,

Auto settlement works well when:

Payment equals invoice

No partial payments

No complex adjustments

If partial payments are common, auto settlement should be controlled manually.

Regards,

Mandala Damodar Naidu.

Was this reply helpful? Yes No
Suggested answer

Assisted by AI

Rashid.Ali 329 on at

Like (1)

Report
Copy link

Link copied!

Hi

I have found a solution for future invoices in Vendor Posting Profiles. Here we can allow autometic settlement. I've tested the following cases.

1- Full Payment

2- Under Payment

3- Over Payment

The invoices are auto settled on FIFO basis.

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 20,825 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Unfortunately, There isn't any OOB way to do so.

You can develop a solution or as a work around, you can use payment journals.

You can create a payment journal, auto create the lines by payment proposal and offset them with a GL account.

In the end, the balance of the GL account to be zero.

Was this reply helpful? Yes No