E9.2 Supplier Master by Company

[MicheleDG]

Dear all,
as per Q&A document 755938.1 of the Oracle Support, the Supplier Master (P04012) cannot be managed by line of business or company (unlike the Customer Master).
This is a strong limitation as there are many distinctive elements such as different payment terms, methods, default currency, etc. that generate the necessity to proliferate codes in both AB (Address Book) and AP (Accounts Payable) for the same vendor entity.
Our business is asking for a solution to somehow consolidate these AP records perceived as redundant, especially during the record registration process and for reporting.
Has someone ever dealt with this type of request?
How did you manage it? Any advice?

Thank you all in advance.
Michele

 

[markdcci]

Michele,
There are a couple of different options you might want to consider. Probably the easiest is to go ahead and create multiple address book records, each with their own supplier master, and link them together through the parent-child relationship available in the address book. Designate one AB as the parent then assign that parent for the other AB/Supplier Master records. This hierarchy can go for multiple levels. You can assign the balance sheet business unit for each of the children AB records to keep track of which of your companies is associated with child address book numbers.

Alternatively or in addtion to you could use the Factor/Special Payee function. I have worked with clients in the past who have used this but it was more for a third party that was receiving payments in lieu of the supplier (example, a trust). But you would still have to add another AB/Supplier Master record so it might be simpler to just use the parent-child feature.


I have worked with business users that were desparately trying to simplify their address book, as yours probably are, and this solution does not help that. But once they get over the inevitability of having to add more AB records they usually accept the parent-child function and in the past some users have actually used it to their advantage for other purposes such as being able to roll up customers' and suppliers' subsidiaries in reports.

 

[MicheleDG]

Michele,
There are a couple of different options you might want to consider. Probably the easiest is to go ahead and create multiple address book records, each with their own supplier master, and link them together through the parent-child relationship available in the address book. Designate one AB as the parent then assign that parent for the other AB/Supplier Master records. This hierarchy can go for multiple levels. You can assign the balance sheet business unit for each of the children AB records to keep track of which of your companies is associated with child address book numbers.

Alternatively or in addtion to you could use the Factor/Special Payee function. I have worked with clients in the past who have used this but it was more for a third party that was receiving payments in lieu of the supplier (example, a trust). But you would still have to add another AB/Supplier Master record so it might be simpler to just use the parent-child feature.

View attachment 19896
I have worked with business users that were desparately trying to simplify their address book, as yours probably are, and this solution does not help that. But once they get over the inevitability of having to add more AB records they usually accept the parent-child function and in the past some users have actually used it to their advantage for other purposes such as being able to roll up customers' and suppliers' subsidiaries in reports.

Thank you so much for the detailed explanation.