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

(0) Share

Report

Posted on by Kumar Shah

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

All responses (1)

Answers (0)

Suggested answer

Francisco Bedolla 1,117 on at

Like (0)

Report

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

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

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

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

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

HTH