Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Benjamin Baxter]

Up

0

Down

::

I don’t think there is a base report that will get you everything you need. For example, the “Item/Vendor Catalog” Report you mentioned is pulling from the “Vendor Item Catalog” table, without picking up the Default Vendor defined on the Item Card itself. This means Items only purchased from a single Vendor, defined on the Item Card only, would not appear on the report.

You could write an Extension to populate the Vendor Item Catalog table when you add the Default Vendor to the Item, this way the entry exists in both places and would allow the “Item/Vendor Catalog” report to properly display all Vendors.

Now that we have the data updating with what we need, the next change would be to redesign the “Item/Vendor Catalog” report to group by Item and not by Vendor, thus giving you a list of all the Vendors that can be used to requisition the Item.

Sorry, I don’t know a stock report for this, but with some quick extensions you’d be able to make it happen.

Best Regards,

Ben Baxter – Accent Software Inc

[Chris Warren]

Up

0

Down

::

This could be accomplished pretty easily in Jet Reports. I’d suggest looking at this add-on as it’s great for creating your own reports from BC data.

If you do have Jet, I’d be happy to create a sample report and send it to you to connect with your environment.

[Jessie Sanger-Picard]

Up

0

Down

::

if you open any item card, then go to Navigate->Purchases->Vendors.

you can clear the filter for a full list and send that to excel. from there you can manipulate the way you want it.

[Chris Warren]

Up

0

Down

::

This is an awesome tip. I just showed this to our Supply Chain Director and she wanted me to thank you!

[Cliff McDaniel]

Up

0

Down

::

Great tip. We should save some time on one of our chapter meetings to give a summary of tips and tricks learned from the discussion board? Just a thought.

[Jessie Sanger-Picard]

Up

0

Down

::

lol, thank you both 🙂

[Kim Dallefeld, MVP]

Up

0

Down

::

Great idea Jessie, this works in so many places!