cancel
Showing results for 
Search instead for 
Did you mean: 

report on payment check info

Former Member
0 Kudos

hi experts.

iam developing a report based on below requirement.

extract vendor master file and A/P transaction file for 4 fiscal years ( 2004-2008) for all company codes. include bith active and inactive vendors in vendor file and both paid and unpaid transactions in transaction file

so iam geting the closed items from BSAK . based on getting

payment and check information from PAYR and REGUP tables . openitems iam getting from BSIK.

with above logic from from BSAK iam getting more data (so many records for each vendor) i dnt want to include all the records.i want just payment transaction for each invoice.

please tell me how can i filter the data.how can i write the logic for it?

thanks in advance.

regards

niru

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

As you are only looking for payment document from BSAK, you may filter BSAK document based on document type.. Usually, the document type for vendor payment is ZP but check in your system which document type is set up for outgoing payment document.

Regards,

Chirag