AP Invoice Aging Report by GL Date (using: Accounts Payable Trial Balance)

10-11  Source: Network gathering  Views:20 

Need some suggestions:
I need to develop a custom report in (R12).
Account Payable Trial Balance Report, does have the capability to run as of a particular date but it does not show aging buckets. This custom report is to be developed to meet the requirements from a Payables detail perspective as well as to reconcile.
The report should show the balance due as of the report date selected. If As of Date = 5/31/11, then when the report is run on 6/15/11, it gives the results as it existed on 5/31/11. If we run it again on 8/31/11 for As of Date = 5/31/11, and again on 1/13/12, we get the EXACT SAME results each and every time except for the following fields: Current Status, Date Paid and Payment Reference Number.
The end result should be this report ties to the penny to Oracle GL as of the date selected EXCEPT for any JEs posted to the account.
Hi Pravin,
For all transactions in Oracle, you will have GL dates (Accounting Dates) associated to it. If you use this date in your query to filter data, then you will get correct aging data as on a given date.
To tally with GL, you also must check if the selected transaction has been accounted?
Raajkumar G
Related articles
  • AP Invoice Aging Report by GL Date (using: Accounts Payable Trial Balance) 10-11

    Hi Need some suggestions: I need to develop a custom report in (R12). Account Payable Trial Balance Report, does have the capability to run as of a particular date but it does not show aging buckets. This custom report is to be developed to meet the

  • AP Invoice Aging Report for past date 10-11

    hi guys, I am running R12. my requirement is to run AP invoice aging report for past dates (same like AP Trial Balance Report), but the seeded invoice aging report has no option to do so. would appreciate some help thanks in advance RaviHi Senthil, I

  • Fully Paid invoice is  appearing in "Accounts payable  trial balance" 10-11

    Hi all, i have proble with AP trial balance report.. there is one invoice which is fully paid and accounted. but still that invoice is appearing in trial balance report. invoice amount is 0000000 rmaing amount is (9856568) note: negatinve amoun.. any

  • Accounts Payables Trial balance report error!! 11-30

    Can anybody help me to set right the following problem? it will be greatful if you sort it out. Completion Text: your concurrent request exited abnormally?? Cause: The concurrent program for your request exited without calling standerd application ob

  • Accounts Payables Trial Balance Report 11-30

    Can anyone tell me what report (.rdf) the spawn program APXRTB (Accounts Payables Trial Balance Report)uses. ThanksAccounts Payable Trial Balance Report using APXRTB program to run the Accounts Payable Trail Balance report by Date and Sort by vendor.

  • R12(Payments)--Accounts Payable Trial Balance Report, Need Info. 10-11

    Hi All, We are trying to use the report Accounts Payable Trial Balance Report. This is an XML Report in R12 now and has 4 different RTF Templates. Can you please explain me how this report can be used in R12 and how does it selects the RTF template(

  • Accounts Payable Trial Balance Report does not include a Credit Memo amount 10-11

    Hello Experts,                     We are having an issue with Ap Trial Balance report not displaying a credit memo amount whereas Gl Balance shows that amount. The Credit Memo has a August invoice date and September pay date but it's not showing up

  • R12 Accounts Payable Trial balance is reporting incorrectly (urgent) 11-30

    the trial balance is reporting penny amounts on invoices that are fully paid how do I correct this issueFollow the below steps and Run the Trial Blance and let me know if it helps. Thanks Girish How to Rebuild Trial Balance Data (repopulate XLA_TRIAL

  • Accounts Payable Trial Balance in R-12 report rows don't balance 10-11

    Hi, Background: I am in a municipal government using encumbrance accounting in R-12. In 11i the AP Trial Balance (APTB) always balanced line for line when comparing the ORIGINAL AMOUNT to the AMOUNT REMAINING. This is not always the case in R-12. In

  • Accounts Payable Trial Balance Report 10-11

    My client would like to modify the seeded AP trial balance templates. Rather than starting from scratch, I would like to take a copy of the existing aptbrpt04.rtf template and create a new one based on it. My problem is that when I download the templ

  • Accounts Payable Trail Balance Report Supplier Sitewise 10-11

    Hi, I want to customized Accounts Payable Trial Balance report in AP. This concurrent program source is JAVA. How to customized this report to get the Trial Balance based on the Supplier Site. If customization is not possible, can anyone let me know

  • New Parameter As Of Date (Period) In Invoice Aging Report   Doc ID:752120.1 10-11

    Hi Hussein, EBS R12 (12.0.6) Rhel 4.6 How do I apply this kind of patch? Solution This is Enhancement Request 70091 ADD PARAMETER TO RUN INVOICE AGING REPORT AS OF A CERTAIN DATE Thanks a lotHi, Looks like the patch is not released yet. Please log a

  • Need to convert AP Invoice Aging Report in Excel format 10-11

    Hi, Need to convert AP Invoice Aging Report in excel format..there was an existing Invoice Aging report in AP and that was in paper format. That we need to convert to rtf template.. There was an other concurrent program called 'Invoice Aging Report (

  • Why invoice aging report only display invoice remaining amount? 10-11

    I setup aging period 0~30, 31~60,61~90,90~9999. When I submit invoice aging report,Only Remaining Amount Display. The period column-label is null and the value is zero. Why?sounds like intented functionality. Are you using the correct version and not

  • AR Aging Report by Due Date 10-11

    Hello: I did the OB transfer from another database. I transferred all the invoices by due date. After the transfer I tried to run an aging report. The aging report does not show the AR by age. I just see the total. Any help to resolve this will be mu

  • (Invoice aging report =   Cash Requirement Report) 10-11

    hi, The total balance for cash requirement report for specific supplier not match with the balance for Invoice aging Report also for specific supplier The expected behavior: It must to match the balance between the two reports (Invoice aging report =

  • Ap --Invoice Aging Report    aging period 0-360 periods 10-11

    we need to increase the aging report by 0-360 here i am diving like 0-30 31-60 61-90 91-120 121-150 151-180 181-210 211-240 241-270 271-300 301-330 331-360 The standard layout prints only 4 periods , we want to print all the above periods in output.

  • AP Invoice Aging Report in BI Apps 10-11

    Hi All, I am working with BI Apps ( Financial Analytic) In AP DAshboard, we have AP Invoice Aging report. In this report 1-30, 31-60, 61-90 and 91+ Aging Buckets are available. I want all 365 days like 1-30, 31-60, 61-90, 91-120,121-150,151-1

  • Stock Aging report with current date 10-11

    Dear Experts Can we able to take stock aging report with current date? Thanks&Regards, Vinoth Raj KYou're posting in the Portuguese B1 space. You might want to post in the English one: SAP Business One ApplicationRead other 2 answers

  • AR aging report--from transaction date 10-11

    Hi Presently the 7/4 bucket aging report shows current and invoices no of days past due i.e. 31 days due past due date. Is there a report or any way by which this aging report can be generated to show aging from transaction date. Thanks NinadHi ninad