aging report not picking write data

[former_member630092]

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 ?

[dipak_kumar3]

Hi,

Your query text contains too many puzzaling words.

Make it simple so that we understand this.

To cut it short what is your base for calculating all this?

Is it only details or it involves invoice data too.

I would prefer you refer only FI data the tables would be BSEG and BKPF & BSIS.

Join can be done with PO tables too.

Look for invoices postings through EKBE table.

Hope it will help you,

Regards,

Dipak

[former_member630092]

Thanks for replying. I am sending more info regarding my object.

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 to show purchase organization wise amount for particular vendor and amount ?

tables , lfa1, lfm1, bsik.

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.

Report is working fine for displaying Purchase organization.

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 ?

[former_member630092]

Hi,

Same vendor code is linked to diferent Purchase Organizations

Say V123 is linked to C100 and D100.

Is it possible to create differereat vendors code for different Purchase Organizations to keep track of amount related activity done by vendor using particular Purchase Organization.

[former_member630092]

Hi

My doubt is regarding Vendors in different organizations .

(1) Vendor and Purchase Organization should be one to one mapping ???.

means : One vendoe in one Purchase organization ???.

(2) Can a vendor be related to more than one Purchase Organizations ???

Acyually in my situation one vendor code is linked to two purchase organizations ?

Thanks

[former_member630092]

Hi any documentation on vendor and Purchase Organization relation link ?

1) Vendor <----

---

> Pur Org

2) Vendor <----

---

> Pur Org1

<----

---

>Pur Org2

which one is correct ?

[former_member630092]

Hi MM experts ,

My question is still not answered...

i gone through SAP help documentation, but on vendor and Purchase Organization relation link was found ?

vendoe and Purchase Organization should be one-to-one ?

1) Vendor <----

---

> Pur Org

and same vendor code can be assigned to Many purchase Organizations ?

2) Vendor <----

---

> Pur Org1

<----

---

>Pur Org2

which one is correct and ?

[former_member630092]

Hi experts

What is the relationship b/w Vendor & Purchase organization ?

[former_member630092]

My requirement is for vendor 122 within certain period for certain ekorg-c100

and D100 show different amount.

C100 and D100 has diffetent amount.

my report is showing same amount.

is it possible for vendor aging report. ?

Thankswhethe the picking of amount from C100 and D100 is possible in vendor aging report ?

Thanks