Announcements
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
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
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156