Tables details of Purchase Order Postings

anuprkl
anuprkl Member Posts: 39
edited 2007-10-11 in Dynamics AX
Please tell me the name of the tables get affected during Purchase Order saved through Invoice update.

Thanks
Anup

Comments

  • daxdilip
    daxdilip Member Posts: 1
    Hi Anup,

    These are some options to find the tables getting updated:

    a. Go to Tools->Options->SQL Trace (You can use this to find the tables which are referred in DML statements)

    b.If you know SQL Administration, you can use SQL Profiler to capture the SQL:StmtCompleted events and trace out it to a file and from that you can filter out the tables.



    Thanks and Regards,
    Dilip

Categories