ERPstuff - Oracle EBS Community

Posted: **Fri Jun 19, 2009 7:27 am**

Hi,

In ap_invoice_payments_all table AMOUNT column -Ve ,+Ve amounts are coming in one column how to get the saperate columns in discoverer.

EX:-Invoice amount(1000)-tds amount(200)=check amount(800)

Posted: **Fri Jun 19, 2009 11:59 am**

Hi,

Please try from from this table:

select * from JAI_AP_TDS_PAYMENTS

Thanks & Regards,

Siva

ERPstuff - Oracle EBS Community

discoverer report(Invoice amount-tds amount=check)

discoverer report(Invoice amount-tds amount=check)