I'm sure this question has been asked before, but can't find the answer. I have created a transaction detail report for the general ledger by customising and adding fields from the "transactions" field set. The two field sets available are "transactions" and "active account by type". One of the columns is "document number" which picks up the related document id. Since we use PO's and receive against them, we get item reciept numbers (starting with IR) that are associated with the booked transaction value. I also have a "Created from" column where if the IR originated from a PO, the PO number is pulled in. If the transaction line was generated from a Non-PO AP bill, that bill document number is also pulled in as a line, and of course does not have a related PO.in that column.
Is it possible, as I have been unable to find the related field in the list of transaction fields, to also add the vendor bill as a column related to the PO and item receipt ? For clarity, a screen shot of the report I have created, with headers, is attached.
I am good wit creating a formula to pull in this information if I need to
Thank you.