Supplier Contribution Report

Epicor ERP 10
,
1

My Supplier Manager approached me yesterday, wanting to know if I could figure out a way to provide him a report that shows each supplier that contributed to a final product. So if we have a job for a final product of ComponentX, and ComponentX is constituted of 10 subcomponents, each of which may contain additional subcomponents, which may contain additional subcomp…you get the idea.

Each of those (sub)components has material that is provided by a vendor/supplier. What he is looking for is something that breaks down each component all the way down to the lowest level in our system, and provide the supplier for each material. IE:

  • TopLevel - ComponentX
    • SubComponen1
      • VendorA
    • SubComponent2
      • VendorB
    • SubComponent3
      • SubSubComponent1
        • VendorC
    • SubComponent4
      • VendorD

Something to that extent. Are there any reports that currently do something like this that I am overlooking, or am I going to need to start something from scratch for this?

2

Sounds like you could start with the BOM Listing report and then add on supplier information if you have approved suppliers/supplier price lists set up in the system.

If you want to create a more custom report, you can create an indented BOM BAQ and then do the same thing, adding the vendor for purchased components. There are a few threads on here about creating that BAQ.