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 :
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)
  • Muhammad Yousaf Profile Picture
    1,339 on at
    RE: Vendor Statement as a ledger with Debit Credit entries and with balance

    Hi Ludwig

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

    Regards

    Yousaf

  • Muhammad Yousaf Profile Picture
    1,339 on at
    RE: Vendor Statement as a ledger with Debit Credit entries and with balance

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

    Regards

    Yousaf

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Vendor Statement as a ledger with Debit Credit entries and with balance

    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

  • qianwang Profile Picture
    7,168 on at
    RE: Vendor Statement as a ledger with Debit Credit entries and with balance

    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

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 878 User Group Leader

#2
André Arnaud de Calavon Profile Picture

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

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 765

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans