How to report new master data in place of old master data in a report

[Former Member]

Hi Everyone,

I have 0vendor master data which contains both old and new vendor numbers. I have transaction data that refers to both new and old vendor numbers. In my report I want to see the new vendor numbers with transaction data and new vendor number in place of old vendor number with transaction data. How do I achieve that? Can anyone shed some light on that. I have tried various scenarios but none of them working.

Thanks,

Wen.

[klaus_werner]

HI Wen,

do you mean to say that you need some kind of mapping of old to new vendor numbers? In that case you could create a navigational attribute of the vendor and put in the new vendor number for both new and old numbers and then use this attribute to navigate and display.

Regards, Klaus