Please find implementation steps with screnshots for Oracle Payables implementation.
You will find these notes practical and useful in you ever want to implement Oracle Payables as a functional consultant.
Please note that in R12 supplier & bank registration screens have changes, however, the overall implementation process remains largely the same. This document has been prepared with real life Payables implementation, hence is very hands-on in nature.
Use link below to download pdf
http://apps2fusion.com/training_demo/ranu/oracle-ap/
Right click on file oracle_payables.pdf and save it to your desktop.
The topics covered in this document are
Setting up Banks
Defining Internal Bank
Payables Options
Defining Payment Documents
Creating Suppliers
Overview of Suppliers
Supplier Information - Control Region
Bank Account Region
Supplier Information - Invoice Tax region
Entering Basic Supplier Site Information
Supplier Site Information - General Region
Supplier Site Information - Tax Reporting region
Supplier Reports
Invoices
Invoice Types
Assigning a Default GL Date
Entering Invoices
Batch Control Form
Invoice Structure
Demo examples
Type of Accounting Flows
Invoice Gateway
Apply & Release Holds on AP invoices
Levels of Invoice Approval
Processing Debit & Credit Memos
Clearing a Credit
Recording a Price Correction
Processing Pre-Payments
Accounting in Oracle Payables
Accounting Events :
Creating Accounting Entries :
Viewing Accounting entries
Overview of Transferring accounting to GL
Reviewing accounting Entries
Implementing Supplier Invoices
Setting Tolerance Levels for invoice Taxes
Setting up invoice payables options
Implementation considerations
Payments
Payment overview
Create a quick Check
Processing Stop Payments
Voiding Payments
Refund
Overview of Payment Batches
Overview of Electronic Payment Options
Pre-Requisites for processing electronic payments
Creating EDI payment batches
Implementing Payments
Payment Terms
Payment Formats
Define Financials Options (Required)
Define Payables Options (Required)
Quick Reference
Comments
I am not able to open the document, tried with both the links given, can you please have a look at it?
Error like 402 - page not found
Thanks a lot for the such a nice document.
Rega rds.
Thanks for this informative doc. on payables. Do you have anything explaining the Suppliers in TCA model. How is this new chnage going to impact conversions from legacy to R12.
Appreciat e your help.
Thanks,
Praveen
Thank you very much for sending such usefull PDF............ It is really very good with alot of Stuff...
Can you please the same functional Document on GL and AR...
looking for Doc's...
Regar ds,
Shiva Prasad B
Ranu has already published GL and AP
AR will be published today or so.
Thanks,
I don't know how to say thanks to both of you.
The Gl and Payables docs are really awesome.
As a technical developer,I can go now as a technofunctiona l guy with these docs.
And one more request also,can you please provide a document similar to these for the purchasing ,if possible only,
this is just a request.
Thank you very Much ! Awesome !!
Is it possible to have PA documentation too
Thanks
Manav
Tha nks for sharing such a wonderful doc. Could you please send us the same for PO and iProcurement.
Thanks & Regards.
Tha nks very much for this document. I am facing one problem in AP. For one of the invoice which is PO matched and unpaid,unvalida ted ,not accounted.
AP Invoice Distribution Reverse Button is disabled. Could please help me out on this
Waiting for your reply
Thanks
Manav
I would like to know, if there is a way to use Letter of Credits (L/Cs) in Oracle Apps? How to make oracle bend for this facility?? Please help!!!
Thanks ,
Mukunthan L
I am working in Oracle apps version 11.5.10.
My requirment is :
I want to create two new Custom Invoice types.
Lets take it as Invoice type 'A' and Invoice type 'B'.
I also want to create a new custom hold lets name it as 'Z'.
I need to apply 'Z' automatically only when invoices of type 'A' is created.
How can i do these settings?
Could you please let me know the navigation path for creating custom hold?
Could ayone help me in this regard?
Regards
Santhosh
would you please let me know - how to set up Supplier Site Information - EDI Region 1) EDI Location and 2) EDI ID number
we are on R12 (12.0.6)
Thank s,
Raj
We are using 11.5.9 oracle payables. we need to setup electronic payment and send to our bank for a specific supplier, how we could it configure.
Tha nks
Aijaz
Does anybody who have worked on similar type of task.
1) What are the setups needs to be done?
2) What type of sample java class file needs to be write for file transmission using $AP_TOP/java/tr ansmission/Bank ClassTemplate.t xt.
3) Please provide me sample class file if anybody has
I have a problem.
Suppose, a supplier has two sites. One of the site is attached to a bank account, where the onther bank account is not attached to none of the site...
So, there are two bank account. One is supplier level another is site level. Now, For a batch payment (In R12 for Payment Process Request), we have a requirement to find out the supplier associated with that batch payment alond with Supplier bank account number.
Now, for Bank account at supplier site level,its not a problem.. Problem occurs for bank account at supplier level. When an invoice is created against that supplier site which is not attached to any bank account, upon payment of that invoice, money should go to default Supplier level bank account.
But, for a bank account at supplier level the corresponding value of column supplier_site_i d will be NULL in table iby_external_pa yees_all table. Now, how could I join an invoice which have a definite vendor_site_id to a Bank account having supplier_site_i d as NULL in table iby_external_pa yees_all.
I am attaching my query herewith.
SELE CT substr(v.NUM_10 99,3,8) ,
UPPER(substr(V. VENDOR_NAME,1,3 0)) ,
ia.INVOICE_NUM ,
TO_CHAR(ch.chec k_date,'YYYYMMD D') ,
LPAD(TO_CHAR(ip .AMOUNT*100),11 ) ,
ieb.bank_accoun t_type ,
DECODE(ieb.bank_accoun t_type, '1', '000', '2', '000', cbbv.branch_num ber),
substr(ieb.bank_account_num,1,3)||DECODE(ieb.bank_accoun t_type,'1','','2','0','3','0')||substr(ieb.bank_account_num,5,length(ieb.bank_account_num)) ,
' ' FLAG ,
' ' FLAG1,
DECODE(v.num_10 99,'20913339',' 20209133394',su bstr(v.num_1099 ,1,11))
FROM
hz_party_sites hps
,apps.iby_external_pa yees_all iep
,apps.iby_pmt_i nstr_uses_all ipi
,apps.iby_ext_b ank_accounts ieb
,apps.ce_bank_b ranches_v cbbv
,ap_invoice_pay ments_all ip
,ap_checks_all ch
,ap_invoices_al l ia
,Po_vendors v
,po_vendor_site s_all vs
WHERE
ieb.branch_id =cbbv.branch_pa rty_id
AND ieb.bank_id = cbbv.bank_party _id
AND ieb.ext_bank_ac count_id = ipi.instrument_ id
AND ipi.ext_pmt_par ty_id = iep.ext_payee_i d
AND cbbv.branch_par ty_id = hps.party_id (+)
--AND iep.supplier_site_i d = vs.vendor_site_ id
AND iep.supplier_site_i d vs.vendor_site_ id
AND iep.supplier_site_i d IS NULL
AND iep.payee_party _id = v.party_id
AND ip.CHECK_ID = ch.CHECK_ID
AND ip.INVOICE_ID = ia.INVOICE_ID
AND ch.VENDOR_ID = v.VENDOR_ID
AND ia.VENDOR_ID = vs.VENDOR_ID
AND ia.VENDOR_SITE_ ID = vs.VENDOR_SITE_ ID
AND ch.AMOUNT > 0
AND ch.CHECKRUN_NAM E = '&1'
AND trunc(SYSDATE) BETWEEN nvl(ipi.start_d ate,SYSDATE-1) AND nvl(ipi.end_dat e,SYSDATE+1)
Is there anything on Oracle Cash Management 11i ?
Regards,
Har shad
Carlo
http://www.fornoamicroonde.org
please send the Oracle payables PDF
thanks
Regar ds
Jeeva.A
RSS feed for comments to this post