Home » Applications » Oracle Fusion Apps & E-Business Suite » APXTRBAL (oracle finance , Oracle Applications : 11.5.10.2, OS Sun)
APXTRBAL [message #546070] Mon, 05 March 2012 03:26
GoGreen
Messages: 28
Registered: February 2012
Location: Java Island
Junior Member

How to print Account payable Trial balance.if in parameter report "as of date" : 31-DEC-2011, output report not different when as of date : 31-JAN-2012 or 29-FEB-2012.
total amount in 3 period = 2,200.00,

total amount 2,200.00 supposed to 29-FEB-2012. last transfer to gl period feb 2012.

thanks

for example :

Reporting Level : Operating Unit
Reporting Context : 121 - GRT
As of date : 31-DEC-11
Supplier Name : All
Summary report : yes
Negative balances Only : No

Liability Account..................Invoice Amount..........remaining Ammount
--------------------------------------------------------------
121.000.2120001.000.121.00.........1,000.00............1,000.00
121.000.2120002.000.121.00.........1,200.00............1,200.00
=================================================
Total for report...........................2,200.00............2,200.00


Reporting Level : Operating Unit
Reporting Context : 121 - GRT
As of date : 31-JAN-12
Supplier Name : All
Summary report : yes
Negative balances Only : No

Liability Account..................Invoice Amount..........remaining Ammount
--------------------------------------------------------------
121.000.2120001.000.121.00.........1,000.00............1,000.00
121.000.2120002.000.121.00.........1,200.00............1,200.00
=================================================
Total for report...........................2,200.00............2,200.00


Reporting Level : Operating Unit
Reporting Context : 121 - GRT
As of date : 29-FEB-12
Supplier Name : All
Summary report : yes
Negative balances Only : No

Liability Account..................Invoice Amount..........remaining Ammount
--------------------------------------------------------------
121.000.2120001.000.121.00.........1,000.00............1,000.00
121.000.2120002.000.121.00.........1,200.00............1,200.00
=================================================
Total for report...........................2,200.00............2,200.00

query in APXTRBAL.rdf
SELECT &C_SELECT_LE s_legal_entity,
       &C_SELECT_OU s_operating_unit,
       fnd_flex_ext.get_segs('SQLGL','GL#', :p_chart_of_accounts_id, atb.code_combination_id) s_concat_segments,
       SUM(atb.invoice_amount)  s_invoice_amount,
       SUM(atb.remaining_amount) s_remaining_amount 
FROM   &C_ORG_FROM_TABLES,
       ap_trial_bal_gt atb ,
       ap_system_parameters_all asp,
       ap_invoices_all ai
 
WHERE 
      nvl( atb.org_id, -99) = nvl(ai.org_id, -99)
AND    nvl(atb.org_id, -99) = nvl(asp.org_id, -99)
AND    atb.set_of_books_id = :p_set_of_books_id
AND    atb.invoice_id = ai.invoice_id
AND   atb.request_id = :p_conc_request_id
       &C_MULTI_ORG_WHERE
       &P_ORG_WHERE
GROUP BY &C_SELECT_LE,
         &C_SELECT_OU,
       fnd_flex_ext.get_segs('SQLGL','GL#', :p_chart_of_accounts_id, atb.code_combination_id) 



Previous Topic: how can i install oracle forms and report server on windows server 2008 r2 64 bit
Next Topic: FSG YTD Feature
Goto Forum:
  


Current Time: Thu Mar 28 16:02:56 CDT 2024