discoverer report(Invoice amount-tds amount=check)

Here you can post the Business Intelligence (BI) related queries and replies.
Post Reply
phanigajarao
Posts: 33
Joined: Sat Mar 29, 2008 10:08 am
Location: India

discoverer report(Invoice amount-tds amount=check)

Post by phanigajarao »

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)
siva sankar
Posts: 130
Joined: Sun Mar 11, 2007 1:47 am
Location: India

Post by siva sankar »

Hi,

Please try from from this table:

select * from JAI_AP_TDS_PAYMENTS

Thanks & Regards,

Siva
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest