Looking for information/suggestions on a report that will give detail transaction records from the GL20000 & GL30000 and join Workflow GL Batch Approver to the line detail. I am trying to write a view, but I am stuck at getting the BATCH ID for the line detail. Does anyone know if the Batch ID for the JE# is stored anywhere?
Users are wanting the report to show the transaction detail along with the user that posted it and the workflow user that approved that batch.
All suggestions are welcome.
Susan