Can you get a report of all the vendors linked to a pay to vendor?

(0) Share

Report

Posted on by Community Member

We have several companies that all are linked to one pay to vendor. I was wondering if it is possible to print off a report that shows all the companies that is linked to that vendor?

We have Microsoft Dynamics NAV 2013.

*This post is locked for comments

All responses (9)

Answers (1)

Suggested answer

Indikauk 1,759 on at

Like (0)

Report

RE: Can you get a report of all the vendors linked to a pay to vendor?

Hi Office2733

1. go to the Vendor List Report from Department -> Purchase -> Report & Analysis refer to the attached screenshot for help

2. as highlighted int he Steps 3 you need to add the additional filter filed for "Pay-to Vendor No."

when you click on Add filter it will open the field list available in the vendor table and from that, you need to go to additional fields and from that, you can find the "Pay-to Vendor No." field select the field. refer below screenshot for more information.

3. once the field brings you need to select the "Vendor No." what you have filled as "Pay-to Vendor No." and generate the report you will see all the vendors linked with Pay to vendor no you selected on the filter see below screenshot how to select the Pay-to vendor no. from the list of vendors.

Hope This will help to slove your problem.

Thanks

Indika.
Community Member on at

Like (0)

Report

RE: Can you get a report of all the vendors linked to a pay to vendor?

Thank you very much. I have managed to get it done this time.
Verified answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: Can you get a report of all the vendors linked to a pay to vendor?

1) Type Vendors in Search

2) Filter on Pay to Vendor No --> Enter the Pay to company No

You will get list of all vendors associated with Pay to vendor no
Community Member on at

Like (0)

Report

RE: Can you get a report of all the vendors linked to a pay to vendor?

I'm really sorry about this but can you please do step by step instructions. I cannot seem to understand what to do. Is it the pay to company I'm searching or one of the other companies?
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: Can you get a report of all the vendors linked to a pay to vendor?

It will be list and from that list you can directly export to excel
Community Member on at

Like (0)

Report

RE: Can you get a report of all the vendors linked to a pay to vendor?

Does this produce a list or report?
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: Can you get a report of all the vendors linked to a pay to vendor?

Go to Vendor Card and search in vendor name for specified companies and then check Pay to vendor no
Community Member on at

Like (0)

Report

RE: Can you get a report of all the vendors linked to a pay to vendor?

Can you please tell me how I find out if the companies are set up as "buy from vendor". Also where is the vendor table?

Thanks,
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: Can you get a report of all the vendors linked to a pay to vendor?

You can get all the information from Vendor table assuming that ll companies are created as Buy from vendor and all pay vendor is attached to those vendor