YTD balances for the AP Accrual account

Summary:

Accrual Reconciliation Detail Report provide uninvoiced receipt detail for period end. Require the same for Year to Date.

Content (please ensure you mask any confidential information):

We are using “On Receipt” accrual for our Inventory Purchases for accruing AP liability at the time of PO Receipt. In our past projects we have used the Accrual Reconciliation Detail Report data for reconciling the AP Accrual account balances from Subledger to GL Balances as part of period end process. This report provides all the details regarding the Receipts that are uninvoiced at period end for the AP Accrual accounts. But the Balance in the report is the Period Activity rather than YTD Balance. How can we get YTD balances for the AP Accrual account from this report or