Hi there,
I need to prepare an expense report for audit purpose included order & payment details.
I know Purchase Order links to Bill and Bill Payments which contains the information.
But I don't know how to make a report to include those detail in terms of Bill Payments list.
Auditor needs only the purchase order and settlement date relationship.
My thought is use a saved search to list all Bill Payment and retrieve Purchase order number and date. But I can't success to make such saved search.
I also tried to use suiteanalytics to build more same report but also failed to combine required data in single result.
The fields I need is the following:
- Purchase Order No.
- Vendor name
- Currency
- PO date
- Settlement Date (from Bill payment)
- Exchange rate
- settlement status (from Bill payment)
- Settlement amount (from Bill payment)
- SETTLE by accounts (from Bill payment)
- Memo (from Bill payment)
Please let me know if you encounter similar issue and have a solution.
Thank you.
Regards, kf