account payable trail balence problem

an invoice was booked in 'X' month and payment for the same has been done in 'y' month.when i am running account payable trail balence for 'X' month i can not see that transaction in that report
But when i am running trail balence report for 'Y'month i can see that transaction .
how can i resolve this

No it should happen the other way around. Suppose you create an invoice in SEP then you can see it SEP period trial balance...for that matter any period after that till you make the payment
Once the payment is done the report won’t be visible in trial balance...

AP trial balance report name is a misnomer it should AP Liability report as it shows only liability and used for AP-GL liability reconciliation

Oracle Applications Fusion Cloud - Inventory

Oracle Cloud/Fusion Procurement training will help you develop the fundamental skills required to set up and use the Procurement module. This training covers all the tasks, setups, forms and reports used in Procurement and related modules