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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,554
Super User 2024 Season 2
#2
Martin Dráb
228,588
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (