Dynamics Community Forum Thread Details

Vendor Invoice Auto Settlement Issue in D365FO (Historical + Future Transactions)

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 general

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics