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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Vendor Statement as a ledger with Debit Credit entries and with balance

(0) ShareShare
ReportReport
Posted on by 1,339

Hi All,

Please note that i have a requirement, where my finance team is asking for a report for vendors and customers. Which must show the transactions just like 

Accounts payable/Common/Vendors/All vendors -> where we can select a vendor and go to Transactions....  so whatever result is produced - they want this into a report

The same transactions must be in a report and each line must show as a Debit or Credit entry and it must end with The Balance till that entry

Regards

Yousaf

I have the same question (0)
  • qianwang Profile Picture
    7,168 on at

    Hi Muhammad,

    Do you want the report that same as transaction record in Vendor transactions form?

    If so, I have not found a report that meets your all requirements right out of the box. Did you try to export the vendor transaction to excel and then process it.

    Regards,

    QianQW

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Muhammad Yousaf,

    This can be setup in the management reporter provided that you have a findim for your vendors that is posted with your transactions.

    If you have that everything works out of the box including the drill down into the individual vouchers.

    Best regards,

    Ludwig

  • Muhammad Yousaf Profile Picture
    1,339 on at

    I tried this already, but the Debit and Credit entries are appearing in only one colum, you have to separate it Manually

    Regards

    Yousaf

  • Muhammad Yousaf Profile Picture
    1,339 on at

    Hi Ludwig

    I have management reorter configured, will you guide me with the rest of the process

    Regards

    Yousaf

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans