Interested to Buy Any Domain ? << Click Here >> for more details...
What are the tables associated with Invoice in AP?
- 4 Answers
- 35971 Views
- I also Faced
- E-Mail Answers
Answer Posted / altaf a shaikh
When a Invoice is created basically following tables are
populated :-
1. AP_INVOICES_ALL -- Invoice Header Information
2. AP_INVOICE_DISTRUBUTIONS_ALL -- Line details
3. AP_PAYMENT_SCHEDULES_ALL -- When term is assigned
while creating invoice then automatically Payment schedule
is create based on term (e.g 30 Net)
4. AP_TERMS_ALL
5. AP_DISTRIBUTION_SETS_ALL -- If You select distribution
set to create Invoice Lines Automatically for You.
---------------------------------------------------------
When You Approve the Invoice then MATCH_STATUS_FLAG of
AP_INVOICE_DISTRIBUTION_LINES is updated to T.
when You Account Invoice then Following Tables are
popullated :-
These below mentioned tables store data for Invoice as well
as payments so please check source of the transaction
created in these tables.
There are two columns in lines table whcih can be used to
track these transactions in GL Module. That are
gl_sl_link_id and gl_transfer_flag = Y
6. AP_ACCOUNTING_EVENTS_ALL
7. AP_AE_HEADERS_ALL
8. AP_AE_LINES_ALL
Once "Paybles Transfer to Gl concurrent" program is
executed then, all the accounted enteries with
gl_transfer_flag <> Y will be populated in GL_INTERFACE
table.
If Journal Import with Source = Payables is executed then
data is populated in
GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES
Then Posting populates this data into
GL_BALANCES
[If there are 25 lines in a GL_JE_LINES for a particular
CCID in a month DEC-09.
Then only one line is created in GL_BALANCES table for that
particular CCID in DEC-09. This lines has sum of amount of
all the 25 lines of GL_JE_LINES)
When You Make a Payment for a Invoice then following tables
are populated :-
9. AP_CHECKS_ALL
10. AP_INVOICE_PAYMENTS_ALL
When You do accounting of payment then again accounting
tables are populated as specified above i.e.
6. AP_ACCOUNTING_EVENTS_ALL
7. AP_AE_HEADERS_ALL
8. AP_AE_LINES_ALL
Remaining process is same as discussed above.
In this case Journal Source = Payment
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
can any one tell me what exactly functional consultant do on daily basis? client requirements?
Explain about Localization (IND & US ) in Oracle Apps ?
how service tax work.
Substitute receipts and Unordered Receipts
I am currently working in reputed Org as a Oracle apps end user (AR). Learned R12 functional course, but no real time exp as in support or implementation project.Please guide. thank you.
What is gap analysis, how do you defined?
How do write a discoverer report to identify zero dollar suppliers/invoices where the supplier is on hold?
What is gap analysis, what are the pre-requisities?
Please post the setups required to approve the payable invoice in AP.
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.
Do you track and record relationships between customers e.g. franchises, subsidiaries etc.?
On what different real time issues you worked while doing P2P cycle implementation?
What is multi org? What is difference between 11i and 12i multi org structure?
What is difference between primary and secondary ledger
How do u bridge the gaps in functional understanding of AP,GL,FA. explain with some live examples.
