Which interface tables are used for Invoice Import , give
the important columns?
Answer / ritesh gakher
Interface Tables are:
AP_INVOICES_INTERFACE
Important Columns are:
INVOICE_ID, GL_DATE, INVOICE_AMOUNT, INVOICE_DATE,
INVOICE_NUM, INVOICE_TYPE_LOOKUP_CODE, ORG_ID, TERMS_ID,
VENDOR_ID, VENDOR_SITE_ID, ACCTS_PAY_CODE_COMBINATION_ID
AP_INVOICE_LINES_INTERFACE
Important Columns are:
INVOICE_ID, INVOICE_LINE_ID, LINE_TYPE_LOOKUP_CODE,
LINE_NUMBER, AMOUNT, ACCOUNTING_DATE,
DIST_CODE_COMBINATION_ID, ORG_ID
| Is This Answer Correct ? | 10 Yes | 0 No |
what is the difference between conversion,customization,inbound and outbound programs ?
What is the use of pay group in AP?
How many key flexfields are there in Payables?
what is the difference between initial mass copy and periodic mass copy?
1 Answers BirlaSoft, Cap Gemini, IBM,
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 .
Hi Friends i Completed my M.Com in 2007 From Osmania University I learn Oracle Financials. Can i get the job offers as a fresher? I have only year exp. in C.A. Firm so can i get the job? Plz send me suggistions. Thanks Dear friends.
i have defined currency rates for the month of june translation purpose and june period is opened but in translation form i have seen periods from july why it happend could u please explain
i am trying to raise transaction in AR , item is not select this work bench, i am trying to different supplier, i am face that again same problem . pls send me my problem.
1)What cannot be consolidated in GCS? 2) When you setup calendar in GL is it possible to change it?
What is 2 way , 3 way and 4 way matching?
12 Answers Chartered Accountant, HCL, IBM, MNC, Shell, TCS,
in mass addition normally there is an interface that runs from AP to add the items into FA...when does this process occur..is it during the month end after AP closing & is it an automated process.. Is it possible to run any interface in the middle of the month if u want to populate one specific item from AP
please tell whether invoice(dummy) can be split and paid to different suppliers