please correct the receivable account assignment in oracle apps r12

Receivables - EBS (MOSC)

Discussions

Please correct the receivable account assignment

I'm getting the error Please correct the receivable account assignment in autoinvoicing line. By checking the note 1088218.1 , I reviewed how the accoutning is for Receivables and it says Transaction types. However we use the transaction type for loading some invoices by files, however we have another way to load invoice that use the autoinvoice so there must be another setup different than transaction types. however we need to know how the receivables account qare taken from

The version is R12.2.4,

Any guide would be appreciated.

Howdy, Stranger!

To view full details, sign in to My Oracle Support Community.

Don't have a My Oracle Support Community account? Click here to get started.

Instructions for posting

1. Select a discussion category from the picklist.

2. Enter a title that clearly identifies the subject of your question.

3. In the body, insert detailed information, including Oracle product and version.

Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).

Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .

New to My Oracle Support Community? Visit our Welcome Center

R12 – Receivables Setups (AR) in Oracle Apps

Define Chart of Accounts
Define Currencies
Define Calendars
Define Calendar Period Types
Define Ledger
Assign Ledger to a Responsibility

Define Chart of Accounts: Define Segments: Navigation: General Ledger –> Setups –> Flexfields –> Key –> Segments. Query With Accounting Flexfield and click on New. Give your coa name and save.

Click on Segments. Enter your segments names.

Navigation: General Ledger –> Setups –> Flexfields –> Key –>Values. Enter the below information and click on find button.

Enter the company values names and save your work.

Like wish define values for all reaming segments. Define Currencies: Navigation: General Ledger –> Setup –> Currencies –> Define. Enter information and save.

Define Calendar Period Types: Navigation: Setup –> Financials –> Calendars –> Types. Enter the information and save.

Define Calendar: Navigation: Setup –> Financials –> Calendars –> Accounting.

Save. Define Ledger : See this post for how to define Ledger in R12 . Assign Ledger to a Responsibility: Navigation: System Administrator –> Profile –> Systems.

Click on find. Assign Ledger to GL Responsibility.

Save. Oracle Inventory Setup Steps:

Define Operating Unit.
Define Inventory Organizations
Define Items

Define Operating Unit:

Enter information in the required fields.

Save your work and click on othres. click on Accounting information.

Enter the required information and save.

Click on Others and select the inventory information.

Under Inventory Parameters tab enter the following information.

Under Costing Information tab enter the following information.

Under the other accounts tab enter the required information.

Define System Options
Define Transaction Flexfield Structure
Define Sales Tax Location Flexfield Structure
Define AutoCash Rule Sets
Define Receivables Lookups
Define Invoice Line Ordering Rules
Define Grouping Rules
Define Application Rule Sets
Define Payment Terms
Define AutoAccounting
Open or Close Accounting Periods
Define Transaction Types
Define Transaction Sources
Define Collectors
Define Approval Limits
Define Remittance Banks
Define Receivables Activities
Define Receipt Classes
Define Receipt Sources
Define Payment Methods
Define Statement Cycles
Define System Profile Options
Define Salespersons
Define Customer Profile Classes
Define Customers
Define Remit–To Addresses

Define Remittance Banks: Proceed to the next step if you already defined your remittance banks in Oracle Payables. Define all of the banks and bank accounts you use to remit your payments. You can define as many banks and bank accounts as you need and define multiple currency bank accounts to accept payments in more than one currency. Define Receivables Activities Define Receivables Activities to provide default accounting information when you create adjustments, discounts, finance charges, miscellaneous cash transactions, and bills receivable. Receivables also uses Receivables Activities to account for tax if you calculate tax on these activities. Navigation: Receivables –> Setup –> Receipts –> Receivable Activities.

Like wise we should define reaming receivable actives also. Define Receipt Classes: Define receipt classes to specify whether receipts are created manually or automatically. For manual receipts, you can specify whether to automatically remit it to the bank and/or clear your accounts. For automatic receipts, you can specify a remittance and clearance method, and whether receipts using this class require confirmation. Navigation: Receivables –> Setup –> Receipts –> Receipts Class.

Click on Bank accounts. Enter information in respective fields.

Save your work. Define Payment Method: Define the payment methods to account for your receipt entries and applications and to determine a customer’s remittance bank information. When defining payment methods, you must enter a receipt class, remittance bank information, and the accounts associated with your payment receivables type. You can also specify accounts for confirmation, remittance, factoring, bank charges, and short–term debt. Navigation: Receivables –> Setup –> Receipts –> Receipts Class.

Define Statement Cycles: Define statement cycles to control when you create customer statements. You assign statement cycles to customers in the Customer Profile Classes window. Navigation: Receivables –> Setup –> Print –> Statement Cycle.

Define profile options: Define profile options to provide default values for some Receivables operations, specify how Receivables processes data, and control which actions users can perform. Navigation: Administrator –> Profile –> Systems. During your implementation, you set a value for each Receivables user profile option to specify how Receivables controls access to and processes data. Receivables lets you govern the behavior of many of the windows that use profile options. Profile options can be set at the following levels: • Site: This is the lowest profile level. Site level profile option values affect the way all applications run at a given site. • Application: These profile option values affect the way a given application runs. • Responsibility: These profile option values affect the way applications run for all users of a given responsibility. • User: These profile option values affect the way applications run for a specific application user. The values you enter for options at the User level supersede the values that your system administrator has entered for you for these options. Each of these user profile options affect the behavior of Receivables in different contexts. In Receivables, operations that profile options can affect include receipt application, the entry of adjustments, the creation and remittance of automatic receipts and taxes, and posting to your general ledger. You may also have additional user profile options on your system that are specific to applications other than Receivables. To change profile options at the Site, Application, or Responsibility level, choose the System Administrator responsibility, then navigate to the Personal Profile Values window. Query the Profile Name field to display the profile options with their current settings, make your changes, then save your work. You can change profile options at the user level in the Personal Profile Values window. To do this, navigate to the Personal Profile Values window, query the profile option to change, enter a new User Value, then save your work. Generally, your system administrator sets and updates profile values at each level. Attention: For any changes that you make to profile options to take effect, you must either exit, and then reenter Receivables, or switch responsibilities.

Define Salespersons: Define salespersons to allocate sales credits to invoices, debit memos, and commitments. If you do not want to assign sales credits for a transaction, you can enter No Sales Credit. If AutoAccounting depends on salesperson, Receivables uses the general ledger accounts that you enter for each salesperson along with your AutoAccounting rules to determine the default revenue, freight, and receivable accounts for transactions. Define Customer Profile Classes: Define customer profile classes to categorize customers based on credit, payment terms, statement cycle, automatic receipt, finance charge, dunning, and invoicing information. When you initially set up your customers, you assign each customer to a profile class. To customize the profile class for a specific customer, use the Customer Profile Classes window. Navigation: Receivables –> Customers –> Profile Classes. In Profile Class window enter the following information.

In Profile class Amount tab enter the following information.

Save your work. Define Customers: Define customers and customer site uses to enter transactions and receipts in Receivables. When you enter a new customer, you must enter the customer’s name, profile class and number (if automatic customer numbering is set to No). You can optionally enter customer addresses, contacts, site uses and telephone numbers. You must enter all the components of your chosen Sales Tax Location Flexfield when entering customer addresses in your home country. Navigation: Receivables –> Customers –> Standard. Define Remit–To Addresses: Define remit–to addresses to inform your customers where to send payments. Associate each remit–to address with one or more state, country, and postal code combinations. For example, if you want your customers in California and Nevada to send their payments to a specific address, enter the remit–to address and associate the states CA and NV with this address. Remit–to addresses are assigned based on the bill–to address on the transaction. Navigation: Setup –> Print –> Remit-to-addresses. Click on Create Remit to addresses.

Enter the required information

Click on Apply. Enter the country name in the same page and then click on the GO. Click on the Receipts form Create button.

Enter the following information and click on Apply button.

Latest Posts

R12 – How to Handle NULL for :$FLEX$.VALUE_SET_NAME In Oracle ERP August 25, 2023 - 1:20 pm
R12 – How to Delete Oracle AR Transactions March 22, 2019 - 8:37 pm
How to Define Custom Key Flexfield (KFF) in R12 January 19, 2018 - 5:43 pm
AutoLock Box Concepts In R12 November 10, 2017 - 8:30 am
R12 – java.sql.SQLException: Invalid column type in OAF September 15, 2017 - 9:39 am

Ads Blocker Detected!!!

This site uses cookies and other tracking technologies to assist with navigation and your ability to provide feedback, analyse your use of our services, and provide content from third parties. By continuing to browse the site, you are agreeing to our use of cookies.

Cookie and Privacy Settings

We may request cookies to be set on your device. We use cookies to let us know when you visit our websites, how you interact with us, to enrich your user experience, and to customize your relationship with our website.

Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.

These cookies are strictly necessary to provide you with services available through our website and to use some of its features.

Because these cookies are strictly necessary to deliver the website, refusing them will have impact how our site functions. You always can block or delete cookies by changing your browser settings and force blocking all cookies on this website. But this will always prompt you to accept/refuse cookies when revisiting our site.

We fully respect if you want to refuse cookies but to avoid asking you again and again kindly allow us to store a cookie for that. You are free to opt out any time or opt in for other cookies to get a better experience. If you refuse cookies we will remove all set cookies in our domain.

We provide you with a list of stored cookies on your computer in our domain so you can check what we stored. Due to security reasons we are not able to show or modify cookies from other domains. You can check these in your browser security settings.

These cookies collect information that is used either in aggregate form to help us understand how our website is being used or how effective our marketing campaigns are, or to help us customize our website and application for you in order to enhance your experience.

If you do not want that we track your visit to our site you can disable tracking in your browser here:

We also use different external services like Google Webfonts, Google Maps, and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.

Google Webfont Settings:

Google Map Settings:

Google reCaptcha Settings:

Vimeo and Youtube video embeds:

The following cookies are also needed - You can choose if you want to allow them:

You can read about our cookies and privacy settings in detail on our Privacy Policy Page.

Oracle Apps Knowledge Sharing

Meant for sharing our knowledge related to Oracle E-Business Suite

TECHNICAL TUTORIALS
USEFUL LINKS
ARTICLE INDEX
VIDEO INDEX

Wednesday, March 24, 2010

R12 account receivables: receipt application overview.

We can apply a receipt against the below canditates, 1. Credit Memo 2. Invoice 3. Related Customer’s Invoice 4. Deposit 5. Chargeback 6. Debit Memo and even open Receipts. Further we can do three more actions named Refund, Receipt Write-off’s, On Account. For every application we can find a new record in the table named “ AR_RECEIVABLE_APPLICATIONS_ALL ” with the application type as “CASH”. For example, If Receipt amount = 1500 and got applied against a invoice with amount 500. Then APPLIED_AMOUNT becomes 500 and UNAPPLIED AMOUNT becomes 1000. Further if you want to see the above data from back end use the below query, SELECT status , SUM ( amount_applied ) FROM ar_receivable_applications_all WHERE cash_receipt_id = '&cash_receipt_id' GROUP BY status ; Further we have the below important columns in “AR_RECEIVABLE_APPLICATIONS_ALL” table, Payment_schedule_id ,code_combination_id ,apply_date ,applied_customer_trx_id, Incase, if the application is at line level then we have the below columns also, Rule_set_id ,line_applied ,tax_applied ,applied_customer_trx_line_id ,freight_applied If you want to know more information about the “RULE_SET_ID” then please check the below tables AR_APP_RULE_SETS AR_APP_RULES This rule_set_id defaulted to each org_id and the corresponding information can be found in the table AR_SYSTEM_PARAMETERS_ALL

Do you think this Article is useful?

0 Responses to “R12 Account Receivables: Receipt Application Overview”

Blog Archive

shareoracleapps.com

Site Stats (Last 30 Days)

Overview of Oracle Receivables

Receivables workbenches.

Oracle Receivables provides three integrated workbenches that you can use to perform most of your day-to-day Accounts Receivable operations. You can use the Receipts Workbench to perform most of your receipt-related tasks and the Transactions Workbench to process your invoices, debit memos, credit memos, on-account credits, chargebacks, and adjustments. The Bills Receivable Workbench lets you create, update, remit, and manage your bills receivable.

Each workbench lets you find critical information in a flexible way, see the results in your defined format, and selectively take appropriate action. For example, in the Transactions Workbench, you can query transactions based on the bill-to or ship-to customer, currency, transaction number, or General Ledger date. You can then review financial, application, and installment information, perform adjustments, create a credit memo, or complete the transaction. All of the windows you need are accessible from just one window, so you can query a transaction once, then perform several operations without having to find it again.

Function Security

You may not have access to every window, button, or tabbed region within a workbench. This is because your system administrator may be using Function Security to prevent users with your responsibility from performing specific Receivables operations. For example, your responsibility might allow you to enter receipts but prevent you from deleting them. For more information, see: Function Security in Oracle Receivables, Oracle Receivables Implementation Guide .

Several of the windows in the Receivables workbenches are folders. Folders let you choose which fields you want to view and where they appear in a window. You can tell if a window is a folder if an open folder icon appears at the top left portion of the window. Additionally, if the profile option Flexview: Allow Customization is set to Yes, you can save your customizations to a particular window to quickly retrieve that subset of records later. You can modify the appearance of a folder by choosing options on the Folder menu.

Summary and Detail Windows

The Receipts and Transactions workbenches let you view records one at a time or as a group. Detail windows display only one receipt or transaction at a time, but provide more information about the record because they contain more fields and tabbed regions. Summary windows, by contrast, can display multiple records at once but require that you "drill down" to the detail window to view additional information about the current record. Following is a list of the available detail and summary windows within the Receivables Workbenches:

Receipts Workbench: Receipts, Receipts Summary, Receipt Batches and Receipt Batches Summary

Transactions Workbench: Transactions and Transactions Summary, Transactions Batches and Transaction Batches Summary

Remittances / Remittances Summary

Find Windows

Find windows are available within each of the Receivables workbenches. These windows let you search for information based on a specific set of criteria that you specify. For example, the Find Transactions window lets you search for multiple records by entering a range of transaction numbers, dates, batches, or transaction types. You can also retrieve a single record by entering a specific document or transaction number.

You can access Find windows from the View menu.

List of Values

The list of values is a powerful, time saving feature that lets you choose valid data for a field from a predefined list. If the <List> lamp appears when your cursor is in a field, you can choose the List of Values icon to view a list of valid entries for that field. Simply click on the value you want; Receivables enters the data you selected and moves the cursor to the next field in the window.

In the Receipts, Transactions, and Bills Receivable Workbenches, the Tools pulldown menu lets you perform operations in addition to those provided by the action buttons. For example, in the Receipts Workbench, you can view the sum of multiple receipts in the Receipt Totals window, and review the functional currency gain or loss resulting from a currency exchange rate adjustment in the Receipt History window.

In the Transactions Workbench, the Tools menu provides access to functions that are not accessible via action buttons. For example, the Balances button does not appear in the Transactions Summary window, but you can display the Transaction Balances window by choosing Balances from the Tools menu.

In the Bills Receivable Workbench, the Tools menu provides additional functionality for managing bills receivable. For example, in the Bills Receivable window you can view exchange rate information for currencies that are different from the functional currency, or use the Exchange option to exchange a bill receivable for a new bill receivable.

View Accounting Windows

In the Receipts and Transactions workbenches you can view the detail accounting lines for an item in the form of a balanced accounting entry (i.e., debits equal credits) by choosing View Accounting from the Tools menu. You can also choose to view the detail accounting as t-accounts. Use these features to see how a transaction affects the account balances in your general ledger.

Note: You can also view detail accounting lines for adjustments from the Adjustments window.

View Currency Details Windows

If you are using Multiple Reporting Currencies (MRC) functionality, then you can view transaction amounts in the primary and reporting functional currencies simultaneously from a single responsibility. You can access the View Currency Details inquiry window from either the Receipts or Transactions workbench. See: Viewing MRC Details for a Transaction .

Bills Receivable Workbench

Use the Receipts Workbench to create receipt batches and enter, apply, reverse, reapply, and delete individual receipts. You can enter receipts manually, import them using AutoLockbox, or create them automatically. You can also use this workbench to clear or risk eliminate factored receipts, remit automatic receipts, create chargebacks and adjustments, and submit Post QuickCash to automatically update your customer's account balance.

Default Attributes

When you enter receipts individually, Receivables provides default values for the following attributes in the Receipts and Receipts Summary windows:

Deposit Date

Maturity Date

Receipt Date

Receipt Type

When you enter receipts as part of a batch , receipts that you enter inherit the following attributes, in addition to those listed above:

Receipt method

Receipt class

You can also set up default values for new receipt batches. For example, you define the batch source 'Standard' and set Automatic Batch Numbering to Yes for this source. You also set the profile option AR: Receipt Batch Source to 'Standard' (see below). Then, when you create a new batch, Receivables uses Standard Source as the default batch source and automatically generates a unique batch number when you save.

Other profile options that you can setup to provide default values in the Receipts Workbench include:

AR: Default Exchange Rate Type This option determines the default value for the exchange rate type that appears in the exchange rate window of the Receipts and Receipts Summary windows. Valid values are Corporate Exchange Rate, Spot Exchange Rate, and User Specified Rate.

AR: Receipt Batch Source This option determines the default receipt batch source in the Receipts and Receipt Batches windows.

Note: If a user has access to multiple organizations, Receivables does not default the receipt batch source in Receipt Batches and Receipt Batches Summary windows.

For more information, see: Overview of Receivables User Profile Options, Oracle Receivables Implementation Guide .

Folder Windows

The following windows in the Receipts Workbench are Folder windows. You can customize the appearance of these windows by selecting options from the Folder menu:

Applications

Lockbox Transmission Data

Receipt Batches Summary

Receipts Summary

Remittances Summary

Using the Receipts Workbench

For a text description of this graphic, see: Text Description of the Receipts Workbench Graphic .

Refer to the table below to help you use the Receipts Workbench and the corresponding Receivables documentation more effectively. The phrase "Not Applicable" in the Window/ tabbed region column indicates that the documentation for that topic is an essay or general description of the feature; therefore, the corresponding window name is not applicable.

Use the Transactions Workbench to create new and update existing invoices, debit memos, credit memos, on-account credits, and commitments within Receivables. You can also use this workbench to enter, review, or complete transactions, copy invoices, create adjustments, credit transactions, review invoice installments, and update chargebacks.

When you enter transactions individually, Receivables provides default values for the following attributes in the Transactions and the Transactions Summary windows:

You can also define the profile option AR: Transaction Batch Source to provide a default batch source for your transactions. This profile option determines the value of the Batch field in the Transactions, Transactions Summary, Transaction Batches, Transaction Batches Summary, and Credit Transactions windows.

The following windows in the Transactions Workbench are Folder windows. You can customize the appearance of these windows by selecting options from the Folder menu:

Transaction Batches Summary

Transactions Summary

Using the Transactions Workbench

For a text description of this graphic, see: Text Description of the Transactions Workbench Graphic .

Refer to the table below to help you use the Transactions Workbench and the corresponding Receivables documentation more effectively. The phrase "Not Applicable" in the Window/ tabbed region column indicates that the documentation for that topic is an overview or topical essay.

Use the Bills Receivable Workbench to create, update, remit, and manage bills receivable. You can create a bill receivable and assign transactions to the bill either manually or automatically. You can also use this workbench to review bills receivable, update the status of a bill, and create and maintain bills receivable remittance batches. The Bills Receivable Workbench also manages creating and applying receipts, and eliminating risk on remitted bills receivable.

You can also exchange a transaction for a bill receivable in the Transactions Workbench, and use the Receipts Workbench to reverse or unapply receipts applied to bills receivable.

When you create a bill receivable or a bills receivable remittance, Receivables provides default values for the following attributes in the Bills Receivable and Remittances windows:

You can also define the AR: Bills Receivable Batch Source profile option to provide a default batch source for your bills receivable. This profile option determines the value of the Batch field in the Bills Receivable and Bills Receivable Transaction Batches windows.

Setup Options

There are two profile options that belong to the Bills Receivable Workbench:

AR: Bills Receivable Batch Source: This profile option defines a default batch source for bills receivable transactions.

AR: Factor/Endorse Bills Receivable without Recourse: This profile option determines whether you can factor or endorse bills receivable remittances without recourse.

This system option applies to other transactions except bills receivable:

Document Number Generation Level: This system option determines at what point Receivables generates a document number for transactions. For bills receivable transactions, Receivables ignores this system option and generates a document number when the transaction is completed.

There is one Folder window in the Bills Receivable Workbench. You can customize the appearance of this window by selecting options from the Folder menu:

Bills Receivable Portfolio Management

Using the Bills Receivable Workbench

Refer to the table below to help you use the Bills Receivable Workbench and the corresponding Receivables documentation more effectively. The phrase "Not Applicable" in the Window/tabbed region column indicates that the documentation for that topic is an essay or general description of the feature.

Scripting on this page enhances content navigation, but does not change the content in any way.