Small and medium business | Business Central, N...

Vendor Payments by invoice

(1) Share

Report

Posted on by AJam

Hi everyone!

I am looking for a report that will give me vendor payments by invoice in excel format. So far I have tried the Vendor Payment Receipts report but when I export this to excel, it comes out formatted and produces a separate tab for each payment (400+ tabs). Is there a way to get this data to export unformatted and consolidated in one report?

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

hi

you need customisation from your partner

DAniele

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (1)

Report

Hi, If you're using the standard export to Excel functionality, unfortunately, this is standard behavior and there's no way to do it other than customize it.

Therefore, the easier way is to use the functions of Excel to merge sheets. I hope the following information can give you some hints.

https://www.ablebits.com/office-addins-blog/consolidate-excel-merge-sheets/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

JohnDanny 10 on at

Like (0)

Report

It sounds like you are using a specific financial management software to generate the vendor payments report. In order to get the data to export unformatted and consolidated in one report, you may need to adjust the export settings or explore different report options within the software.

In addition to the software you are currently using, there are many other financial management software options available that may better suit your needs. One option you could consider is Vybog financial management software, which i have been using for the past 6 months. This software offer different report options and export settings that could better meet your needs.

If you are interested in exploring Vybog financial management software further, you can find more information and access to the software at the following link: https://vybog.com/finma/

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

If you do not want to customize a report you could try to have someone create a SQL query for you that joins the necessary tables and then run that query from Excel.

Then you will get unformatted data into Excel and you can continue to formatting them there.

Was this reply helpful? Yes No