Main Invoice Vs AWT Invoice - Link
Hi all,
We are using R12.1.2.
The objective is to extract Un-Paid Tax Invoices against Paid Invoice of any specific supplier.
There is a link b/w main invoice (manually created against respective supplier) and respective auto generated withholding tax invoice against the same. One link is of Invoice_ID. As the Invoice # of Tax Invoice is created with the reference of Invoice_ID of main Invoice (i.e. Withholding Tax - Invoice_ID - x). The link is fine.
We are facing issue to write query for the said link while making a customized report. So, we need if there is any other reference link & better if available on Invoice Workbench form. Or please provide a sample query to get objective.
We are using R12.1.2.
The objective is to extract Un-Paid Tax Invoices against Paid Invoice of any specific supplier.
There is a link b/w main invoice (manually created against respective supplier) and respective auto generated withholding tax invoice against the same. One link is of Invoice_ID. As the Invoice # of Tax Invoice is created with the reference of Invoice_ID of main Invoice (i.e. Withholding Tax - Invoice_ID - x). The link is fine.
We are facing issue to write query for the said link while making a customized report. So, we need if there is any other reference link & better if available on Invoice Workbench form. Or please provide a sample query to get objective.
Tagged:
0