web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Vendor Invoice Report ...
Small and medium business | Business Central, N...
Suggested answer

Vendor Invoice Report w/GL No.

(0) ShareShare
ReportReport
Posted on by jamisoncaudill

Hello,

I'm looking for a report which shows all the vendor invoices entered and has, at least, the vendor name, invoice amount and the GL no. each invoice was posted to. I see report which show the vendors and total amounts charged but I would like to be able to filter on which GL no. each invoice hits.

Thanks!

Jamison

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Vendor Invoice Report w/GL No.

    Jamison,

    Most Vendor reports point the the Vendor Ledger Entry so you get all the information except the G/L Account it posted too. You might consider creating this in Jet Report or if you do not have Jet ask your Partner to take a standard report and add the G/L Account to it. The only other report that might help is a G/L Register report filtered by Source Code PURCHASES.

    Hope this helps.

    Thanks,

    Steve

  • Suggested answer
    Tabrez Ajaz Profile Picture
    Tabrez Ajaz 785 on at
    RE: Vendor Invoice Report w/GL No.

    Hi Jamison,

    For this purpose, you must have to ask your ERP Partner to add G/L Account No. to the existing standard report or create a new one from scratch with all the information you needed, if you don't want to spend time and money on this then the quickest way that you can use is, write SQL Script if you are using Business Central On-Prem otherwise create a report by your own using Power BI Desktop (it's free) or Jet Reports(if you have).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,750

#2
Sumit Singh Profile Picture

Sumit Singh 2,689

#3
YUN ZHU Profile Picture

YUN ZHU 1,987 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans