Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

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

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,115 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans