Skip to content

oracleappshelp.com

Node.JS Blogs

  • MongoDB
  • Oracle R12
  • SOA Suite 12c
  • ADF 12c
  • Interview Questions
  • Node.js
  • ReactJS

Oracle Account Payables Recurring Invoice Creation

» Oracle Apps » AP- Account Payables » Oracle Account Payables Recurring Invoice Creation

Categories

  • ADF Issues
  • Angular JS
  • AP- Account Payables
  • Architecture
  • cloud computing
  • Databases
  • Devops
  • FA – Fixed Assets
  • Interview Questions
  • Java
  • Java Basics
  • Java Springs
  • JavaScript
  • JDeveloper
  • MongoDB tutorial
  • Node.js tutorial
  • OM- Order Managment
  • Oracle ADF
  • Oracle Apps
  • Oracle General Ledger
  • Oracle Receivables
  • Oracle SOA
  • ReactJS Tutorial
  • SQL Server
  • System Administrator
  • WebLogic
  • XML Tutorial

Popular Tutorials

  • MongoDB
  • Oracle R12
  • SOA Suite 12c
  • ADF 12c
  • Interview Questions
  • Node.js
  • ReactJS

Pages

  • MongoDB Tutorial for beginners
  • Oracle ADF 12c Tutorials for beginners
  • Oracle EBS R12 Tutorials
  • Oracle SOA Suite 12c Tutorials for beginners
  • React JS Programming Tutorial for beginners
  • RSS Feed
  • Style Components in React JS

Oracle Account Payables Recurring Invoice Creation

19 Jan 2021 oracleappsadmin

The blog provides the Recurring Invoice Creation Steps in Oracle Account Payables module. Oracle EBS R12 Account Payables provides the functionality to manage the periodic expenses like monthly rent. Oracle Account Payables Recurring Invoice Creation Process requires the creation of Recurring Invoice Template which is to be used for creating recurring invoices. 

Points to Consider for Creating Recurring Invoices

Recurring Invoices Prerequisite Description
Define Calendar and Term Dates Define the Calendar for setting up the Frequency for recurring invoices like once a week or twice a month.
When Account Payables creates the recurring invoices, it creates the Invoice Date and Invoice Due Date which is created from Term Date Basis setting at Supplier Site.
If Term Date is System Date, then Invoice Date and Term Date is the date of when recurring invoice is created, else Term Date is is the first date of the period in which the recurring invoice is created
Purchase OrdersPurchase Orders can be used for Recurring Invoices but requires the below points to be considered
Match Option: The Recurring Invoices requires the Purchase Order Matching to avoid invoice creation conflicts. The Match Approval levels can be defined as 2-way, 3-way or 4-way matching
Purchase Order Attributes: The Recurring Invoices retrieves the Purchase Order(PO) attributes like Tax fields, Order Shipment and line amount when more than 1 distribution lines are mapped for single invoice line.
Quantity: If the Purchase Order (PO) order shipment or invoice item is quantity based, then Quantity is derived from Calculated Tax Amount Divided by Item Price
Blanket Purchase Orders: It is recommender to maintain Blanket Purchase Revision Number when Recurring Invoices are creating using templates
Distribution SetsDefine the Distribution Set for Default Accounts, distribution and line description if Purchase Order(PO) is not used with recurring invoices.
Payment AttributesPayment Attributes like Payment priority, payment method, remit to bank account, bank charge bearer , payment reason and comments , delivery channel used in recurring invoices can be defined on the Supplier Site or can be entered in the Recurring Invoice Template
Withholding Tax The Withholding Tax values are retrieved from Template if Withholding Tax Group is defined else retrieves from Supplier Site if defined at Invoice Validation or Payment
1099 ReportingThe Recurring Invoice retrieves Income Tax Type from Supplier Site when Supplier is defined as 1099 Reportable
Document SequencingRefer the Document Sequencing for recurring invoices from Document Sequencing profile option as automatic

Define Calendar for Payable Recurring Invoices

Perform the below steps for Defining Recurring Invoice Calendar

  • Navigate to Payables -> Setup -> Calendar -> Special Calendar
  • Select Calendar Type as Recurring Invoices
  • Enter the Calendar Name (Monthly) to be used
  • Enter the Calendar Description (Optional)
  • Enter Periods Per Year ( Enter 12 for Monthly Recurrence, Enter 2 for Half yearly Recurrence, Enter 24 for Half Monthly Recurrence)
  • Enter the Period Name ( JAN-2021 is for Monthly Period)
  • Enter the Fiscal Year (2021)
  • Period Sequence gets populated automatically for Recurring Invoice Sequence
  • Enter From Date and To Date are system generated
  • Due Date is system generated

Create Recurring Invoices Template in Account Payables

Perform the below steps for Creating Recurring Invoice in Account Payables

  • Navigate to AP-> Invoices -> Entry-> Recurring invoices
  • Enter the Supplier Name for Recurring Invoice
  • Enter the Supplier Number for Recurring Invoice
  • Enter the Supplier Site for which Recurring Invoice is created
  • Select the Recurring Calendar created above
  • Enter the Number of Periods ( defined in the Recurring calendar above)
  • Enter the First Period
  • Next Period is generated by system
  • Remaining Periods is generated by system
  • Navigate to Invoice Definition Tab in Recurring Invoice Screen
  • Enter Invoice Number
  • Enter Invoice Currency
  • Enter Invoice Description (Optional)
  • Select the Liability Account Code Combination for generating Recurring Invoice Accounting entries related to given liability account
  • Navigate to Line Definition Tab in Recurring Invoice Screen
  • Select the Option either Distribution Sets or Purchase Order(PO)
  • Enter Item Description (Optional)
  • Enter Manufacturer (Optional) Enter Model Number (Optional)
  • Navigate to Amount Tab in Recurring Invoice Screen
  • Enter the First Amount value
  • Enter the Change in Percentage(%) value: If 10% is given, then 10% of First Amount is added to get Total First Amount Value
Create Recurring Invoices in Payables R12

Click On Create Recurring Invoices button for generating Invoices in Invoices Workbench 

AP- Account Payables

Share this on ...

  • No Related Posts Yet!

Meta

  • Register
  • Log in

Archives

  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • July 2019
  • June 2019
  • May 2019
  • May 2018
  • April 2018
  • November 2017
  • April 2017
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • June 2014
  • May 2014
  • March 2014
  • September 2013
  • May 2013
  • September 2012
  • June 2012

Archives

  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • July 2019
  • June 2019
  • May 2019
  • May 2018
  • April 2018
  • November 2017
  • April 2017
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • June 2014
  • May 2014
  • March 2014
  • September 2013
  • May 2013
  • September 2012
  • June 2012

Archives

  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • July 2019
  • June 2019
  • May 2019
  • May 2018
  • April 2018
  • November 2017
  • April 2017
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • June 2014
  • May 2014
  • March 2014
  • September 2013
  • May 2013
  • September 2012
  • June 2012

Powered by WordPress. Theme: Brawny by Webulous Themes

Recent Posts

  • How to create legal entity registration in Oracle Fusion
  • Query to get organization structure details in Oracle Fusion General Ledger
  • Assign Legal Entities and Balancing segments in Oracle Fusion
  • Create Legal Entity in Oracle Fusion
  • How to Create Implementation Project in Oracle Fusion
  • Purchase Requisition BPM Approval Workflow Tables in Oracle Fusion
  • Query to get Oracle Fusion Payables Cloud approver comments
  • How to create implementation user in Oracle Fusion
  • Functional Setup Manager in Oracle fusion
  • Top 50 AJAX Interview Questions and Answers