Skip to Content
0
Former Member
May 22, 2010 at 01:01 AM

Purchase Order Log Query

345 Views

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