cancel
Showing results for 
Search instead for 
Did you mean: 

# Of transactions in a Payment Run

former_member196697
Participant
0 Kudos

Hi Experts,

This has been puzzling me.  I currently have the need to put the total number of tranactions within a payment run to show up on a report to send to our client's bank.  Ideally I would like to put it in crystal report, the only problem is I don't know which table to reference this number off of? I've attached an image of what I'm talking about.  How would convey the total number of Transactions within a specific payment run?

Accepted Solutions (1)

Accepted Solutions (1)

jitin_chawla
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

Check this if it helps you :

select count(t1.pymnum) as 'Number of Payment in Payment Run',

t0.wizardname as 'Payment Run Name', t0.idnumber as 'Payment Run ID'

from OPWZ t0

inner join PWZ4 t1 on t1.identry  = t0.idnumber

group by t0.wizardname, t0.idnumber

Kind Regards,

Jitin

SAP Business One Forum Team

former_member196697
Participant
0 Kudos

This worked perfectly, thank you

Answers (0)