$$

FUSION ACCOUNTS PAYABLES

ENTERPRISE STRUCTURE (BG IN R12)

 Create Enterprise (we can create 1 enterprise for 1 instance).
 Create Business Unit Locations
 Create Reference Data Sets (Hold * while doing payment terms)
 Create Business Units
 Assign Business Unit Functions to Business Unit
 Create Legislative Data Group (BG in R12 – Country Specific)
 Assign Legislative Data Group to LE
 Create Employee User
 Assign Implementation Consultant Roles to User
 Create Procurement Agents

Create Enterprise:
 In FSM in search bar %Enterprise HCM% click on go to task icon and click on Edit  click on
Correct
 Name: Orc Fusion Enterprise
 Status: Active
 Worker Number Generation: Automatic
 Allow Employment Terms Override Assignment: NO
 Click on submit  Yes.

Create Business Unit Location:

 Go to Implementation project in task bar %Manage Location% Click on go to task icon.
 Click on create
 Name: Orc Location
 Code: Orc Loc
 Country: United States
 Address: Saint Joe
 City: Atlanta
 State: Georgia
 Zip Code: 123458
 Click on submit  Yes  Done.

Create Business Unit:

 Go to Implementation project in task bar %Manage Business Unit% Click on go to task icon.
 Click on + icon to create
 Name: Orc US BU
 Location: Orc Location
 Manager: Optional Field – we assign branch manager

Fusion Accounts Payables Page 1

 $$

 Default Set: Common Set

 Click on Save and Close  Done
Note:
In AR when you are doing customer refund this will not work if we don’t give location (treating it as
optional).

Assign Business Unit Functions to Business Unit:

 Purchase invoice, billing, payment, customer payments (Procurement, project billing) are
business functions and these need to be assigned to BU. What are all the business functions that
need to be assigned to BU.?
 Go to Implementation project in task bar %Assign BU Business Function% Click on go to task
icon.
 BU: select BU and click on Apply and go to task.
 Enable required options which are as below.
 Enable Billing and Revenue Management
 Enable Collections Management
 Enable Customer Contract Management
 Enable Customer Payments
 Enable Expense Management
 Enable Materials Management
 Enable Payables Invoicing
 Enable Payables Payment
 Enable Procurement
 Enable Requisitioning
 PL: Orc PL
 LE: Orc LE
 Click on Save and Close.
Note:
You may enable all options because if you forget any one it may not allow while doing AP. To avoid this
we can select all options.

Create Legislative Data Group:

 From home page of FSM in search bar %Manage Legislative Data Groups% click on go to task
icon.
 Click on + to create new
 Name: Orc USA Legislative Data Group
 Country: USA
 Currency: USD

Assign Legislative Data Group to LE:

Fusion Accounts Payables Page 2

 $$

 From home page of FSM in search bar %Legal Entity HCM% click on go to task icon.
 Click on create HCM Information in Spreadsheet.
 An excel sheet will open click on Yes.
 Navigator  Tools  Download ADF Desktop Integrator  Double click on
setup.exe (used to download required file)
 An excel file will open, click on home click on Excel Options  Click on Trust
Center – Trust Center Settings  Go to Macro Settings  Enable Trust Access to
the VBA project object model; Enable all macros  Click on Ok
 You can fill date in excel sheet
 Legal Entity Identifier: OLE458555855
 Associated Legislative Data Group: Orc US Legislative Data Group
 Salary Level: Terms
 Row Inserted Successfully  Done.

Create Employee User in R11 (Create from HCM):

 Click on Navigator  Under My Team – click on Manage Users.
 Click on + to create
 Last Name: Fin
 Email: 123@abc.ocm
 Hire Date:
 User Name: Fin
 Person Type: (these come under Abstract Roles) Employee
 Legal Employer: Select LE
 Business Unit: Orc BU
 Click on Save and Close.
 Go to IDM (Manage Job Roles in search bar)  Open our User  Reset Password
 Click on Roles  Click on Assign to assign below roles
 IT Security Manager
 Application Implementation Consultant
 Employee
 GL related roles (5 roles)
Create Employee User in R12 & 13
Select ProjectGo to Task-Manage Users
 Click on + to create
 Last Name: Fin
 Email: 123@abc.ocm
 Hire Date:
 User Name: Fin
 Person Type: (these come under Abstract Roles) Employee
 Legal Employer: Select LE
 Business Unit: Orc BU

Fusion Accounts Payables Page 3

 $$

 Click on Save and Close.

Add Roles to user
 Goto Navigator—Tools---Security Console
Find Employee User
 Click on Add Role—Go to Search bar Add Roles like
 Application Implementation Consultant For Functional Setups (Select and Click on Add
Role Member Ship)
 IT Security Manager---For User Creation (Select and Click on Add Role Member Ship)
 Employee – For Reports Generation (Select and Click on Add Role Member Ship)
Buyer--(Select and Click on Add Role Member Ship)
General Job Ledger Roles
General Accountant--(Select and Click on Add Role Member Ship)
General Accounting Manager--(Select and Click on Add Role Member Ship)
Chief Financial Officer--(Select and Click on Add Role Member Ship)
Controller--(Select and Click on Add Role Member Ship)
Financial Analyst --(Select and Click on Add Role Member Ship)
Accounts Payable Job Roles
Accounts Payable Manager--(Select and Click on Add Role Member Ship)
Accounts Payable Specialist--(Select and Click on Add Role Member Ship)
Accounts Payable supervisor--(Select and Click on Add Role Member Ship)

 Click on Save and Close.

 Run LDAP from scheduled processes.

Create Procurement Agent:

 This is equal to buyer (Purchasing) in EBS R12. We can classify employee user as procurement
user.
 Only HCM user can create a procurement agent.
 Go to our project  Assign our project to New HCM User with help of EDIT option.
 In Task bar %Manage Procurement Agent% click on go to task icon.
 BU: select Orc BU  Apply and Go To Task icon.
 Click on + icon to create.
 Procurement BU: Orc BU
 Agent: Select our HCM user
 Default Requisitioning BU: Orc BU
 Default Printer: Optional
 Status: Active
 Enable all Agent Access. You can also select as per business requirements  Save and
Close.

Fusion Accounts Payables Page 4

 $$

 Click on Done.

FUSION ACCOUNTS PAYABLES SETUP’S

 Common Options for Payables and Procurement (= to Financials options in EBS)
 Invoice Options Configuration (Financials Options)
 Payment Options Configuration (this point & above = to Payable Options in EBS)
 Create Reference Data Sets
 Create Payment Terms
 Create Reference Data Set to BU
 Create Distribution Sets
 Specify Suppliers Number Generation Options
 Assign Supplier Roles to User
 Create Supplier
 Create Supplier Addresses
 Create Supplier Sites
 Assigning Supplier Sites to Procurement Business Units
 Create Banks
 Create Branches
 Create Bank Accounts
 Create Payable Documents
 Create Check Books
 Create Payment Method
 Create Payment Process Profile
 Create Payables Lookup Values
 Introduction to Payables Role Templates
 Assigning Data Roles to User
 Submitting LDAP Job
 Opening AP Periods

Common Options for Payables and Procurement:

 Create all mandatory accounts in our COA to add this step. This is BU level setup (BU Specific)
 In our project  in task bar %manage Common options for Payables & procurement% click on
go to task
 Liability: select code combination
 Prepayment: select code combination
 Bills Payable: select code combination
 Conversion Rave Variance Gain: select code combination
 Conversion Rave Variance Gain: select code combination
 Discount Taken: select code combination
 Realized Gain Distribution: select code combination
 Realized Loss Distribution: select code combination

Fusion Accounts Payables Page 5

 $$

 Click on Save and Close.

Invoice Options Configuration:

 In our project  in task bar % manage Invoice options % click on go to task
 BU: Orc BU  Click on Apply & Go to Task icon
 Payment Priority: 99
 Payment Terms:
 Terms Date Basis:
 Pay Date Basis:
 Accounting Date Basis:
 Budge Date Basis:
 Payment Terms: Immediate
 Note: Allow Online Validation is Automated (no need to enable)
 Click on Save and Close  Done

Payment Options Configuration:

 In our project  in task bar % Payment Invoice options % click on go to task
 Click on Save and Close (no changes)  Done

Create Reference Data Sets:

 This is used to setup data sharing.
 Payment Term1  Assign to Reference Data Set BU1  Assign to BU1 (then only it works)
 Payment Term1  Assign to Reference Data Set BU1 & BU3  Assign to BU1 & BU3 (then only
it works)
 PT 1, 2, 3  Assign to Common Set  Assign to BU
 Go to our project  In task bar %business unit%  click on our BU go to task icon.
 Select our BU & Click on EDIT
 Name: Common set (default). We can overwrite this from other place (can see in below
step).
Note: If you want to use reference data set, in invoice options for payment terms also we should change
reference data set then only it works.
 Go to our project  In task bar %reference data set%  click on go to task icon (its mandatory
field).
 Click on create + icon
 Set Code: Orc_US_BU
 Set Name: Orc US BU Set
 Click on Save and Close.

Create Payment Terms:

 Go to our project  In task bar %payment terms%  click on go to task icon
 Click on + icon to create our payment terms.
 Name: Orc Net 30

Fusion Accounts Payables Page 6

 $$

 From Date: 1-2-3

 In installments click on + to add Due: 100 % - Days 30
 In discount fill as per business requirement.
 In Set Assignments click on + icon to create – select Orc US BU Set
 Click on Save and Close.
 Click on Immediate  EDIT
 In Set Assignments click on + icon and select our ORc US BU
 Click on Save and Close.

Assign Reference Date Set to BU:

 Go to our project  In task bar %Manage BU Set Assignments%  click on go to task icon
 Select our BU  Apply & Go to task – find our BU
 Select Payables Payment Terms – Select Orc US BU Set
 Click on Save and Close.
Note:
If you want to create for all BU’s we need to create reference data set & assign to all BU’s. This logic is
similar to Data Access Set in GL

Create Distribution Sets: (BU Specific)

 Go to our project  In task bar %Distribution Sets%  click on go to task icon
 Click on + icon to create.
 Business Unit: Orc US BU
 Name: Expense
 Distribution Percentage: 100% (as per requirement)
 Line: 1 – Distribution: 100% - Distribution Combination: Select Code Combination
 Click on Save and Close
Note: Reference Data Set is not applicable to Distribution Set because of below:
 Distribution set is assigned with code combination
 When accounting comes in to picture we have to restrict by LE & other by security of
menu/BSV’s.

Specify up Suppliers Number Generation Options (Payable system setup in EBS R12):
 Go to our project  In task bar %specify supplier Numbering%  click on go to task icon
 Next Supplier Number: Enter Desired Number (Mandatory in Fresh Instance).
 Click on Save and Close.

Assign Supplier Role to User:

 Go to IDM/Create Implementation Users  Administration  Select our user  click on Roles
tab
 Click on Assign  Search with %supplier%  Select Supplier Administrator to last role  Click
on Add.

Fusion Accounts Payables Page 7

 $$

 Run LDAP from scheduled process.

Create Supplier:
 Click on Navigator  under procurement click on Create Supplier.
 Click on task icon on right top  click on Create Supplier.
 Supplier: Orc Supplier
 Business Relationship: Spend Authorized (Prospective – we can’t create invoice)
 Tax Organization Type: corporation
 Click on Create.
 Click on Addresses tab & click on + icon to create new address
 Address Name: Orc Supplier Address
 Country: USA
 Address: Orc Supplier Address
 City: Texas
 State: TX
 Postal Code: 77844
 Make sure ordering and Remit to are enabled
 Click on payments tab
 Click on check option on click on right mark to set as default.
 Click on Save and Close.

Create Supplier Site:

 Continuation on above step  Click on Sites tab.
 Click on + icon to create site
 Procurement BU: Orc US BU
 Address Name: Orc Supplier Address
 Site: Orc Site1 – click on Save
 Click on Payments tab – here check will be defaulted.
 Click on Site Assignments tab & click on + icon to add
 Client BU: Orc US BU
 Bill to BU: Orc US BU
 Click on Save and Close.  go to Manage suppliers to view our suppliers
Note:
 In R12 Liability & prepayment account are mandatory & it available at Financial Options
 In Fusion Liability & prepayment accounts are optional (info at common options for Payables &
procurement).

Create Bank, Branch, Account & Payment Document:

 Go to our project, in task bar %Manage Bank%  click on go to task icon.
 Click on + icon to create
 Country: USA
 Bank Name: RBS Orc

Fusion Accounts Payables Page 8

 $$

 We can provide Address & Contacts  Click on Save and Close

 Select our bank and click on create branch.
 Bank: RBS Bank
 Country: USA
 Branch Name: Orc Branch
 Click on Save and Close
 Click on Bank Accounts
 Click on + icon to create new bank account
 Brank Branch: Orc Branch
 Account Name: Orc RBS Account
 Account Number: 123456789
 Currency: USD
 Legal Entity Name: Orc LE
 Enable check box for Payables & Receivables
 Provide cash and cash clearing account
 Scroll down and under the Payment Documents click on + icon to create
 Payment Document: Orc Check
 Paper Stock Type: Blank Stock
 First Available Document Number: 1
 Last Available Document Number: 1000
 Format: Standard Check Format
 Under checkbooks click on + icon to add check book number.
 Click on Ok.
 Click on Business Unit Access tab  click on + icon to add
 Business Unit: Orc BU  click on ok
 Click on Save and Close.

Create Payment Method:

At time to bills payable we will do it

Create Payment Process Profile:

 Go to our project, in task bar %PPP%  click on go to task icon  click on + icon
 Name: Orc Payment Process Profile
 Code: Orc PPP
 From Date:
 Payment File Format: Standard Check Format
 Process Type: Printed
 In Usage Rule if you select any BU it is restricted only to that BU.
 Click on Save and Close.

Create Payables Lookup Values:

Pending

Fusion Accounts Payables Page 9

 $$

Introduction to Payable Role Templates:

 In homepage in search bar %manage duties% click on go to task icon it will redirect to APM
 In Application Roles select Role Templates  %Payables% click on the folder.
 Click on External Roles & we can see 3 roles of Payables
 Accounts Payable Supervisor
 Accounts Payable Specialist
 Accounts Payable Manager
 System will create roles with our user ex: Orc Accounts Payable Supervisor (check from
Summary tab)
 Go to Task

Manage Data Access for Users in R12 & 13

 Click on Create

 Set Combination of User,Job Role Security Context and security Context Value Click on Save
and Close.
General Ledger Roles Mapping

User Name Role Security Context Security Context Value

Royal General Accountant Data Access Set Royal Primary Ledger
Royal General Accounting Data Access Set Royal Primary Ledger
Manager
Royal Chief Financial Officer Data Access Set Royal Primary Ledger
Royal Financial Analysit Data Access Set Royal Primary Ledger
Royal Controller Data Access Set Royal Primary Ledger

Accounts Payables
User Name Role Security Text Security Context Value
Royal Accounts Payable Business Unit Royal Business Unit
Manager
Royal Accounts Payable Business Unit Royal Business Unit
Supervisor
Royal Accounts Payable Business Unit Royal Business Unit
Specialist

 Click on save and Clouse.

 Run LDAL Program

 Go to Navigator-Click on More-Tools-Schedule Process

Fusion Accounts Payables Page 10

 $$

Assign Data Roles to User & Run LDAP in R11:

 Go to IDM and open our user  Click on Roles tab  click on assign to add roles
 Add 2 roles of Orc AP Supervisor, Specialist & Manager
 Go to Scheduled Processes and run LDAP program.

Open AP Periods:
 Click on navigator  Under Payables click on invoices – It will direct to Invoice Workbench 
click on task panel icon  click on Manage Accounting Periods  Select our PL – Open first
period.
 Click on Action tab & click on Open Target Period – click on required period & click on open
(periods will open until that period)  Click on Done.

INVOICES
Standard Invoice Creation
 Click on navigator  Under Payables click on invoices – It will direct to Invoice Workbench.
 Click on Task Panel & click on create invoice
 BU: Orc BU
 Supplier: Orc Supplier
 Supplier Site: Orc Supplier Site
 LE: Orc US LE
 Number: 1
 Amount: USD 20,000
 Type: Standard
 Date: 8-9-2017
 Payment Terms: Immediate
 Terms Date:
 Attachments: if you want to attachment you can
 Click on show more in Header level to view more information.
 Invoice Group: If you need you can write a name – optional
 Line Level & Distribution – Fill the amount & account
 Amount: 25,000; Distribution Set: xyz; Distribution Combination: select code
combination.
 Click on line 1 & click on Distribution tab to view the respective account.
 Click on Invoice Actions  Click on Validate  Click on Post to Ledger = to Final Post in R12
(Account in Draft = to Draft mode in R12).  click on View accounting to see accounts.
 Click on Invoice Actions and click on Pay in Full –
 Bank Account: Orc Bank
 PPP: Orc PPP
 Payment Document: Orc Check
 Payment Number: 1 – click on Submit

Fusion Accounts Payables Page 11

 $$

 Click on Invoice Actions & Click on Manage Installments – Here payment method – check is
defaulted. If you need to change you can change.
Note: To make payment create accounting is not mandatory. You can pay after validating.

Invoice creation via Spreadsheet (ADFdi)

This is similar to Web ADI (Application Desktop Integrator) in R12 and used only in GL. This is ADFdi
(Application Desktop Framework Data Integrator) in Fusion and used in every module.
 Download ADFdi
 Enable Excel Options
 Create Invoices in Spread Sheet
 Import Invoices in to AP
Download ADFdi:
 Goto Navigator  Under Tools click on ADFdi  open the folder  click on setup.exe file to
install
Enable Excel Options:
 Open excel  Home – Excel options  Trust Center – Trust Center Settings  Macro Settings –
Enable all Macros & check in Trust access to the VBA project object model  ok.
Create Invoices In Spreadsheet:
 In Invoice workbench – In tasks click on create invoices in spreadsheet.
 Click on Connect (before this close all excel files)  enter credentials to login
 Fill all the star fields which are mandatory. You can enter N number of invoices.
 To enter distribution set we can select 1st cell & right click and click on Unhide.
 Click on Save and Submit. You can see Row Status as Row Inserted.
 You can fill info like BU; Invoice Group; click on submit.
Import Invoices to AP:
 Go to invoice workbench  Refresh & we can see new invoice; select it and click on Validate &
Post to Ledger.
 Open invoice and make payment. Also click on recent to view latest invoices within 24 hours.

DEBIT MEMO INVOICE

Definition: When we want to decrease the supplier liability in case of purchase returns we use this.
 Create Standard Invoice for 10,000
 Create Debit Memo for -2,000 (negative sign)
 Make Payment – select standard invoice & debit memo so payment will be for 8,000.

Create Standard Invoice: Follow standard process for creating Invoice - 10000
Create Debit Memo:
Same invoice process – Select Type as Debit Memo – Amount – 3000
In Match Invoice Lines – Select “Correct Unmatched Invoices”  click on go  select invoice of 10k
Enable correct & Amount -3000  Click on Apply  Click on Ok  Validate  Create Accounting
Make Payment:

Fusion Accounts Payables Page 12

 $$

 Click on Navigator  Click on Payments under Payables  click on Task Icon & click on
Payments.
 Fill info for BU; Supplier; Supplier Site; Payment Date; Type; Bank Account; Payment Method;
PPP; check
 Under Invoice to Pay  click on select & add – select Invoice & DM  Click on Apply  Click on
OK.
 Click on Select & Close

DEBIT MEMO INVOICE

Definition: When we want to decrease the supplier liability other than purchase returns.
 Create Standard Invoice for 5,000
 Create Debit Memo for -2,000 (negative sign)
 Make Payment – select standard invoice & debit memo so payment will be for 8,000.

Create Standard Invoice: Follow standard process for creating Invoice – 5000
Create Credit Memo:
 Same invoice process – Select Type as Credit Memo – Amount – 2000
 In Match Invoice Lines – Select “Correct Unmatched Invoices”  click on go  select invoice of
5k
 Enable correct & Amount -2000 click on Apply  Click on Ok  Validate  Create
Accounting
Make Payment:
 Click on Navigator  Click on Payments under Payables  click on Task Panel & click on
Payments.
 Fill info for BU; Supplier; Supplier Site; Payment Date; Type; Bank Account; Payment Method;
PPP; check
 Under Invoice to Pay  click on select & add – select Invoice & CM  Click on Apply  Click on
OK.
 Click on Select & Close
Note:
 To view Accounting
 Go to Payments workbench and select one line and click on Actions  Click on Post to Ledger 
ok
 You can click on view accounting in Actions Menu.

PREPAYMENT
Definition: Advance give to supplier is treated as prepayment (In R12 supplier/employee is treated as
prepayment). We have Permanent & Temporary prepayment.
 Create Prepayment Invoice 25000
 Payment for Prepayment Invoice 2500
 Create Standard Invoice 25000

Fusion Accounts Payables Page 13

 $$

 Apply Prepayment on Standard Invoice 25000

Create Prepayment Invoice:

Select Type: Prepayment; Payment Terms: Immediate; Enter amount at Line Level.
Click on show more – Apply After (settlement date in R12)  Validate  Create Accounting.
Payment for Prepayment Invoice:
 Click on Navigator  Click on Payments under Payables  click on Task Panel & click on
Payments.
 Fill info for BU; Supplier; Supplier Site; Payment Date; Type; Bank Account; Payment Method;
PPP; check
Create Standard Invoice: create an invoice in standard process
Apply Prepayment on Standard Invoice: After creating invoice  click on Invoice Actions  Click on
Apply or Unapply Prepayments  Select prepayment invoice & click on apply  Click on OK.

CREATING PAYMENT PROCESS REQUEST (PPR)

Definition: With this we can automate payments for multiple invoices or suppliers. Through payment
manager we can apply PPR.
 Create Multiple Invoices
 Create PPR Template
 Submit PPR
Create Multiple Invoices: Create invoices in standard process.
Create PPR Template:
 Go to payment workbench  Click on Navigator  Payables  Payments
 Click on Task Panel  click on create PPR  Click on >> icon  click on + icon to add new
template
 Name: Orc Payment Templates
 Click on Payment & Processing Options tab Bank Account: Orc Bank
 Payment Document: Orc Check
 PPP: Orc Payment Process Profile
 Click on Save and Close
 Click on Done.
Submit Payment Process Request:
Select; Build; Format; Confirm
 Go to payment workbench  Click on Navigator  Payables  Payments
 Click on Task Panel  click on submit PPR
 Name: Orc PPR
 Template: Orc Payment Template
 Pay Through: This is date where due invoices will start automatic payments.
 Click on Task Panel  Manage PPR  Name: Orc PPR and click on search.
 Click on Right Arrow under Action  you can view all the selected invoices; you can
remove any invoices or modify amount.

Fusion Accounts Payables Page 14

 $$

 Click on Resume Payment Process.

 Search with our Orc PPR & click on right arrow icon  Fill printer related info & click ok.
 Search with our Orc PPR & click on right arrow icon  Click on Record Print Status  Click on
Submit (Irreversible Action)  Click on Done.
 Click on Refresh & you can see succeeded.

WITHHOLDING TAX
Definition: If TDS or tax is applicable we will deduct from the invoice & will pay to Tax Authority. In USA
we call TDS as WHT. Holding tax amount and paying remaining to the supplier & the tax is paid to tax
authorities.
 Create Payables Calendar
 Create WHT Authority as Supplier
 Create Tax Codes
 Create Tax Groups
 WHT Options (In R12 Payable Options enabling WHT)
 Assign WHT group to Standard Supplier

Create Payables Calendar:

 Go to our Project  In task bar %Payables Calendars%  Click on Go to Task Icon.
 Click on + icon to create
 Name: Orc WHT
 Calendar Type: General Purpose
 Period Frequency: Monthly
 Start Date: 1-1-2017
 Period Name Format: MM
 Click on Save  Click on Generate Periods  Click on Save
 Click on Add Years tab to add more years.
 Click on Save and Close.
Create WHT Authority as Supplier:
 Navigator  Procurement  Suppliers
 Click on Task Panel and click on Create Supplier
 Supplier: Orc WHT Authority
 Business Relationship: Spend Authorized
 Tax Organization Type: Corporation  Click on Create
 Click on Address Tab & click on + icon to create
 Address Name: WHT Address
 Country: USA
 City: Aaron
 State: KY
 Enable Remit to.
 Click on Save and Close.

Fusion Accounts Payables Page 15

 $$

 Click on Sites tab & click on + icon to create

 Procurement BU: Orc BU
 Address Name: WHT Address
 Site: WHT Site  Enable Pay  Click on Save
 Click on Payments tab  Select check and click on correct icon to default
 Click on Site Assignments  Select Orc BU
 Click on Save and Close
 Click on Profile tab and select Supplier Type as Tax Authority
Create Tax Codes:
 Go to our Project  In task bar %Manage Tax Codes%  Click on Go to Task Icon.
 Click on + icon to create
 BU: Orc BU
 Country: USA
 Tax Regime Code:
 Tax
 Tax Status Code:
 Tax Rate Code: PENDING

BILLS PAYABLES CONFIGURATION & PROCESS

Definition: These are future dated payments. While issuing PDC (Post Dated Checks) we use these bills
payables.
 Provide Bills Payable Account In Common Options for Payables & Procurement
 Create Payment Method For Bills Payables

Provide Bills Payable Account In Common Options for Payables & Procurement:
 Go to our Project  In task bar %Manage Common Options for Payables & Procurement% 
Click on Go to Task Icon.
 In Bills Payable Account – select the account  Click on Save and Close
Create Payment Method For Bills Payables:
 Go to our Project  In task bar %Manage Payment Methods%  Click on Go to Task Icon.
 Click on + icon to create
 Name: Orc Check - Bills
 Code: Bills
 Click on Bills Payable tab & Enable Use Payment method to issue bills payable
 Click on Save and Close  Done
Testing:
 Create an invoice & make payment with future date.
 At time to payments – Click on Invoice Actions and click on Manage Installments  Under
Payment Method select Fusion Check Bills  Click on Save and Close

Fusion Accounts Payables Page 16

 $$

 In Task list click on Create Payment

 Change Payment Method to Fusin Check – Bills. All remaining fields as same as Standard
 Click on Advance tab & in Maturity Date give future date
 Under Invoice to Pay tab click on + icon to add invoice for payment  Save & Close  Done.

PAY ALONE
Definition: If we want to issue one check for one invoice we use this Pay Alone concept.
 Enable Pay Alone at Supplier

Enable Pay Alone at Supplier:

 Go to our Navigator  Under procurement click on Supplier.
 Search with our Supplier & Open
 Click on Profile Details section click on Payment tab & click on Payment Attributes 
click on Payment Specifications & Enable Pay Each Document Alone option  Save
 Click on Address Tab  Click on Edit
 Click on Address Details section click on Payment tab & click on Payment Attributes 
click on Payment Specifications & Enable Pay Each Document Alone option  Save
 Click on Sites Tab and click on EDIT
 Click on Payment tab & click on Payment Attributes  click on Payment Specifications
& Enable Pay Each Document Alone option  Save
Testing:
 Create two invoices with standard process
 Navigator  Payables  Payments  Click on Task list & select Create Payment.
 Try selecting two invoices to pay at a time system will throw an error with PAY ALONE.

FOREIGN CURRENCY INVOICE & PAYMENT

Definition: Create invoice in foreign currency and pay in foreign currency
 Setup Common Options
 Bank Account Level Setup
 Define Daily Rates

Setup Common Options:

 Go to our Project  In task bar %Manage Common Options for Payables & Procurement% 
Click on Go to Task Icon. Fill Realized Gain & Loss accounts; Conversion Rate Type: Corporate.
Bank Account:
 Go to our Project  In task bar %Manage Bank Account%  Click on Go to Task Icon. Search
and open our bank account.
 Under Additional Information section Enable Multicurrency Account  Click on Save and
Close.
Define Daily Rates:

Fusion Accounts Payables Page 17

 $$

 Go to our Project  In task bar %Manage Daily Rates%  Click on Go to Task Icon. Click on
Daily Rates tab  Click on Create in Spreadsheet
 Connect  Provide credentials  Fill all * fields and click on submit
Testing:
 Create invoice in foreign currency. Pay in full for foreign currency and you can see rate.

SUPPLIER MERGE
Definition: When an employee creates same supplier with two different names we need to finalize one
name and can merge in order to avoid duplication. If one supplier acquires another in this case also we
will be merging both the suppliers. Also if supplier having 2 sites & closing 2 nd site we can merge both
the sites as 1.
 Create two suppliers
 Perform Supplier Merge (This is irreversible action)

Create Supplier: create new supplier in standard process

Perform Supplier Merge:
 Go to navigator  Procurement  Suppliers  Click on Task Panel & Click on Supplier Merge
 Click on + icon to add suppliers to merge. In Transfer Options select All Purchase Orders
and Invoices.
 Click on Submit  Click on Yes  Click on Ok.
 You can see the program running under Process section or Scheduled Process
INTEREST INVOICE
Definition: For late payments interest is applicable based on suppliers. For this we will use interest
invoice.
 Configure Invoice Options
 Define Interest Rates
 Set Interest Invoice Option at Supplier

Configure Invoice Options:

 Go to our Project  In task bar %Manage Invoice Options %  Click on Go to Task Icon.
 Under Interest Section – Enable Create Interest Invoice; Minimum Interest Amount: 10$;
Interest Expense Distribution Account: Select A/C
 Click on Save and Close.
Define Interest Rates:
 Go to our Project  In task bar %Manage Interest Rates %  Click on Go to Task Icon.
 Click on + icon to create Interest Rates
 From & to Date & Interest rate
Set Interest Invoice Option at Supplier:
 Go to Navigator  Under Procurement click on supplier  Open our supplier  EDIT
 Click on Sites tab & EIDT  Click on Invoicing tab  Under Terms Create Interest Invoice select
YES.

Fusion Accounts Payables Page 18

 $$

Testing: Create an invoice with past date & pay on current date.

RECURRING INVOICE
Definition: For periodic transactions instead of creating invoices frequently we use this recurring
invoice.
 Create Payables Calendar
 Create Distribution Set
 Create Recurring Invoice Template
 Generate Recurring Invoice

Create Payables Calendar:

 Go to our Project  In task bar %Payables Calendar %  Click on Go to Task Icon  Select BU &
click on Save and Close  Click on + icon to create.
 Name: Orc Recurring
 Description: Orc Recurring
 Calendar Type: General Purpose
 Period Frequency: Monthly
 Periods Per Year: 12
 Start Date: 1/1/17
 Period Format: MMM
 Click on Generate Periods
 Click on Add Years – 1
 Click on Save and Close
Create Distribution Set: We can use existing distribution set which we created.
Create Recurring Invoice Template:
 Go to Navigator  Payables  Invoices  click on Task Panel  click on Create Recurring
Invoices  Connect & provide credentials.
 Fill all-star fields; Calendar name: Orc Recurring; From & to Period; Select Distribution
set (In R12 it is mandatory & fusion not mandatory)  Click on Generate.
 Go to Invoices workbench & check for newly created invoices – Open; Validate & Create
Accounting.

THIRD PARTY PAYMENTS

Definition: Buying something from a supplier and making payment to other party (collection agent) on
request of our supplier.
 Create One More Supplier (Collection Agent for our supplier)
 Create Relationship
 Invoice Options
 Payment Options

Create Supplier:

Fusion Accounts Payables Page 19

 $$

 Go to Navigator  Procurement  Supplier  Click on Task Panel and click on Create Supplier
 Follow Standard Process  Create Address & Site  Payments Check as default  Site
Assignments add our site.
Create Relationship:
 Open Our Supplier  click on Sites  click on Invoicing tab – Under Third Party Relationship
click on + icon to add new supplier; select address; set from date; set this as default.
Invoice Option: (To change third party selection at Invoice level)
 Go to our Project  In Task Bar %Invoice Options%  Click on Go to task icon  Enable Remit
to supplier override for third party payments.  Click on Save and Close
Payment Options: (To change third party selection at Payment level)
 Go to our Project  In Task Bar %Payment Options%  Click on Go to task icon  Enable Allow
Payee Override for third party payments.  Click on Save and Close
Testing: Create Invoice with Supplier X and make payment to party Y (as we selected default in
relationship tab – collection agent supplier will default in payment).

CROSS CURRENCY PAYMENTS

Definition: Invoice created in one currency and payment is made in other currency (In 11i & R12 this
doesn’t work).
 Invoice Options (Not Mandatory – To set as default we use this)
 Supplier Site (Not Mandatory – To set as default we use this)
 Bank Account
 Daily Rates

Invoice Options: (These are BU Level Options)

 Go to our Project  In task bar %Invoice Options%  Click on Go to Task icon  Set Invoice
currency as USD & Payment Currency as INR  Click on Save and Close
Supplier Site:
 Open Our Supplier  click on Sites tab & Click on Invoicing tab  Set Invoice currency as USD &
Payment Currency as INR.  Click on Save & Close.
Bank Account:
 Go to our Project  In Task bar %Bank Account%  Click on Go to task icon  click on EDIT 
Enable Multi Currency Account
Daily Rate:
 Go to our Project  In task bar %Manage Daily Rates%  Click on Go to Task Icon. Click on
Daily Rates tab  Click on Create in Spreadsheet
 Connect  Provide credentials  Fill all * fields and click on submit
Testing: Create Invoice in INR & make payment in USD (for making payment use MANUAL PAYMENT –
not Pay in full)

SECURITY PROFILE / MOAC CONFIGURATION & TESTING

Fusion Accounts Payables Page 20

 $$

Definition (This is MOAC in R12): We can group multiple Business Units with single user through this
security profile option. In R12 we have security profile & Global Security Profile (for within OU & Across
oU’s) however, in Fusion we have only one security profile.
 Create Organization Security Profile
 Create Organization Data Role (Assigning Security profile to Job Roles (assigning security profile
to responsibility in R12))
 Create User
 Assign Data Role to User
 Run LDAP Job
Note:
 Data Roles = Responsibility (In R12)
 Security Profile  Responsibility  User (R12)
 Create Security Profile  Data Roles  User (Fusion)
Create Organization Security Profile (HCM Related Task):
 Search from FSM home screen task bar %Manage Organization Security Profile%  Click on that
& click on +icon to create new one.
 Name: Orc 1 BU Security Profile
 Enable Secure by Organization Classification
 Click on + icon to add classification Name: Business Unit
 Enable Secure by Organization List
 Click on + icon to add Organization: Orc BU
 Click on Save and Close
Create Organization Data Role (Security profile----------Assign--- Job Roles):
 From FSM home screen (outside our project as we don’t have HCM) %Manage Data Role and
Security Profiles%  click on the task  Click on + icon to create
 Data Role: Orc1 BU Data Role
 Job Role: AP Supervisor  Click on Next
 Person Security Profile: Create new; Name: Orc BU; Enable Secure by Business Unit 
click on Next.
 Under Workforce Structure: Select Orc 1BU Security Profile  Click on Next  Review
 Click on Submit  Click on Done.
Create User: Create User through IDM with standard process.
Assign Data Role to User: Click on Roles tab and click on Assign and add Orc 1BU Security Profile
Run LDAP Job: Run LDAP job from scheduled processes.

CREATE PAYABLES LOOKUP VALUES

Definition: We can group multiple suppliers based on their nature. Say we can create one group for all
foreign suppliers/government suppliers. Pay group is part of lookup values.
 Go to Setup & Maintenance  In search bar %Manage Payables Lookup%  Click on Go to task
icon (we can do this from our project or from FSM Homepage).

Fusion Accounts Payables Page 21

 $$

 Lookup Type: Pay Group & search  Click on + icon to create new row under Financials Generic
Lookup Type  Lookup Code: Orc Foreign; Reference Data Set: Common Set; Meaning: Orc
Foreign Suppliers.
 Click on Save  Click on Done.
 Go to Supplier & open our supplier  Click on Invoicing tab & assign pay group
 While making payment for invoice you can see the pay group  Go to Task panel & click on
submit PPR  Under pay group check in Specific & select our pay group.

PAYMENT FORMATS
Introduction: In EBS we don’t modify this only technical team do this.
 Create Template
 Create Format
 Select Format for Documents
 Create Payment Process Profile
Create Template:
 Login to URL: https://rws-fsp0712-fs.oracledemos.com/xmlpserver - bold word should be added
to URL  Click on catalog
 Expand Shared Folder  Expand Financials  Select Payments (you can see all formats)
select Disbursement Payment File Formats (Don’t modify it is seeded one) – click on More 
Customize – then the copy will be stored in Customer Folder (under shared folder you can find
custom folder  Financials  Payments) you can see the user name also
 Click on EDIT  you can see all seeded templates – click on Standard Check  EDIT  System
will download RTF (Rich Text Format), save it.
 Click on + icon to create(Changes are done by BI team)  Click on Upload or Generate Layout 
 Layout Name: Orc Bank Check Layout
 Template File: Upload RTF file

Fusion Accounts Payables Page 22

 $$

 Type: RTF Template

 Locate: English USA  Upload  Save Report  View List – To view our format 
select PDF format & save.
Create Format:
 Go to our Project  In task bar %Manage Formats%  Click on Go to Task Icon  Select Type:
Disbursement Payment File Format Click on Create.
 Name: Orc Bank Check Format
 Code: Orc_Bank_Check
 BI Publisher Template: Orc Bank Check Layout
 Click on Save & Close  Done
Select Format for Documents:
 Go to our Project  In task bar %Manage Bank Accounts%  Click on Go to Task Icon  Search
for our Bank Account  Click on EDIT  Under Payment Documents, select Orc check and click
on EDIT
 Format: Orc Bank Check Format (which we created)  Okay  Done
Create Payment Process Profile:
 Go to our Project  In task bar %Manage Payment Process Profile%  Click on Go to Task Icon
 Search for our PPP  Click on EDIT 
 Format: Orc Bank Check Format (which we created)  Okay  Done

INVOICE IMAGING SOLUTION

Introduction:
 We need separate license for invoice imaging solution. For this we will have IPM (Imaging &
Process Management) server. TIFF, JPG, PDF, Word – 300 dpi (Pixel Quality) formats are
accepted by IPM server.
 All invoices are scanned & sent to IPM servers in order to get updated in system.
 To access IPM website using email address url would be https://email id/imaging
 Click on Payable Invoice Search
 Click on any invoice & click on update (only certain fields can be modified)
 To Import in to AP: Navigator  Invoices  click on Scanned invoices info led Task Panel 
Import Invoices
 BU: keep blank (sometimes if you mention it will not work)
 PL: Orc PL
 Source: Invoice Image
 You will also have scanned image of invoice in the attachment for reference.
 You can validate  create accounting.
 Raise SR to Oracle(If client subscribes for AP he will receive an email id for Payables Invoice,
same with other modules)

Fusion Accounts Payables Page 23

 $$

 Mail ID for Payables Invoice

 Mail ID for I Expense

Fusion Accounts Payables Page 24