Purchase Order Log Query

[Former Member]

Hi Experts!

I want to create a query showing the change logs of all Purchase Orders for a particular period. Can anyone create for me a query showing the following fields:

1. PO Document Number

2. PO Date

3. Update Date

4. Suppliers Name

5. Log Instance

6. Changed Field

7. Old Value

8. New Value

9. User Name

The parameter would be a date range for the PO date.

Your immediate response would be of great help.

Warm regards,

Jen

[Former Member · Accepted solution]

Hi Jen,

If you want all the details you can find under menu Tools_Change Log-> Show Differences. You cannot write query for Changed Field, Old Value, New Value but you want except these three refer below mentioned query you need required some changes as per your requirement.

select po.Docnum,po.docdate,po.updatedate,po.cardname,

ap1.loginstanc,ousr.user_Code,ousr.U_name

from opor po

inner join por1 po1 on po.docentry=po1.docentry

inner join adoc apo on po.objtype=apo.objtype and po.docentry=apo.docentry and po.updatedate=apo.updatedate

inner join ado1 ap1 on po1.objtype=ap1.objtype and po1.docentry=ap1.docentry and po1.linenum=ap1.linenum

inner join ousr on po.usersign=userid

Thanks

Sachin