Skip to Content
0
Sep 09, 2009 at 10:09 AM

aging report not picking write data

29 Views

Hi,

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 ?