review and correct the receivable account assignment

Double Entry Bookkeeping

learn bookkeeping online for free

Home > Accounts Receivable > Assignment of Accounts Receivable Journal Entries

Assignment of Accounts Receivable Journal Entries

The assignment of accounts receivable journal entries below act as a quick reference, and set out the most commonly encountered situations when dealing with the double entry posting of accounts receivable assignment.

The assignment of accounts receivable journal entries are based on the following information:

• Accounts receivable 50,000 on 45 days terms
• Assignment fee of 1% (500)
• Initial advance of 80% (40,000)
• Cash received from customers 6,000
• Interest on advances at 9%, outstanding on average for 40 days (40,000 x 9% x 40 / 365 = 395)

About the Author

Chartered accountant Michael Brown is the founder and CEO of Double Entry Bookkeeping. He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries. He has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a degree from Loughborough University.

You May Also Like

Oracle Apps Knowledge Sharing

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

• TECHNICAL TUTORIALS
• USEFUL LINKS
• ARTICLE INDEX
• VIDEO INDEX

Saturday, February 13, 2010

Autoinvoice error: please correct the revenue account assignment.

Iissue may be beacuse of follwing reasons 1) Autoaccouting setup 2) Memo line Setup 3) Item defination setup check 1: Go in Receivables Responsiblity Setup > Transactions > Sources Query the source that you are importing Go in the Other Information tab Check the setup for Memo Line Rule. check 2: Other way to do you can analayze the log and try to find the root cause. 1) Make sure you have done the proper setup for the source for your autoaccounting in AR Go to Setup->;Transactions->Autoaccounting Pay particular attention to the REVENUE sources and write them down. . 2) Go to each line that was rejected and manually walk through how each segment is built (fetch them from the proper sources as identified in step 1. Make sure that the accounts shown on the Autoinvoice Execution report (in the validation errors) are truly the correct accounts based on your setup. 3) Go into GL and verify that those accounts (the results of step 2) are valid, enabled, and that there are no problems with them (there probably are some recent changes that caused this) 4) If you still think they are valid after doing steps 1-3, go ahead and enter a new transaction and attempt to override the distributions to one of the invalid accounts and see if the form lets it pass. When the form rejects an account, it often puts the cursor on the bad segment -and that can be helpful in tracking down what is causing the rejections. Couple of other things you should also quick check: If it has transaction type, then you have to check the transaction type you are using and make sure that you have assigned a revenue account. If it has standard lines, then you have to check the standard lines you are using and make sure that you have assigned a sales account. Check it out in the Item defnition endable invoiceble flag, anmd check the how Sales account are linked with Revenue account. 1)Standard Lines - For an Inventory Item navigate to Menu: Setup>Transactions>Items>Inventory items, verify the ‘Sales Account’ is populated in the ‘Invoicing’ alternate region. For a Memo Line, navigate to Setup ->Transactions ->Memo Lines, and make sure that ‘Revenue Account’ is populated.

Do you think this Article is useful?

0 Responses to “Autoinvoice error: Please correct the revenue account assignment”

Post a comment, stay connected.

Popular Posts

• Query to fetch Purchase Receipt and its related Purchase order, Vendor details in Oracle Apps R12 (RCV_TRANSACTIONS, RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES)
• Query to get basic AP Invoice and Payment information from Oracle Apps R12
• Query to Fetch Employee Details in Oracle Apps R12 (PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_JOBS, PER_ALL_POSITIONS, PER_PHONES)
• WSH_DELIVERY_DETAILS.RELEASED_STATUS ( Pick Release Status)
• Query to get active Customer and their Profile Details (HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUSTOMER_PROFILES, HZ_CUST_PROFILE_AMTS)
• How to find Order types in R12 (Script for Order types)
• How to get Oracle Application User Password from database - oracle.apps.fnd.security.WebSessionManagerProc.decrypt
• Query To Fetch Customer Account/Site Contact Details in R12
• OE_ORDER_HEADERS_ALL Description and Its Column Details
• Query to fetch Purchase Requisition, BPA, Purchase Order and Vendor Details in Oracle Apps R12 (PO_REQUISITION_HEADERS_ALL, PO_HEADERS_ALL)

Blog Archive

shareoracleapps.com

Site Stats (Last 30 Days)

Our Insights

Assignment of Accounts Receivable – Trap for the Unwary

By  Steven A. Jacobson

Most businesses are familiar with the mechanics of an assignment of accounts receivable. A party seeking capital assigns its accounts receivable to a financing or factoring company that advances that party a stipulated percentage of the face amount of the receivables.

The factoring company, in turn, sends a notice of assignment of accounts receivable to the party obligated to pay the factoring company’s assignee, i.e. the account debtor. While fairly straightforward, this three-party arrangement has one potential trap for account debtors.

Most account debtors know that once they receive a notice of assignment of accounts receivable, they are obligated to commence payments to the factoring company. Continued payments to the assignee do not relieve the account debtor from its obligation to pay the factoring company.

It is not uncommon for a notice of assignment of accounts receivable to contain seemingly innocuous and boilerplate language along the following lines:

Please make the proper notations on your ledger and acknowledge this letter and that invoices are not subject to any claims or defenses you may have against the assignee.

Typically, the notice of assignment of accounts receivable is directed to an accounting department and is signed, acknowledged and returned to the factoring company without consideration of the waiver of defenses languages.

Even though a party may have a valid defense to payment to its assignee, it still must pay the face amount of the receivable to the factoring company if it has signed a waiver. In many cases, this will result in a party paying twice – once to the factoring company and once to have, for example, shoddy workmanship repaired or defective goods replaced. Despite the harsh result caused by an oftentimes inadvertent waiver agreement, the Uniform Commercial Code validates these provisions with limited exceptions. Accordingly, some procedures should be put in place to require a review of any notice of assignment of accounts receivable to make sure that an account debtor preserves its rights and defenses.

• Announcement

Steps to be considered when we get ‘Please Correct Revenue Account Assignment’ in AR Autoinvoice import program?

Introduction :

This is used to fix the invalid revenue account for AR invoice

Auto accounting is used to determine the accounts when the distribution table is not populated. When Auto Invoice gives this error, it generally gives the account with the missing segment(s).

Menu: Setup>Transactions>Auto accounting Query the account mentioned in the above error and note the setup for that missing segment.

If it is based on:

Transaction Type – Menu: Setup>Transaction>Transaction Types, and verify that all accounts are populated.

Salesperson – Menu: Setup>Transactions>Salespersons, and verify that all accounts are populated.

Standard Lines – For an Inventory Item navigate to Menu: Setup>Transactions>Items>Inventory items, and verify that the ‘Sales Account’ is populated in the ‘Invoicing’ alternate region. For a Memo Line, navigate to Setup =>Transactions =>Memo Lines, and make sure that ‘Revenue Account’ is populated.

Taxes – Menu: Setup>Tax>Codes and verify that account is populated in ‘Tax’ column under the ‘Accounting’ alternate region. Additionally the following can be checked: Setup of Cross Validation Rules. Run Cross validation Listing Report in GL to identify the cross validation rule stopping the import of this line.

Know more about post.

[email protected]

Start typing and press Enter to search

• Search Search Please fill out this field.
• Corporate Finance
• Corporate Debt

Assignment of Accounts Receivable: Meaning, Considerations

Adam Hayes, Ph.D., CFA, is a financial writer with 15+ years Wall Street experience as a derivatives trader. Besides his extensive derivative trading expertise, Adam is an expert in economics and behavioral finance. Adam received his master's in economics from The New School for Social Research and his Ph.D. from the University of Wisconsin-Madison in sociology. He is a CFA charterholder as well as holding FINRA Series 7, 55 & 63 licenses. He currently researches and teaches economic sociology and the social studies of finance at the Hebrew University in Jerusalem.

Charlene Rhinehart is a CPA , CFE, chair of an Illinois CPA Society committee, and has a degree in accounting and finance from DePaul University.

Investopedia / Jiaqi Zhou

What Is Assignment of Accounts Receivable?

Assignment of accounts receivable is a lending agreement whereby the borrower assigns accounts receivable to the lending institution. In exchange for this assignment of accounts receivable, the borrower receives a loan for a percentage, which could be as high as 100%, of the accounts receivable.

The borrower pays interest, a service charge on the loan, and the assigned receivables serve as collateral. If the borrower fails to repay the loan, the agreement allows the lender to collect the assigned receivables.

Key Takeaways

• Assignment of accounts receivable is a method of debt financing whereby the lender takes over the borrowing company's receivables.
• This form of alternative financing is often seen as less desirable, as it can be quite costly to the borrower, with APRs as high as 100% annualized.
• Usually, new and rapidly growing firms or those that cannot find traditional financing elsewhere will seek this method.
• Accounts receivable are considered to be liquid assets.
• If a borrower doesn't repay their loan, the assignment of accounts agreement protects the lender.

Understanding Assignment of Accounts Receivable

With an assignment of accounts receivable, the borrower retains ownership of the assigned receivables and therefore retains the risk that some accounts receivable will not be repaid. In this case, the lending institution may demand payment directly from the borrower. This arrangement is called an "assignment of accounts receivable with recourse." Assignment of accounts receivable should not be confused with pledging or with accounts receivable financing .

An assignment of accounts receivable has been typically more expensive than other forms of borrowing. Often, companies that use it are unable to obtain less costly options. Sometimes it is used by companies that are growing rapidly or otherwise have too little cash on hand to fund their operations.

New startups in Fintech, like C2FO, are addressing this segment of the supply chain finance by creating marketplaces for account receivables. Liduidx is another Fintech company providing solutions through digitization of this process and connecting funding providers.

Financiers may be willing to structure accounts receivable financing agreements in different ways with various potential provisions.​

Special Considerations

Accounts receivable (AR, or simply "receivables") refer to a firm's outstanding balances of invoices billed to customers that haven't been paid yet. Accounts receivables are reported on a company’s balance sheet as an asset, usually a current asset with invoice payments due within one year.

Accounts receivable are considered to be a relatively liquid asset . As such, these funds due are of potential value for lenders and financiers. Some companies may see their accounts receivable as a burden since they are expected to be paid but require collections and cannot be converted to cash immediately. As such, accounts receivable assignment may be attractive to certain firms.

The process of assignment of accounts receivable, along with other forms of financing, is often known as factoring, and the companies that focus on it may be called factoring companies. Factoring companies will usually focus substantially on the business of accounts receivable financing, but factoring, in general, a product of any financier.

• Terms of Service
• Editorial Policy
• Privacy Policy
• Your Privacy Choices

Receivables - EBS (MOSC)

Discussions

Please correct the revenue account assignment even though auto-accounting is setup as constant

Errors: 1) Please complete the offset account assignments (301-00000-0000-270010-0000-000-00000)

  2) Please correct the receivable account assignment (301-00000-0000-123000-0000-000-00000)

  3) Please correct the revenue account assignment (301-00000-0000-310000-2300-000-00000)

appearing at Autoinvoice Import Program even after setting Autoaccounting as Constant segments values

• autoinvoice import

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