Skip to main content

Notifications

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

How to export vendor payment vouchers/list by payment method?

(0) ShareShare
ReportReport
Posted on by 5

On Dynamics GP, we were able to use smartlists to get an export of all payment vouchers with payment method information on them. How do we do the same in BC or is there any report that can show us the total amounts paid by payment method in a particular date period?

Basically, something that gives us:

Payment Method  Amount
Bank 1000
Check 2000
Card 1040
Paypal 3910

Some reports give the list of payments made in a particular date range, but the payment method code is missing on those.

Thanks

  • Suggested answer
    Francisco Bedolla Profile Picture
    Francisco Bedolla 1,117 on at
    RE: How to export vendor payment vouchers/list by payment method?

    Well, you´re right about the "disappearing" payment method.

    If you arent using the Reason Code Field, you can add it in the payment and cash receipt journals, create reason codes suitables for every payment option and use them in the journals

    pastedimage1658884136060v1.png

    the in the bank ledger entry add the reason code field in the bank ledger

    pastedimage1658884186056v2.png 

    works for both, payables and receivables. Now, you can copy and paste or open the excel sheet 

    or using powerbi to create a analysis view

    pastedimage1658886372037v3.png

    and later, you can publish that definition to the powerbi in the cloud and add it to BC again

    pastedimage1658886523116v4.png

    pastedimage1658886570023v5.png

    yes, a lot of work thanks to the "disappearing payment method code field"

    HTH

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

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans