Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

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

Posted on by 1,337

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

  • Muhammad Yousaf Profile Picture
    Muhammad Yousaf 1,337 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
    Muhammad Yousaf 1,337 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
    Ludwig Reinhard 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
    qianwang 7,151 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans