Financials for India - EBS (MOSC)

MOSC Banner

Prepayment transactions for TDS eligible invoices - Unable to Link Return TDS Inv and CM

edited Aug 14, 2019 2:41AM in Financials for India - EBS (MOSC) 2 commentsAnswered ✓

When we create a Prepayment type of transaction for a TDS eligible supplier. It creates below 4 transactions:

Standard TDS Invoice

Standard TDS CM

Return TDS invoice

Return TDS CM

I am able to find the link between original Prepayment invoice and Standard TDS Invoice and Standard TDS CM from the TDS table using the below query

select DM_INVOICE_NUM "Standard TDS CM",  TDS_INVOICE_NUM "Standard TDS Invoice"

  from jai_ap_tds_invoices

where 1=1

   and invoice_id = "Invoice ID of prepayment Invoice"

   ;

How and where can I can find the link between the original Prepayment invoice/ Standard TDS Invoice and the related Return TDS Invoice and CM?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center