Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Tuesday, June 21, 2011

ORACLE PAYABLES

1st setup

MOAC - Multi Org Access Control
In 11i, you can access only one OU from one Responsibility, while in R12, you can access multiple OU's from one reponsibility.

Create your multi org heirarchy.
N : HRMS > Security > Profile

Specify the OU's that your want to use from a single Payables Resposbility.

You need to a program ' Security List Maintenance' program and slect your profile in the parameter.

Create you own responsibility and attached MO: Security Proflie

Attach the reposponsibility to your user

You have to define your FINANCIAL OPTIONS

N > Payables > Setup > Options > Financial Options

Next step is to define your PAYABLES OPTION

N > Payables > Setup > Options > Payables Options

OU2
Invoice Dist 01.NY.12000


Dr 02.NY.LIAB
Cr 01.WDC.EXP

Enables Auto Offset to 'Balancing'
Dr 01.NY.LIAB Chaging 02 to 01
Cr 01.WDC.EXP


Enables Auto Offset to 'Account'
Dr 01.WDC.LIAB Chaging 02 to 01 and other segments also
Cr 01.WDC.EXP

ENTER SUPPLIERS

To create a new supplier
N > Payables > Supplier > Entry


In standard receipt, two entried will be passed, one at receeipt creation and another at delivery

In Direct delivery, one one entry will be passed, i.e. on receipt and deliver


Matching -

Supplier ABC Corp

PO Qty 100 Pen
Rate 2
TOTAL 200

Receive Qty 95
Rate 2
Total Receipt Value 190

Inspect Qty 92
Rate 2
Total Receipt Value 184

AP Invoice Qty 100
Rate 2
Total Receipt Value 200


2 way matching System matches AP Invoice with the PO
AP Invoice Qty 100
Rate 2
Total Invocie Value 200

3 way matching System matches AP Invoice with the PO and with Receipt
AP Invoice Qty 95
Rate 2
Total Invocie Value 190

4 way matching System matches AP Invoice with the PO , with Receipt and with Inspection
AP Invoice Qty 92
Rate 2
Total Invocie Value 184

Define PAYMENT TERMS

N > Setup > Invoice > Payment Terms


Define DISTRIBUTION SET

N > Setup > Invoice > Distribution Set

Define Hold and Release

N > Setup > Invoice > Hold and Release

expense report template

N > Setup > Invoice > Expense Report Template

YR-RI-1000

Recurring Invoice

N > Invoice > Entry > Recurring Invoice

01-000-5221-0000-000 - Dr

01-000-2210-0000-000 - Cr

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect