Skip to Content
avatar image
Former Member

query for item master data

hi all,

i want to create a query for items in the item master data that shows the changed field, the old value, the new value, user name and the date it was changed .

can anyone help please.

ciao

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 30, 2008 at 10:30 PM

    When you are on the Item Master..Select the Item.. Go To Tools > Change Log

    Highlight any two rows and click on Show differences..this will display old value and new value with the Field Names

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 30, 2008 at 10:28 PM

    Hi,

    Any specific reson you require a query as you can get the same results from the Tools > Change Log in the Main Menu when the Item Master Data window is active.

    The Change Log Report displays the changes made field wise and the date when done it done and by which user.

    You can also check the changes made between two instances as well nu Show Differences pushbox.

    Regards,

    Jitin

    Add comment
    10|10000 characters needed characters exceeded