Vendor Payment Settlement with Invoices

(0) Share

Report

Posted on by omeri.hasan

Hi there,

I've migrated my account payable historical data to new Dynamics 365 Finance and Operation environment. Both payments and invoices are already posting. There are a lot of invoices which are either fully or partially settled with payments.

I need help here, is there any way to settlement invoices and payments through any excel ad-on or data management without manual interference? I've settlement records in excel.

Any help would be appreciated!

Omeri

I have the same question (0)

All responses (5)

Answers (1)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Omeri,

I can understand that you bring over partially settled invoices and payments but why did you bring over fully settled invoices and payments? What is the underlying reason for this?

Best regards,

Ludwig

Was this reply helpful? Yes No
Satish Panwar 14,671 Moderator on at

Like (1)

Report

Hi Omeri,

Take a look at link below. Similar entity is Available under AP as well. Give that a try.

community.dynamics.com/.../customer-payment-journal-and-settlement-of-invoices

Was this reply helpful? Yes No
omeri.hasan 5 on at

Like (0)

Report

The reason for keeping fully settled transactions is because these still fall within same fiscal year, these will be required by auditor. At the time, we will not be maintaining old system, so if we don't keep complete history for audit, that would be problematic for year end closing with auditor.

If you propose a solution for partially settled transactions, we can follow the same for others as well.

Omeri

Was this reply helpful? Yes No
omeri.hasan 5 on at

Like (0)

Report

Hi Satish,

I already tried the same on "Vendor payment journal line settled invoice", when I tried to export data, it doesn't return any record, means it gives completely blank template. I've thousands of partial and full settled transactions, but nothing comes in this template/entity.

Maybe it is useful for customer transactions, but for vendors, it doesn't work.

Please also consider the point that, we're already using Dynamics 365 Finance and Operations, our company is separated from the Group, so we have acquired our new D365 environment, and Go Live will be within few days.

Appreciate if you can share further help as soon as possible.

Thanks

Omeri

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Omeri,

I believe that you will need some help from a developer to write you a script for making the automatic settlement.

That is because you might have a lot of transactions with identical invoice and payment amounts.

In my home country we also have the issue that we regularly use cash discounts when making payments, which makes things more complex because you have to replicate exactly what was recorded in your 'old' system.

Would it be an option to get your auditors involved here in a way that they audit the payments and settlement from your old system so that you don't have to bring those transactions over into your new system? This might be an easier option if this is feasible.

Best regards,

Ludwig

Was this reply helpful? Yes No

Join the conversation

Community site session details

Vendor Payment Settlement with Invoices

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Vendor Payment Settlement with Invoices

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates