What are the tables associated with Invoice in AP?
Answers were Sorted based on User's Feedback
Answer / sunil kardam
There are three Tables getting impacting while you entering the Invoice in System for R11.
1. AP_invoices_all
2. AP_invoice_distributions_all
3. AP_payment_schedules_all
In R12 there are four tables:-
1. AP_invoices_all
2. AP_invoice_lines_all
3. AP_invoice_distributions_all
4. AP_payment_schedules_all
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / bharat
ap_invoices_all
ap_distributions_all
ap_holds_all
ap_interface_rejections
Is This Answer Correct ? | 12 Yes | 3 No |
Answer / 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 |
Answer / altaf a shaikh
When You Approve the Invoice then MATCH_STATUS_FLAG of
AP_INVOICE_DISTRIBUTION_LINES is updated to A instead of T.
T means Tested
A means Approved.
When You check 'Approve' check box then in backend Invoice
is match with PO if there is any discrepency then Invoice
goes to HOLD state.
Is This Answer Correct ? | 3 Yes | 0 No |
Hi, Friends i need some Accounts Payable, General Ledger, Cash Management study material. Please if u have some material kindly send to my id itsaqueelahmed@gmail.com. i will be very thankful to u .
SLA usage ans how to define setups?
Is it possible to change the accounting period during the financial year? For eg change it from 12 to 13 months ?
6. TDS accounting entry
What are the mandatory setups in AP?
What is difference between security rule and cross-validation rule and what is difference between both of?
Write Test Scripts for a telecummunication project on the basis of priority with some examples with regard to AP,GL,FA.
What are the setups in R11i for fund transfer between two bank
Can any one tell me Client Interaction?
What is the purpose of receiving transactions?
what is the difference between initial mass copy and periodic mass copy?
1 Answers BirlaSoft, Cap Gemini, IBM,
It is mandatory to difine Approval Suppliers ?