PO Receipts - extract User ID who Receipted PO
I want to create a report between two Receipt Dates (01/01/2014 to 08/01/2014) showing:-
- User ID of who Receipted
- Receipt Date
- Order Date
- Remark
- Address Number
- Order Co
- Request Date
- Sched Pick
- Original Promised Date
- G/L Date
- Document Number
- Quantity Ordered
- Amount Paid to Date
- Amount Open
- Amount Received
I've had a look at the 'Open Receipts' and 'PO Receipts Inquiry' and both are missing the 'User Name' of who Receipted.
I can extract the data from table F43121 using the data browser but only a handful of users have the data browser, is there a way to extract these fields in a report?