My requirement is for vendor 122 within certain period for certain ekorg-c100
and D100 show different amount.
is it possible for vendor aging report.
I developed a vendor aging report for displaying comp-code, vendor, Pur-org,
Total-amount, month wise amount picking from bsik-dmbtr.
I added a field EKORG ( Pur Org ) from lfm1 table with D100 and C100.
And total amount for vendor 122 for a period from 01.01.2009 to 09.09.2009 is 5000/- Rs.
when a new P.O. is crated using Ekorg C100 of amount 2000/-.
My problem is :
After execution of report for same vendor 122 with ekorg c100.
Then it shouid show 7000/- Rs.
And After execution of report for same vendor 122 with ekorg D100.
Then it shouid show 5000/- Rs.
My report is showing same amount in both d100 and c100.
My report is showing same amount 7000/- in D100 and C100 for vendor 122.
Amount picking Bsik table has not ekorg field.
Please let me know how can i do that ?