custom report in AR

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
akumar.oracle
Posts: 195
Joined: Sat May 31, 2008 1:29 pm
Location: India

custom report in AR

Post by akumar.oracle »

Hi

I have requirement to develop a custom report to daily list all the rejected invoices based on the AR interface table.

From what i know

ra_interface_lines_all
ra_interface_sales_credits
ra_interface_distributions

is interface tables for AR but i am not able to figure out how to know which one is rejected invoice? what flag to look at and which table?

cheers
Arvin
Top
oteixeira
Posts: 451
Joined: Wed Aug 27, 2008 12:34 pm
Location: Portugal

Post by oteixeira »

Hello.
INTERFACE_STATUS (from RA_INTERFACE_LINES_ALL)
This column is used by AutoInvoice and should be left null. If AutoInvoice sets this column to ?P? then the line has been transferred successfully.

Octavio
Top
Post Reply

Return to “Financials (GL, AP, AR, FA & CM)”



Who is online

Users browsing this forum: No registered users and 8 guests