What are the tables associated with Invoice?
Answer Posted / rajesh
RA_CUSTOMER_TRX_ALL -- It stores invoice,debit memo
,commitment,bills receivable and credit memo header Info
.Each row in this table includes information such as
customer,transaction type and printing instructions.
RA_CUSTOMER_TRX_ALL -- It stores information about
invoice,debit memo ,credit memo,bills receivabl and
commitment lines ( LINE ,FREIGHT ,TAX ).
RA_CUST_TRX_LINE_SALESREPS_ALL --- It stores sales credit
assignments for invoice lines.If receivables base your
invoice distributions on sales credits then a mapping
exists between the sales credit assignments in this table
with the RA_CUST_TRX_LINE_GL_DIST_ALL .
RA_CUST_TRX_LINE_GL_DIST_ALL --- It stores the accounting
records for revenue,unearned revenue and unbilled
receivables for each invoice or credit memo line. ORACLE
RECEIVABLES create one row for each invoice or credit memo
line. Each row in this table includes the General Ledger
account and the amount of the accounting entry.
Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
Charge Back Setups ?
Can Adjustments be imported?
HI, once we create the standard invoice then we can get journal entry item expense a/c-dr to liability a.c then item it will reflect through inventory, but liability a/c . it will reflect from GL , it is possible .
What is Reporting of financial data in a project.
How will account an advance of Rs.10000/- which is a permanent prepayment, can I make payment for this?
What do you mean by Category Set ? and what is its Relevance ?
how we can stop the transaction for not transfer to the reporting ledger at the time of entering the transaction in pl
What is the Use of Grouping Rule in Receivables ? is it mandatory field ?
Re: While you are in implemenation what are u faced the issues ? tell me what some ap & GL issues?
SLA usage ans how to define setups?
I have a requirement where during the consolidation into USD (from GBP books) I want use two different exchange rates for two consolidations. Child SOB is same but the Parent SOB's are different. How can this be done in Oracle Financials? Answers will be Appreciable. Thank You.
How do you adjust receivables?
What do you mean by controlling buyers workload?
What is the Process of Reconciliation Between AP to GL
what is the difference between bonus reserve and bonus expense