We are building a custom report based on the Standard Uninvoiced Receipt Accrual Report
in Expenses
Summary:
We are building a custom report based on the Standard Uninvoiced Receipt Accrual Report, and we need to include additional receipt‑related fields such as Receipt Number, Receipt Creation Date, and Receipt Aging.
However, we are unable to identify the correct Fusion Procurement and Payables tables and the appropriate join conditions that link:
- PO receipt information
- Receiving transactions
- Invoice distributions
Can you help us understand how to join invoice details with receipt details, so that we can extract the required receipt attributes for our custom report?
We specifically need guidance on:
- The tables that store receipt number and receipt creation date
Tagged:
0