Finance | Project Operations, Human Resources, ...

Building AP spend analysis based on multiple vendors to one vendor hierarchy

(0) Share

Report

Posted on by Community Member

We have a requirement to configure some type of vendor hierarchy to be able to create a spend analysis based on the vendor relationship.

For instance, we might have a DHL vendor account for each DHL different countries companies we receive invoices from. We might to have an account for DHL Denmark, DHL USA and DHL Germany within the same legal entity. We want to pay the invoices to each individual company, so using Invoice Account is really not an option.

We basically want to build a vendor hierarchy for reporting purposes so that we are able to report DHL as a combined result.

We are ensuring that same vendor is sharing party rec ID in each legal entity, in other words DHL Denmark in legal entity 1 is sharing Party ID with DHL Denmark in legal entity 2. So we should be able to maintain this vendor hierarchy globally.

We have looked a bit on the relationship tab in the global address book on the party record. Cant find much information about this, anybody has any knowledge about this and could share any documentation and thoughts on other ways to solve it?

We are thinking that PowerBi would be a great way to use to create the report once we have found the solution to create the relationship.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Camilla,

In the global address book you can setup relationships among your vendors.

Ex: Party A is child of Party B, etc.

This information can then be used for creating a BI report.

The relationship feature in the global address book provides a lot of flexibility but it also requires a lot of effort to set it up and maintain it.

Personally, I would rather go for a separate findim that allows you configuring the relationships. That's easier and faster and allows you making use of the financial reports in D365Fo. Maybe that can be an alternative?!

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Ludwig, that is exactly what we looking at. Any documentation that you know of available on the GAB relationship? We have only been able to find very little information on this.

Was this reply helpful? Yes No
Suggested answer

MM-20051452-0 on at

Like (0)

Report

Hi Camilla,

You can find more details here regarding Global Address Book docs.microsoft.com/.../overview-global-address-book.

However, in your scenario D365 does not allow to have same Party ID to multiple vendors created in the same legal entity. So, I would recommend to use the default field and can be used for reporting also on Vendor account card.

Regards,

Momen Mansour

Was this reply helpful? Yes No