Home » Posts tagged 'Receivables'
Tag Archives: Receivables
How to Generate the COGS Account from the Order Type
![](https://orapedia.wordpress.com/wp-content/uploads/2013/05/madhappann.jpg?w=960)
How to Generate the COGS Account from the Order Type
This article from Madhappan – Oracle SCM Functional Consultant
The article direct link How to Generate the COGS Account from the Order Type [ID 414314.1]
Summary
In order to generate the COGS account from the Cost of Goods Sold account assigned to the order type (A.K.A. OM Transaction Type) of the order, the seeded COGS workflow needs to be modified to change the default node from Get CCID for a line to Get CCID from the Order Type ID. This bulletin will detail the required changes to accomplish this.
How to make manual Refund to Customers in R12
![](https://orapedia.wordpress.com/wp-content/uploads/2013/08/raghu.jpg?w=960)
How to make manual Refund to Customers in R12
This article from ORACLE APPLICATIONS
The article direct link How to make manual Refund to Customers in R12
Summary
We need to account the money that is paid back (refund) to customer in apps. In 11i we are forced to create customer as a supplier, pass credit memo, prepare invoice manually in AP and issue payment in AP. There is a new functionality to pay back money to customer in R12.
Example for Refund: Amount paid back because of an over collection or the return of goods sold called refund. or The reimbursement of the purchase price of a good or service, for reasons such as defective goods or dissatisfaction with the service provided to customer.
How to make manual refund to customer?
Oracle Receivables Setup Steps
![](https://orapedia.wordpress.com/wp-content/uploads/2013/07/suresh.jpg?w=960)
Oracle Receivables Setup Steps
This article from Oracle Apps Techno Functional
The article direct link Oracle Receivables Setup Steps
Summary
This article provides a brief description of each Receivables setup step. Some of the operations listed are optional, but you should perform the required steps in the order shown to be sure that your system is set up properly.
Oracle eBusiness Suite Electronic Technical Reference Manual – eTRM
![](https://orapedia.wordpress.com/wp-content/uploads/2013/06/oracleetrm.gif?w=960)
Oracle eBusiness Suite Electronic Technical Reference Manual – eTRM
This article from Oracle eBusiness Suite Electronic Technical Reference Manual – eTRM
The article direct link Oracle eBusiness Suite Electronic Technical Reference Manual – eTRM
Summary
eTRM is a pl/sql utility that reads design information in an Oracle database and displays its output in html format. It shows database design and dependency information for the Oracle eBusiness Suite. Enter the name of a database object (example: per_people_f) or a search condition (example: contract compliance) then press ‘Search’ to search for information. Alternatively you can browse the FND Model or Oracle Data Dictionary from the FND or DBA tabs.
Auto Invoice in Accounts Receivables
![](https://orapedia.wordpress.com/wp-content/uploads/2013/03/srinivasaraoasuru.jpg?w=960)
Auto Invoice in Accounts Receivables
This article from Oracle Apps Knowledge Varsity
The article direct link Auto Invoice in Accounts Receivables
Summary
Autoinvoice is a powerful and flexible tool, used to import and validate transaction data from external financial systems or other modules of Oracle Applications. Users can create Invoices, debit memos, credit memos, and on-account credits in Oracle Receivables using Autoinvoice.
Data for creating invoices comes in from various sources such as external systems, Order Management, Oracle Projects, Oracle Services and so on. The interface loading program is run to populate the interface tables. When the Autoinvoice Master Program and Import Program are run, the data passes through certain validation processes and finally populates the tables of the Oracle Receivables module.
Oracle Receivables Implementation – Functional & Technical Overview [PDF]
![](https://orapedia.wordpress.com/wp-content/uploads/2013/01/ranu.gif?w=960)
Oracle Receivables Implementation Document
This article from Apps To Fusion
The article direct link Oracle Receivables Implementation Document
Summary
This document contains implementation steps documented with screenshots for Oracle Receivables implementation.
This document contains both technical and functional details for setting up Oracle Receivables.
You will find these notes practical and useful in you ever want to implement Oracle Receivables as a functional consultant.
This document has been prepared with real life Oracle Receivables implementation, hence is very hands-on in nature.
The topics covered in this documentation are:
Parties
DQM
Merging Parties & Customer Account
Party reports
Defining Setup Options
Optional Customer Profile setup
Required Customer Profile setup
AR Transactions (Invoices)
Transaction Classes
Correcting Invoices
Printing Transactions
Generating statements
Consolidated Invoice
Transaction Types : AR -> setup -> Transaction type
Calculating Tx on Invoives
Process Invoices
Transactions Workbench Window
Invoice Components
Transactions Window Tabs
Required Transaction Information
Transaction Defaults
Standard Invoice Line Types
Entering Freight Invoices or Lines
Entering Sales Credits
Completing Transactions
Creating Copies of Invoices
Using Recurring Rules
Creating Invoices for Services
Defining Accounting Rules
Deferred Accounting Rules
Revenue Recognition Program
Making Adjustments using Revenue recognition program
Correcting Invoices
Invoice Correction Methods
Creating Debit Memos (N) > Transactions > Transactions
Creating Adjustments (N) > Transactions > Transactions Summary > (B) Adjust
On-Account Credit Options (N) > Transactions > Transactions
Voiding Transactions (N) > Transactions > Transactions
Using Consolidated Billing
Correcting AR Transactions
Refunds : When customer has already paid an invoice & request money back instead of credit.AR does not create checks & therefore can not complete refund process
Voiding transactions
Processing Customer Adjustments
Manual Adjustments
Processing Commitments Not Documented
Applying Receipts
Batch Status
Entering Receipts
Chargeback & adjustments
Implementing & using Auto LockBox
Pre-Requisites
Importing Receipts
Validating Receipts
Receivables applied the receipts matching
Cross currency AutoLockBox Requirements
Maintain/Correct & Recolve Errors
Setup autolockbox,Define cash rules & AR Profiles
Processing Automatic receipts
Setup considerations
Using Automatic Receipts
Confirming Automatic receipts
Recording Customer confirmations
Updating Automatic receipts
Sending Automatic Remittances
Processing Credit Card Receipts
Credit card receipt process
Benefits/Usage of credit card processing :
Remitting credit card Receipts
Remitting Customer Receipts
Creating Remittance batches
Receipt Statuses
Remittance Batch Vs Receipt batch
Accounting Treatment of Receipts
Setting up remittance
Defining Receipt Classes
Remittance Methods
Controlling Remittance Process
Period Closing Process
Reconciling Receivables Transactions, Receipts, and Customer Balances
Transferring to the General Ledger
Running the Journal Import Program
Mapping Receivables Transactions to General Ledger Categories
Tax Accounting Process
Order Management Global Taxes Overview
Receivables Global Tax Overview
Global Tax Overview
Tax Overview
Value Added Tax Overview
US Sales Tax Overview
Tax Partner Process Overview
Oracle Applications supports other types of tax:
Quick Reference
Accounting Invoices
Accounting Credit Memos
Accounting Deposits
Accounting Guarantees
Accounting Receipts
Accounting Remittances
Accounting Adjustments
Accounting Debit Memos
Accounting On-Account Credits
Accounting Creating a credit card refund
Accounting Reversing a credit card refund
Accounting Claims
Appendix
you can download the oracle receivables implementation functional technical overview document from the following link:
oracle_receivables_implementation_functional_technical_overview.pdf
Oracle Receivables Credit Memos Transactions
![](https://orapedia.wordpress.com/wp-content/uploads/2013/01/oracleapplicationslibrary.gif?w=960)
Oracle Receivables Credit Memos Transactions
This article from Oracle Applications Library
The article direct link Credit Memos
Summary
When you enter a credit memo against an invoice, Receivables creates records in several tables this article cover what these tables and the data life cycle.