on 01-31-2008 7:07 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.