1 Customer Profile Classes
Use Customer Profiles to group customer accounts with similar credit worthiness, business volume, and payment cycles. For each profile class you can define information such as credit limits, payment terms, statement cycles, invoicing, and discount information. You can also define amount limits for your finance charges, dunning, and statements for each currency in which you do business.
For example, you might define three categories: one for prompt paying customers; one for late paying customers with high finance charge rates; and a third for customers who mostly pay on time, with discount incentives for early payment. You can also use the profile class 'DEFAULT,' which Oracle Receivables provides.
You can assign a profile class to customers and addresses through the Customers-Standard window. The customer profile class you assign provides the default values, which you can optionally customize to meet specific requirements for each customer or address.
If a profile is assigned to a customer and an address of the same customer, the options set at the address level take precedence over those set at the customer level. For statement site and dunning site profile amounts, however, Receivables uses the options at the address level only if you set the AR: Use Statement Site & Dunning Site Profiles profile option to Yes.
Prerequisites
· Define statement cycles
· Define customer profile lookups
· Define credit analysis
· Define dunning letters
· Define collectors
· Define grouping rules
· Define payment terms
· Define AutoCash rule sets
· Define System Options
Navigate to profile class window (Navigation: customer: profile classes)
Credit Profile
Customer Profile Classes – Profile Class Amounts
2 Customers
Customer and Customer sites define customer name and address information to bill customer’s goods and services rendered. Minimally, customer records have three components: a customer record, a customer site record, and a customer site business purpose record.
The one-customer-to-many-customer- sites architecture allows one customer record to have one or more site records. Understanding and utilizing the one-customer-to-many-customer- sites concept is critical for Oracle Receivables to run as efficiently and effectively as possible Strict in-house naming standards, customer verification procedures, and data entry procedures will improve the Oracle Receivables system and in-house business processes.
Customer and customer site records may be converted or imported. A review of the active customer and address records in the legacy system should occur. The number of records should determine if the customer conversion process is manual or automated. Both conversion strategies require users to clean the data. The current customer data must be extracted and the users must review the data. The one-customer-to-many-customer- sites architecture must be established and duplicates must be eliminated. In addition, consistent in-house naming standards must be applied. Then the customer data may be entered manually or via a conversion program. Fortunately, there is a delivered customer interface. However, the customer conversion program must still be written in-house or delivered by a consulting organization. In addition, the user community must have strict procedures as to what system owns the customer and customer site data.
Customer Site Architecture
The third record is the customer site use record. This data indicates the business purpose of the customer address data such as the bill-to address or the ship-to address data. The appropriate site will appear in the List of Values during data entry. For example, in the bill-to customer site field, only the sites with a business purpose of Bill to will display.
(i) Some of the Oracle Receivables table names start with the prefix “RA” because prior releases of Oracle Receivables included the Oracle Revenue Accounting (RA) application which is now included within the Oracle Receivables application.
Customer Entry
The Oracle Receivables displays the customer entry find window when opening the window
1. From the Receivables menu à Customers à Standard.
2. The system displays search window. Enter the customer name and say go. To verify the customer record doesn’t already exist to avoid accidental duplicate customer records.
3. Press go to execute the query. If the customer exists, the matching records will be displayed. If the customer name doesn’t exist, the system displays no result found. Press create to create a customer record.
Find/Enter Customer
1. Customer window will appear.
2. Enter the name of the organization.
3. Profile class, account type and customer status.
4. Give relevant address and bill to, ship to address.
5. Say save and apply. Then it will display status active and again say apply.
6. Address will appear in the address field.
Customer Address
Oracle Receivables lets you add, change, or deactivate business purpose information for a specific address. Since customer accounts can have multiple addresses, business purposes let you describe which functions are performed at a particular customer account site. For example, assign a ship-to business purpose to the address where you ship your goods and a Dunning business purpose to the address where you will send Dunning Letters.
When you assign a business purpose to an address, its default status is Active. You can make the business purpose inactive by unchecking the Active check box in the Business Purposes tabbed region.
Addresses can have multiple business purposes, such as shipping, billing, or sending statements, dunning letters, marketing collateral, and legal documents. You can also define your own business purposes in the Receivables Lookups window.
Note: An address assigned to a ship-to business purpose is also referred to as a 'Ship-To site', an address assigned to a Dunning business purpose is referred to as a 'Dunning site', and so on.
Business Purposes and Multiple Organization Support
If you are using the Multiple Organization support feature, you can assign a salesperson to a customer account site. If you are not using multiple organizations, you can assign a salesperson to a customer account and to each of their site uses. You can also create a centralized statement and dunning site for each customer account in a multiple organization environment.
Business purposes in a multiple organization environment are organization specific. For example, only the transactions associated with a bill-to site for a specific organization appear on a statement or dunning letter. If the same bill-to site is used by more than one organization, then you must set up the address and associated business purpose of this bill-to site in each organization. Then, for each organization, you must run separate statements and dunning letters for this same bill-to site.
Consolidated statements and dunning letters for a single customer are also organization specific. When you run a consolidated statement or dunning letter, Receivables consolidates all organization-specific transactions for the customer into a single document and sends the document to the bill-to address with the relevant business purpose (Statement or Dunning).
For example, Sites A and B belong to organization MiniCo, and sites B and C belong to organization BigCo. Receivables will record transactions for site B in both organizations. However, when you run consolidated documents, only the transactions created by MiniCo appear on MiniCo documents and only the transactions created by BigCo appear on BigCo documents. Because MiniCo and BigCo are separate organizations, the activity for site B is not duplicated on both organizations' documents.
Common Types of Business Purposes
Bill To: Send invoices to this address. The bill-to address can be different from this customer account's ship-to address.
Drawee: Designate this address as a customer account drawee. A customer drawee is a customer account site responsible for paying bills receivable.
Ship To: Send your goods or services to this address. The ship-to address can be different from this customer account's bill-to address.
The following setup steps are important for entering transactions in the application:
· Transaction Source
· Transaction Type
· Customer
· Auto Accounting
Standard Transaction (Navigation: transactions: transactions)
Transaction – Main Tab
Source | Select the Transaction Source. The Source specifies automatic or manual and invoice numbering, the standard transaction type, determines which attribute of the Invoice Transaction Flex field is used to default into the Reference field. |
Number | Enter the transaction number if automatic numbering is not enabled. If automatic numbering is specified, Receivables generates a number |
Class | Select the Invoice Class from the list |
Type | Select the Transaction Type. Transaction types determine whether a transaction updates open receivables, can be posted to GL, if Receivables calculates tax, the transaction’s creation sign, whether transactions with this type use natural application only or will allow over application, provide the default transaction class, payment term, and printing options for each transaction. |
Date | Enter the transaction date; the default is the current date |
GL Date | Enter the GL date; the default is the current date. if the current date is not in an open period, the default is the last date of the most recent open period |
Legal Entity | Default legal entity will be populated. This can be changed based security access |
Ship To | Enter customer ship to address. All other details will be populated by Oracle |
Bill To | Enter customer Bill to address. All other details will be populated by Oracle |
Payment Term | Select the payment term applicable to the customer. Oracle will calculate the due date based on this |
More Tab:
Transaction – More Tab
Notes Tabbed Region:
Transaction Lines
Freight window reference
Sales Credits Window Reference:
Distributions Window Reference:
Complete:
• Completing an invoice means that payment schedules and aged receivable amounts are calculated, and this transaction can be transferred to the GL.
• When all required information has been entered, click the Complete button.
• Only completed transactions can be printed.
Press on complete button then go to number tab there one icon will appear press on it then view following window.
Exhibit Completed Transaction
Exhibit
Credit Transaction (nav: transactions: credit transactions)
Apply credit amount to open transaction
Say find credit transactions window will appear and click on credit lines following window will appear. Enter number, description, quantity in minus and amount. Save the data.
Query Original Transaction:
Original Transaction
Query Credit Memo Transaction which system automatically crated and open the Reference Information Tabbed Region and see the Original Transaction effected Information
Credit Memo Reference Information
3 Deposit Transaction
Prerequisites
· Deposit Transaction Type
Process:
· Create Deposit Transaction
· Create normal transaction and Apply to Commitment (Deposit) Transaction
Open Commitment Tabbed Region and enter commitment amount and Effective Dates
Enter Commitment Amount
Commitment Transaction
Create normal transaction and Apply to Commitment (Deposit) Transaction
Run COMMITMENT BALANCE REPORT to know available balance in a Commitment
4 Bills receivables
4.1 Standard Remitted Bills Receivable
Bills receivables is the provision through which organization can get customer transaction amount balance on or before the actual payment by customer.
Prerequisites:
1. Customer should be a Drawee
2. There should be a completed transaction of that customer (Drawee)
3. Define transaction type for bills receivables transaction (nav: setup: transactions: transaction types)
Note: Code Combinations (accounts) will be populated from auto accounting (assumed that auto accounting set-up is completed).
4. Define Transaction source for Bills Receivables Transaction ( nav : setup: transactions : sources)
5. Define Receipt Class
Procedure: Now we can create bills receivables transaction
1. N:à bills receivableà transaction
2. select the transaction type, source, currency, GL date, issue date, customer details
3. click on assign tab
4. select the transaction numberà saveà complete
5. bills receivable transaction number will come
Bills Receivables form (1)
Assignment window (3)
Bills receivable transaction status changes from incomplete to pending remittance after completion
Remit bills receivable transaction:
1. N: àbills receivables à remittance.
2. select remittance method, receipt class, payment method, remittance bank etc
3. click on manual creation/auto create
4. N:àclick on action tabàselect createàok
5. status becomes started creation then changes to complete creation
Remittance window
Select manual create
Maintain remittance bank
After completion of creation, status changes from started creation to completed creation
Now approve and format
First the status is started approval then changes to completed approval
Factored Bills Receivables
- Define Receipt Class with remittance method Factoring.( nav: setup: receipt : receipt class)
- Create a Bills Receivable Transaction( nav: bills receivable : transaction)
Remit the Bills Receivables
Complete the transaction and navigate to remittances window (nav: bills receivable: remittances)
Click on maintain to maintain remittance
5. After successful completion of the above programs the status of Bills Receivables will be changed to Factored.
6. Automatically system will create a receipt for the Factored Bills Receivable with receipt number same as Bills Receivable number.
And you can see the accounting entry for the receipt as follows.
7. After reconciliation/manual clearing in Cash Management the status of the receipt will be changed to Cleared.
And you can see the accounting entry as follows
8. Notes Receivables
Receivables let you enter and track future-dated payments. These types of payments can either be a future dated check or a formal document called a promissory note. A promissory note is a formal, printed document in which the issuer promises to a pay a specific amount on a specific date to another party (the note holder). The date that payment is due is called the note maturity date. Promissory notes are guaranteed by the bank that issues the note.
When a promissory note is created, the issuer specifies the amount due, the maturity date, and the bank branch from which the holder can receive the payment. When the note reaches its maturity date, the holder submits it to their bank. The bank then submits the note to a clearing institution, which transfers the payment from the issuer's bank to the holder's bank.
Notes issued by the customer can also be returned to the supplier prior to the maturity date if, for example, the note had been issued as a deposit, advance payment, or as payment for existing customer invoices.
When a promissory note or future dated check is received as payment for goods or services, it is called a Note Receivable.
Prerequisites to complete notes receivables:
1. Define a Receipt class with notes receivables enabled
2. Create & Complete a normal transaction
We can classify the notes receivables based on their remittance method
Ø Standard remittance notes receivables
Ø Factored remittance notes receivables
Standard remittance
1. N:àreceiptsàreceipts
2. Enter receipt payment method, receipt number, receipt amount, * notes receivable issuer details( in more tab page)
3. Apply the receipt amount to the completed transaction.
Process of remitting:
1. N:à receiptsàremittance
2. select the remittance method, receipt class, receipt payment method, bank etc
3. Click on manual/ auto create
4. Select the receipt à approveà format.
Note: the status will be started approvalàcompleted approvalàstarted formattingà completed formatting
5. Go to receipt the status changes from conformed to remitted
6. N:à toolsà view accounting (to see the accounting entries)
7. Go to cash management and reconcile the receipt with bank statement
8. In receipt the status changes from remitted to cleared
9. N:à toolsà view accounting(to see the accounting entries)
Factored remittance
Prerequisite:Define a Receipt Class & the Remittance method should be Factored/Standard &Factoring
Procedure: to create the receipt
1. N:à receiptsà receipts
2. Create a receipt payment method, receipt amount, * notes receivable issuer details (in more tab page)
3. Apply the receipt amount to the completed transaction.
Process: for remittanceN:à receiptsà remittance
Select the remittance method as factor, receipt class, payment method, bank etc
Click on manual / auto createà select the receiptà approveà format
The status becomes completed formatting.
In receipt the status changes from conformed to remitted
6. Switch over to Cash Management and reconcile the receipt with the bank statement. The status of the receipt changes from remitted to cleared
1. Run the clear/ risk elimination program and see the status and entries in receipt
Balance Forward Billing
Step 1 - Set Up System Option
Select Show Billing Number option (Trans & Customers Tabbed Region) check box to display the forward billing number in Receivables windows and reports.
Step 2 - Define Payment Terms
Create one or more proxima payment terms for use with consolidated billing invoices. The Consolidated Billing Invoice program uses the cutoff date and payment terms that you specify in the submission parameters to select the transactions to include on a consolidated billing invoice.
When defining proxima payment terms for consolidated billing, perform the following:
· Enter a Cutoff Day - The program uses this day to select transactions for a consolidated billing invoice.
· Enter a single due date in the Day of Month field - You cannot use multiple due dates (i.e. split payment terms) with consolidated billing invoices. Additionally, when defining the due date, enter a value for the Months Ahead field. Do not enter a value in the Days or Date fields; the Consolidated Billing Invoice program does not use either field.
You can define more than one payment term for use with consolidated billing invoices. These payment terms can use the same or a different cutoff day. When printing consolidated billing invoices, you can specify which payment term to use.
Step 3 Define - New or Update Existing Customer Profiles
A customer's profile class indicates whether a customer should receive consolidated billing invoices and whether the invoice format is Detail or Summary. The profile class also determines the payment term on the consolidated billing invoice.
Consolidated billing invoices are generated at the bill-to site only. Customers with multiple bill-to sites cannot receive a single invoice that consolidates transactions across customer sites.
If a customer has multiple bill-to sites, the level at which you define a consolidated billing profile class determines the number of consolidated bills that are printed for that customer. When you define a consolidated billing profile class at the customer level only, Receivables will print many consolidated billing invoices, one for each bill-to site. When you define a consolidated billing profile class at a bill-to site only, Receivables will print a single consolidated billing invoice specific to that bill-to site.
Update the profile class at the customer and/or the customer site level to enable consolidated billing:
· Check the Enable (X) check box.
· Choose a consolidated billing format.
Choose a Format of Summary, Detail, or Imported. Choose the Detail format to list the item description, quantity, and unit price for each item on each invoice; choose the Summary format to list only the total amount of each transaction.
Attention: The Imported format is for use with the Imported Billing Number feature. The Imported format will not be printed through the Consolidated Billing Print program. Use custom invoices instead.
Assign a proxima payment term and uncheck the Override Terms box.
You must assign a proxima payment term at either the customer site or the business purpose level for any bill-to site that you want to send a consolidated bill to.
Do not check the Override Terms box on the customer profile. The Consolidated Billing Invoice program ignores the payment terms assigned to individual invoices when selecting transactions. Receivables, however, uses the payment terms on individual invoices to calculate aging and finance charges. If you check this box, then individual invoices may have payment terms that are different from the consolidated bill's payment terms. Consequently, a customer could receive a consolidated bill that includes invoices that are already past due and incurring finance charges.
By not checking the Override Terms box, Receivables automatically defaults payment terms for invoices from the customer profile. All invoices for a given bill-to site, therefore, will have the same payment term as the consolidated billing invoice.
Suggestion: If you want to print a consolidated billing invoice for all of a customer's bill-to sites, enable consolidated billing at the customer level and enter the proxima payment term at the business purpose level for all the bill-to sites.
Exhibit Customer Profile Transactions-Terms
Consolidated Bill
1. Enter Transactions and Create Accounting
2. Submit Concurrent Program (Request or Function)
Next Period
Receipts
Use the Receipts window to enter new or query existing receipts. For each receipt, you can see whether the receipt is identified and what portion of the receipt has been applied, placed on-account, and left unapplied.
You can enter two types of receipts in Receivables:
Ø Standard: Payment (such as cash or a check) that you receive from your customers for goods or services.
Ø Miscellaneous: Revenue earned from investments, interest, refunds, and stock sales.
You can apply receipts to invoices, debit memos, deposits, guarantees, on-account credits, and chargebacks. You can partially or fully apply a receipt to a single debit item or to several debit items. You can enter receipts and apply them to transactions in either Open or Future accounting periods. You can also create chargebacks or adjustments against these transactions.
If you do not specify a customer for a receipt, the receipt is unidentified. In this case, the receipt amount appears in the Unidentified field in the Receipts window. You cannot apply an unidentified receipt.
Note: You can view the detail accounting lines for an existing receipt 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.
Receipt StatusA receipt can have one of the following statuses:
· Approved: This receipt has been approved for automatic receipt creation. This status is only valid for automatic receipts.
· Confirmed: For manually entered receipts, this status indicates the receipt belongs to a receipt class that requires remittance. For automatic receipts, this status indicates the receipt has been confirmed.
· Remitted: This receipt has been remitted. This status is valid for both automatic and manually entered receipts.
· Cleared: The payment of this receipt was transferred to your bank account and the bank statement has been reconciled within Receivables. This status is valid for both automatic and manually entered receipts.
· Reversed: This receipt has been reversed. You can reverse a receipt when your customer stops payment on a receipt, if a receipt comes from an account with non-sufficient funds or if you want to re-enter and reapply it in Receivables. You can reverse cash receipts and miscellaneous transactions.
Standard Receipts
1. Enter the receipt information, including Receipt Number, Currency, Receipt Amount, GL Date, and Receipt Date. The default Receipt Date is the current date, but you can change it. If the Receipt Date is not in an open period, Receivables changes the GL Date to the last date of the most recent open period. You can change the GL Date, but it must be in an open or future period.
You can enter transactions in any currency defined in the system if you have at least one remittance bank account with a Receipts Multi-Currency flag set to Yes. If no such bank account exists, you are limited to entering only those currencies in which bank accounts exist. (The currency of a multiple currency bank account must be the same as your functional currency.)
If the currency for this receipt is different from your functional currency and you have not defined daily conversion rates, enter exchange rate information.
2. Enter a Payment Method. Receivables use the payment method to determine the accounting and remittance bank accounts for this receipt. You can only select payment methods that have remittance bank accounts that are in the same currency as the receipt.
3. If you are using manual document numbering, enter a unique Document Number. If you are using automatic document numbering, Receivables assigns this transaction a unique number when you save.
4. To help identify the customer for this receipt, enter a Transaction number (optional). Receivables display the customer associated with this transaction. If multiple customers have transactions with the number you entered, Receivables displays a window from which you can select a customer. If you enter a number here, Receivables displays the customer number in the Applications window when you apply this receipt.
5. If you did not enter a Transaction number and the receipt is not unidentified, enter customer information for this receipt, including Customer Name or Number and Bill-To Location. When you enter the customer, Receivables enters this customer's primary Bill-To Location, if one exists (you can change this value). If the system option Require Billing Location for Receipts is set to Yes, you must enter a Bill-To Location.
Attention: If you do not enter a Bill-To Location and the customer has no statement site, any unapplied or on-account receipt amounts will not appear on statements sent to this customer.
6. If you are manually entering an automatic receipt, enter a Bank Name or Account Number.
7. Open the Remittance tabbed region, then enter the receipt Deposit Date (optional). The default is either the deposit date entered at the batch level or, if there is no batch information, the receipt date. The default receipt maturity date is the deposit date.
8. Receivables derive the default remittance bank account from the payment method you entered. You can accept this value or enter any bank account assigned to the payment method if the bank account is in the same currency as that of the receipt or the Multi-Currency flag for the remittance bank is set to yes. Only bank accounts that are in your functional currency can accept multiple currency deposits.
9. To prevent the receipt Remittance bank from being automatically overridden during the remittance process, choose Don't Allow in the Override Bank Account field (optional). If you choose Allow, Receivables can automatically change the receipt remittance bank to the remittance batch bank during the remittance process.
10. If bank charges apply, enter an amount for Bank Charges. Bank charges may apply if the receipt's creation status is 'Cleared' (the clearance method of the associated receipt class must be set to 'Directly').
11. Save your work. If you entered a customer, the receipt amount appears in the unapplied field. Otherwise, the entire receipt amount appears in the unidentified field.
- Enter Header level information only
To view the accounting entries Tools>View Accounting
Accounting Entries for Unidentified Receipt
Unapplied Receipt:
- Enter the Customer Name and Press Tab button amount transferred from Unidentified to Unapplied
- View the accounting for Unapplied Receipt
Applied Receipt:
Press from the receipt window and enter specific transaction you can see the particular transaction or all the transaction of the customer.
On Account Receipts:
1. Enter Receipt & select customer
2. Press Apply button
3. Select “On Account” from the list of values and save.
Accounting for On Account Receipt
Chargeback (Receipt) Transaction
1. Enter Normal Transaction
2. Enter Partial Receipt
3. Apply receipt amount to transaction & create chargeback
4. Find Chargeback Transaction
Apply to Transaction & Save
· Enter the Type as Chargeback
· Enter the new due date and save, system will assign a Chargeback Number.
· Query the charge back Transaction from Transaction window.
- Transaction Class & Type will be Chargeback.
- Due date will be the date which you entered at the time of chargeback in Receipt.
Press more tab and see the Original Transaction number applied to Chargeback
Query Original Transaction
· The balance of Original Transaction will be Zero.
· Whenever you receive the amount from the customer apply that amount to Chargeback Transaction.
Receipt Adjustments
Prerequisites
· Receivable Activity
Process:
· Enter Standard Receipt
· Apply to Open Transaction
· Apply to Adjustments & Select Adjustment Activity
Apply to Open Transaction
Select Activity Name from List of Values and save, system will assign a number for adjustment
Apply to Adjustment & Selecting Activity Name
Activity names
Accounting entry for adjustment & observe Transaction Number applied to (for Adjustment system will pickup account code combination from Receivable Activity which you selected for)
Accounting for Adjustment
10. Remittances
Standard Remittance
Prerequisites:
· Receipt Class
· Bank
Process:
1. Enter Receipt
2. Standard Remittance
3. Select Receipts
4. Approve
5. Format
Different Statuses of Remittance Batch
· Started Creation
· Completed Creation
· Started Approval
· Completed Approval
· Started Formatting
· Completed Format
Standard Receipt
Standard Remittance
Enter Dates, Remittance Method as Standard, Receipt Class, Payment Method, Bank Details and Press Receipt.
Selecting Receipt for Remittance
Select Receipts which you want to remit to Bank and save. Press Approve and system will populate a Decision Box press yes
After Completed Approval re-query remittance batch and press Format button system will populate a Decision Box Press Yes
Receipt Status will be changed from Confirmed to Remitted
After successful receipt remittance go to Cash management and Select receipt and press clear transaction (Manually clear receipt)
Receipt Status will be changed from Remitted to Cleared
View Receipt History from Receipt window
Factored Remittance
Prerequisites
· Receipt Class with Remittance method Factored or Standard and Factoring
Process Steps
a) Create Receipt
b) Remittance with Factoring
c) Select Receipt for which you want to Factor
d) Submit Approval/Format
e) Clear Transaction in CM(optional)
f) Run Automatic Clearing for Receipts Program
a) Create Receipt
b) Remittance with Factoring
c) Select Receipts for which you want to Factor
d) Submit Approval/Format
Your can submit format without submitting approval, first system will run approval process and after format process.
Receipt status will be changed from Confirmed to Remitted
View accounting entries for Confirmed and Factored Receipts
e) Clear Transaction in CM (optional)
After this process go to Cash Management and manually clear transaction
Accounting entry will be
Dr Cash
Cr Short Term Dept
And Receipt Status will changed from Remitted to Cleared
f) Run Request “Automatic Clearing for Receipts” and view output file
Automatic Clearing for Receipts
Automatic Clearing for Receipts Program output
After successful completion of the above program accounting entry will be
Dr Short Term Dept
Cr Factor
Receipt status will changed from Cleared to Risk Eliminated
Miscellaneous Receipts
Prerequisites:
· Miscellaneous Cash Receivable Activity
Process:
· Enter Receipt
· Select Receipt Type as Miscellaneous
· Select Activity Purpose from list of values
Accounting Entry for Miscellaneous Receipt
Payment Netting
You can net receipts in Receivables. To net receipts, you apply a receipt against another open receipt, and then apply the resulting unapplied receipt balance to a transaction.
Open receipts include receipts that have:
· Unapplied cash
· On-account cash
Attention: When netting receipts, both receipts must be in the same currency.
Prerequisites:
· Receivable Activity – Payment Netting
Process:
a) Create Standard Receipt ( On-Account/Unapplied)
b) Create another Standard Receipt & Apply to on Account/Unapplied receipt
a) Create one receipt and apply the amount to on account.
b) Create another receipt and apply to on account receipt and open transaction
Observe New Receipt applied amount
View Accounting Entry for new receipt
Observe old receipt i.e., On Account Receipt changed to Applied Receipt
Aging Buckets
Aging buckets are time periods you can use to review and report on your open receivables. For example, the 4-Bucket Aging bucket that Receivables provides consists of four periods: -999 to 0 days past due, 1 to 30 days past due, 31-61 days past due, and 61-91 days past due. When you create your Collections reports or view your customer accounts, you can specify an aging bucket and 'as of date', and Receivables will group the transactions and their amounts in the appropriate days past due period.
Aging Buckets
Ageing Report View
Invoices with Rules
Invoicing and accounting rules let you create invoices that span several accounting periods. Accounting rules determine the accounting period or periods in which the revenue distributions for an invoice line are recorded. Invoicing rules determine the accounting period in which the receivable amount is recorded.
You can assign invoicing and accounting rules to transactions that you import into Receivables using AutoInvoice and to invoices that you create manually in the Transactions window.
(i) Accounting Rules
Use accounting rules to determine revenue recognition schedules for your invoice lines. You can assign a different accounting rule to each invoice line. Accounting rules let you specify the number of periods and the percentage of the total revenue to recognize in each period.
You can also specify whether the accounting rules are of Fixed or Variable Duration. Accounting rules of Fixed Duration span a predefined number of periods. Accounting rules of Variable Duration let you define the number of periods during invoice entry.
You can also create rules that will defer revenue to an unearned revenue account. This lets you delay specifying the revenue recognition schedule until the exact details are known. When these details are known, you use the Actions wizard to recognize the revenue.
(ii) Invoicing Rules
Use invoicing rules to determine when to recognize your receivable for invoices that span more than one accounting period. You can only assign one invoicing rule to an invoice.
Receivables provide the following invoicing rules:
o Bill In Advance: Use this rule to recognize your receivable immediately (see Figure 1 - 31 below).
o Bill in Arrears: Use this rule if you want to record the receivable at the end of the revenue recognition schedule (see Figure 1 - 32 below).
(iii) Account Sets
Account sets are templates used to create revenue and offset accounting distributions for individual invoice lines with accounting rules. These account sets enable you to split revenue for a line over one or more revenue or offset accounts. To meet your business requirements, you can change account sets before the Revenue Recognition program is run. After the Revenue Recognition program is run, you can change the individual GL distribution lines and Receivables automatically creates reversing GL entries. AutoAccounting creates the initial revenue and offset account sets for your invoice.
Revenue Recognition
The Revenue Recognition program identifies all new transactions and creates the revenue distributions for those transactions. The distributions are created for all periods, even in periods whose status is Not Open, using the rules associated with the transactions.
A) Invoice with “Accounting Rule Fixed Duration” & “Invoicing Rule In Advance”
1) Define Invoicing and Accounting Rules
2) Complete Transaction Invoicing Rule In Advance
3) Assign Accounting Rule
4) Run Revenue Reorganization Program
5) View Accounting/Distribution
Define Invoicing and Accounting Rules
Transaction with Invoicing Rule In Advance
Assign Accounting rule
Run Revenue Reorganization Program
Commit Work:
Yes: If you want to create the distribution records generated by this submission.
No: If you want to review the distributions first in the Revenue Recognition Execution report without actually creating the distribution records.
View Distribution Line
B) Invoice with “Accounting Rule Fixed Duration” & “Invoicing Rule in Arrears”
1) Define Invoicing and Accounting Rules
2) Complete Transaction with Invoicing Rule In Arrears
3) Assign Accounting Rule
4) Run Revenue Reorganization Program
5) View Report
Complete Transaction with Invoicing rule In Arrears
Assign Accounting Rule
View Report
C) Invoice with “Accounting Rule Variable Duration” & “Invoicing Rule In Advance”
1) Define Invoicing and Accounting Rules
2) Complete Transaction with Invoicing Rule In Arrears
3) Assign Accounting Rule
4) Run Revenue Reorganization report
5) View Report
Define Invoicing & Accounting Rues
Assign Invoicing Rules
Assign Accounting Rules
View Report (Program Output)
D) Invoice with “Accounting Rule Variable Duration” & “Invoicing Rule In Arrears”
1) Define Invoicing and Accounting Rules
2) Complete Transaction with Invoicing Rule In Arrears
3) Assign Accounting Rule
4) Run Revenue Reorganization Program
5) View Report
Assign Invoicing Rule in Transaction
Assign Accounting Rule
View Report (Program Output)
Collections
Oracle Receivables integrates with Oracle Advanced Collections to provide you with a Complete collections management solution. With this integration, all collections Activities take place from within Advanced Collections. Advanced Collections enables a simpler, more automated collections process flow for users, yet also supports a more complex collections approach with many powerful
Features.
Simpler Process Flow
users work primarily within one main screen to easily review accounts, take promises, and process payments, adjustments, and disputes, all while recording the interaction with the customer. Additionally, the Advanced Collections Collector's Work Queue displays a high-level list of all actionable work assigned to or owned by a collections agent. In this manner, collections activities are effectively "pushed" to the user, creating a simpler and more efficient user experience.
Powerful Collections Functionality
Behind the scenes, Advanced Collections employs configurable collections strategies that determine various collections approaches for different segments of your customers. A strategy can be as complex as necessary to meet your business requirements. For example, a strategy can automatically send a reminder letter about an imminent payment due, then send a dunning letter, and finally push a task to a collector to personally call the delinquent customer.
Complete the Collections Checklist and Questionnaire in Oracle Advanced Collections. Evaluate Advanced Collections menus and responsibilities to configure user access of product functionality Customize the preconfigured dunning letters in Oracle Advanced Collections according to your business needs, if you are sending dunning letters. Install XML Publisher, if you are sending dunning letters. Schedule concurrent processes in Oracle Advanced Collections.
Collector's Work Queue
• Search tool, Collections header and tabs
• Profile with preconfigured metrics
• History, Account, Transaction, Aging, Notes, Tasks
• Assign collectors using the AR Collector field
• View collections information by customer, account, bill to, or delinquency data Levels
• Process payments, Create promises, Enter disputes
• View invoices using Oracle Bill Presentment Architecture
• Run Receivables and Collections reports
• Preconfigured delinquency creation engine
• Preconfigured customer scoring engine
• Configurable dunning
Note: You perform all dunning activities in Oracle Advanced Collections. However, Oracle receivables provides you with the Dunning Letter Reprint - Historical Receivables Only program so that you can reprint historical Days Overdue dunning letters that were sent to your customers in a previous release of Receivables. Use this program to conduct collections research for a specific customer.
Aging
Viewing Account Balances by Aging Bucket
Receivables let you view your customer's outstanding account balances by aging bucket. Aging buckets are time periods in which you age and can review your debit items. For example, you can define an aging bucket that includes all debit items that are 1 to 30 days past due. You can define your own aging buckets or customize the aging buckets that Receivables provides.
When you view your customer balances by aging bucket, Receivables calculates and displays the total outstanding amount and the credits not aged for unapplied cash, on-account cash, on-account credits, and cash claims. You can modify your display by specifying an aging bucket or by choosing to age or summarize open credits.
Receivables select a transaction for aging if its GL date is before or the same as the current date. Once selected for aging, Receivables uses the following formula to determine the number of days past due for each transaction:
(Current Date) - (Due Date) = Days Past Due
To view a customer's outstanding account balance by aging bucket:
1. Navigate to the Customer Accounts window.
2. Enter selection criteria in the Find Customer Accounts window. For example, enter a Collector, account Status, or the low and high values of outstanding Balances, Open Credits, Credit Limits, or Amounts Past Due to view only those accounts. Leave a field blank if you do not want to limit your query to accounts matching that criteria.
3. Choose Find.
4. Select the account to view, then choose Aging.
5. To modify your display, choose Find from the Query menu, then enter selection criteria. For example, enter the aging bucket to use, choose whether to Age or Summarize Open Credits, or whether to Include Receipts at Risk. Leave a field blank if you do not want to limit your display to transactions matching that criteria.
6. Choose Find.
7. To view past due transactions within a specific aging bucket, select the bucket to view, and then choose Account Details.
Alternate method:
1. Navigate to the Aging window.
2. In the Find Aging window, enter the Customer Name or Number and the Aging Bucket to view.
3. To limit your query, enter selection criteria. For example, enter a specific currency, choose whether to Age or Summarize Open Credits and to include receipts at risk. Leave a field blank if you do not want to limit your display to transactions matching that criteria.
4. Choose Find.
5. To view the past due transactions within an aging bucket, select the bucket to view, then choose Account Details.
Regular correspondence is an effective way to create and maintain good relationships with your customers. Receivables provides three ways to correspond with your customers: printing account statements, printing dunning letters, and making customer calls.
Receivables lets you view all previous customer correspondence in the Correspondence window. You can view all previous contact with your customers, including dunning letters, customer calls, and account statements in this window.
To view previous customer correspondence:
1. Navigate to the Correspondence window.
2. To limit your display to only certain accounts, enter selection criteria. For example, enter a Collector name, or a range of Call Actions, Follow-Up Dates, Customer Names, or Transaction Numbers to select only those accounts. Leave a field blank if you do not want to limit the search to accounts matching that criteria.
3. Choose Find.
To view a list of statements generated for a customer, select the account, then open the Statements tabbed region.
To view dunning letters sent to a customer, select the account, then open the Dunning Letters tabbed region.
Suggestion: You can navigate to the Record a Call window by selecting an item and then choosing Call. You can view details for an account by selecting an item and then choosing Account Details.
Payment Terms
Receivables lets you define standard payment terms for your customers to specify the due date and discount date for their open items. Payment terms can include a discount percent for early payment and you can assign multiple discounts to each payment term line. For example, the payment term '2% 10, Net 30' indicates that a customer is allowed a two percent discount if payment is received within 10 days; after 10 days, the entire balance is due within 30 days of the transaction date with no applicable discount.
You can use payment terms to determine the amount of each installment. Receivables lets you either distributes tax and freight charges across all installments, or allocates all freight and tax amounts in the first installment of a split term invoice. You can use prepayment payment terms to indicate which business transactions require prepayment for goods and services. Receivables displays the active payment terms you define as list of values choices in the Customers, Customer Profile Classes, and Transactions windows.
Default Payment Terms Hierarchy
Receivables use the following hierarchy to determine the default payment term for your transactions, stopping when one is found:
1. Bill-to site
2. Customer Address
3. Customer
4. Transaction Type
Predefined Payment Terms
Receivables provides the following predefined payment terms:
· 30 NET: The balance of the transaction is due within 30 days.
· IMMEDIATE: The balance of the transaction is due immediately (i.e. on the transaction date). You can use this payment term with your chargebacks and debit memos.
Payment term window reference:
Name: Enter the Name of this payment term.
Base Amount: Enter the Base Amount for this payment term.
The default is 100, but you can change it. The base amount is the denominator for the ratio Receivables uses to determine the amount due for installments of invoices to which you assign this payment term. The sum of the relative amounts for all of the payment schedules that you define for these payment terms must be equal to the value that you specify as a base amount.
Allow Discount on Partial Payments: If you do not want to let your customers take discounts for partial payments on items associated with this payment term, then uncheck both the Allow Discount on Partial Payments check box as well as the check box for the Discount on Partial Payment system option.
Prepayment: Select the Prepayment check box if you are defining a prepayment payment term.
Receivables feeder systems, such as Oracle Order Management, can optionally implement business processes around prepayment payment terms to indicate that a particular business transaction requires the capture of funds before the delivery of a product or service.
Credit check: To associate a credit check with this payment term, check the Credit Check box.
Oracle Order Management uses this information to determine when to place an order on hold.
In Oracle Order Management, if the profile for an address does not have credit checking limits defined in a particular currency but the customer does, then the order passes credit check. If the address does not have limits in the currency and neither does the customer, then the order is compared to the customer limit in that currency.
Installment Options: Enter the Installment Option for items assigned to this payment term. This indicates how Receivables will allocate the freight and tax charged to transactions using this payment term. Choose 'Include tax and freight in first installment' to include all tax and freight charges in the first installment. Choose 'Allocate tax and freight' to distribute tax and freight charges across all installments.
Cutoff Days: If this payment term uses proxima terms, enter a Cutoff Day for inclusion in the monthly billing cycle. You can either enter a Day of the Month or select the Last Day of Month check box. Select the Last Day of Month check box to create a payment term to use with a consolidated billing invoice that includes all transactions created during the month that you specify.
If you are using the Consolidated Billing Invoices program, then you must enter values for the Day of Month and Months Ahead fields in the Due region of the Payment Schedule. Consolidated Billing does not use the Days or Date fields in the Due region.
Customers who use payment terms where the value for the Cutoff Day is greater than the value in the Due: Day of Month field should not enter a value of 0 in the Months Ahead field. This will result in the following erroneous scenario:
· Cutoff Day = 25
· Day of the Month = 15
· Months Ahead = 0
In this example, a consolidated billing invoice that is created on January 25 will be due before its creation date on January 15. To avoid this scenario, you must enter a value that is greater than 0 in the Months Ahead field.
Print Lead Days: If you want transactions assigned to this payment term to be printed before the due date, enter a number of Print Lead Days. Receivables will print this transaction x number of days before the due date, where x is the number of days you enter here.
Discount Basis: Enter the Discount Basis you want Receivables to use when calculating discounts for your invoices. Choose one of the following discount methods:
Invoice Amount: Choose this option to calculate the discount amount based on the sum of the tax, freight charges, and line amounts of your invoices.
Lines Only: Choose this option to calculate the discount amount based on only the line amounts of your invoices.
Lines, Freight Items and Tax: Choose this option to calculate the discount amount based on the amount of line items, freight, and tax of your invoices, but not freight and charges at the invoice header level.
Lines and Tax, not Freight Items and Tax: Choose this option to calculate the discount amount based on the line items and their tax amounts, but not the freight items and their tax lines, of your invoices.
Seq: Enter a line number for the installment term that you are defining in the 'Seq' field. Enter a higher number for each installment term with a later due date. For example, if you create terms with 50% due in 15 days and 50% in 30 days, enter '1' in this field for the first line and '2' for the second line.
Relative Amount: Enter the Relative Amount for this payment term. This is the numerator of the ratio that Receivables uses to determine the amount due for this installment of these payment terms. The sum of the relative amounts for all of the payment schedules that you define for each payment term must be equal to the base amount for this term.
Days: Enter the number of Days after the invoice date that payment is due for this installment term (optional). For split payment terms, this number indicates the number of days after the invoice date that an installment is due.
Date: Enter the Date on which payment is due for this installment term (optional). If you do not complete this field, enter a value for either Due Days or both Day of Month and Months Ahead.
Day of Month: If you are defining proxima terms, enter the Day of Month that payment is due for this installment term. For example, if payment is due on the fifteenth of each month, enter '15.'
Months Ahead: If you are defining proxima terms and you entered a value for Day of Month, enter the Months Ahead to which this installment term of the proxima terms refer. For example, if you entered '15' for Day of Month and you enter '2' here, an invoice dated in May will have a due date of July 15.
% : Enter the discount percentage and number of Days for this payment term. For example, to give customers using this payment term a two percent discount if payment is received within ten days, enter '2' and '10' respectively.
Days: To limit the period of time that the discount for this installment's discount line will be active, enter the Date, day of the Month, and the number of Months Ahead for this discount's expiration date. Receivables uses these values to calculate the discount date during invoice entry.
Transaction Types:
Use transaction types to define the accounting for the debit memos, credit memos, on-account credits, chargebacks, commitments, invoices, and bills receivable you create in Receivables. Transaction types also determine whether your transaction entries update your customers' balances and whether Receivables posts these transactions to your general ledger.
If AutoAccounting depends on transaction type, Receivables uses the general ledger accounts that you enter here, along with your AutoAccounting rules, to determine the default revenue, receivable, freight, tax, unearned revenue, unbilled receivable, finance charges, and AutoInvoice clearing accounts for transactions you create using this type. For bills receivable, the accounts that you enter here determine the bills receivable, unpaid bills receivable, remitted bills receivable, and factored bills receivable accounts for a bill receivable.
You can associate transaction types with your invoice sources in the Transaction Sources window to speed data entry in the Transactions and Credit Transactions windows. Active transaction types appear as list of values choices in the Transactions, Reverse Receipts, Credit Transactions, and Transaction Sources windows, and for bills receivable in the Bills Receivable and Receipt Classes windows.
You can also define credit memo and invoice transaction types to use with AutoInvoice.
You should define your transaction types in the following order:
· credit memo transaction types
· invoice, debit memo, and chargeback transaction types
· bills receivable transaction types
· commitment transaction types
You must define your invoice transaction types before you define your commitment types.
Natural Application and Allow Overapplication Rules
The transaction type that you assign to a transaction indicates the type of application that is permitted for that transaction: natural application only, or overapplication.
The Natural Application Only and Allow Overapplication options determine how applications can affect the balance due for transactions using this type. Natural Application refers to the type of application, either positive or negative, that a transaction requires to become closer to zero. For example, invoices have a positive balance, so to reduce the balance due you need to create a negative application (such as apply a receipt).
Overapplication indicates whether you can overapply transactions using this type. For example, if you apply a $500 receipt to a $400 invoice, you overapply the invoice and reverse its sign (from positive to negative).
Window Reference:
Note:-The Operating Unit field is provided to support functionality planned for a future release.
Name: Enter a Name and Description for this transaction type.
Class: Enter a Class for this transaction type. Choose from the following classes: Invoice, Chargeback, Credit Memo, Debit Memo, Deposit, or Guarantee.
If you choose Deposit or Guarantee, Receivables sets Open Receivable and Post to GL to Yes, Allow Freight, Tax Calculation, and Allow Overapplication to No, Creation Sign to 'Positive Sign,' and Natural Application Only to Yes. You cannot change these options.
Open Receivable: If Open Receivable is set to Yes, Receivables updates your customer balances each time you create a complete debit memo, credit memo, chargeback, or on-account credit with this transaction type. Receivables also includes these transactions in the standard aging and collection processes.
If this transaction type's class is not Deposit or Guarantee, indicate whether you want transactions with this type to update your customer balances by checking or unchecking the Open Receivable box.
Post to GL: To be able to post transactions with this type to your general ledger, check the Post To GL box. The default is the value you specified for the Open Receivables option. This box must be checked if the class is Deposit or Guarantee.
Terms: Enter the payment Terms to use for transactions with this transaction type.
Any payment terms entered at the customer level will override the payment terms that you enter here.
Printing Option: Choose a default Printing Option for transactions with this transaction type. Choose Print or Do Not Print. You can override this value when entering transactions.
Transaction Status: Choose a Transaction Status of Open, Closed, Pending, or Void. Use these statuses to implement your own invoice approval system. Enter 'Void' to void debit memos, on-account credits or invoices to which you assign this transaction type.
Allow Freight: To allow freight to be entered for transactions with this transaction type, check the Allow Freight box.
Tax Calculation: To let Receivables calculate tax for transactions with this transaction type, check the Tax Calculation box.
If you do not check this box, the Tax Code field in the Lines window will be optional, not required. If you do not enter a tax code on the transaction line, then Receivables will not perform tax calculations or create tax accounting entries for transactions with this transaction type (this is also true for transactions in Oracle Order Management and Oracle Sales and Marketing).
Creation Sign: Choose a Creation Sign. The default is Positive Sign for transaction types with a class of either Guarantee or Deposit. If you are using the Cash Basis accounting method, your transaction's creation sign must be Positive Sign, Negative Sign, or Any Sign. You cannot update this field after you enter transactions with this type.
Natural Application only: If this transaction type's class is not Deposit or Guarantee and you want to restrict the direction in which items with this transaction type can be updated by applications entered against them, check the Natural Application Only box. If you check this box, Receivables sets Allow Overapplication to No.
Note: If the Allow Overapplication box is checked and you then check the Natural Application Only box, Receivables automatically uncheck the Allow Overapplication box. To check the Allow Overapplication box again, you must first manually uncheck the Natural Application Only box. You can update these options.
For Cash Basis accounting, both check boxes are unchecked and you cannot change these options. In this case, the balance of transactions with this transaction type can be updated in any direction in the same sign.
Application Rule Set: Enter an Application Rule Set for this transaction type or select one from the list of values (optional). An Application Rule Set determines the default payment steps when you use the Applications window or AutoLockbox to apply receipts to transactions using this type. If you do not enter a rule set, Receivables uses the rule set in the System Options window as the default.
If this transaction type's class is not Deposit or Guarantee, and you did not check the Natural Application Only box, choose whether to Allow Overapplication against items with this transaction type by checking or unchecking this box. You can update these options.
If you use the Cash Basis accounting method, the default value is No and you cannot change it.
Invoice Type: If this transaction type's class is either Deposit or Guarantee, enter the Invoice Type to use for invoices entered against commitments or deposits with this transaction type. When you enter an invoice against either a deposit or a guarantee with this transaction type, the value you enter here is the default invoice transaction type.
Credit Memo Type:If this transaction type's class is Deposit, Guarantee, Debit Memo, or Invoice, enter the Credit Memo Type to use when crediting items with this transaction type (optional). When you enter a credit memo against an invoice with this transaction type, the value you enter here is the default credit memo transaction type.
Accounts: If this transaction type's class is Invoice, Chargeback, Credit Memo, Debit Memo, or Guarantee, then define the accounting for this transaction type in the Accounts tabbed region.
Bills Receivables: If this transaction type's class is Bills Receivables, then complete these fields in the Bills Receivables tabbed region:
Bills receivable transaction types indicate the type of bill receivable, such as accepted bill, promissory note, or unsigned bill, and define accounting and other attributes for bills receivable. You enter a transaction class of 'Bills Receivable' to enable the Bills Receivable tabbed region for entering bills receivable transaction type information.
Use the Signed and Issued by Drawee boxes to identify the type of bill receivable for this transaction type according to the combinations in this table:
TYPE OF BILL | Signed | Issued by Drawee |
Requires acceptance | Checked | Unchecked |
Issued by drawee | Unchecked | Checked |
Unsigned bill | Unchecked | Unchecked |
Deposit: If this transaction type's class is Deposit, then complete these fields in the Deposit tabbed region:
In the Allocation Basis field, indicate how you want to apply the balance of deposits with this transaction type to transactions.
You can select Lines Only to apply deposits to invoice lines only. Or, you can select Lines, Tax and Freight to include tax and freight amounts on invoices when applying deposits to transactions.
If you set the AR: Deposit Offset Account Source profile option to Transaction Type, then Receivables uses the Offset Account that you specify here to derive the offset account for deposits. Otherwise, Receivables uses AutoAccounting to derive the deposit's offset account.
Transaction Sources
Batch sources control the standard transaction type assigned to a transaction and determine whether Receivables automatically numbers your transactions and transaction batches. Active transaction batch sources appear as list of values choices in the Transactions, Transactions Summary, and Credit Transactions windows, and for bills receivable in the Bills Receivable and Bills Receivable Transaction Batches windows.
Note: A batch source provides default information, which you can optionally change at the transaction level.
You can define two types of transaction batch sources:
· Manual: Use manual batch sources with transactions that you enter manually in the Transactions and Transactions Summary windows, and for bills receivable transactions.
Credit memos that are created by the Credit Memo workflow also use manual batch sources.
· Imported: Use imported batch sources to import transactions into Receivables using AutoInvoice.
You can make a batch source inactive by unchecking the Active check box and then saving your work. Receivables does not display inactive transaction batch sources as list of values choices or let you assign them to your transactions.
Bills receivable batch sources: After you define batch sources for bills receivable, enter a batch source in the profile option AR: Bills Receivable Batch Source.
Transaction Source window reference:
Note: The Operating Unit field is provided to support functionality planned for a future release.
Name: Enter a unique Name and a Description for this transaction source.
Type: Enter a Type of 'Manual' or 'Imported.' For bills receivable batch sources, enter 'Manual.'
Description: Enter the description
Effective Dates: Enter the range of Effective Dates for this source. The Start date is the current date, but you can change it. If you do not enter an end date, this transaction batch source will be active indefinitely.
Automatic Batch Numbering: If this is a Manual source and you want to automatically number new batches you create using this source, or if this is a Manual source for bills receivable and you want to generate bills receivable automatically, check the Automatic Batch Numbering box and enter a Last Number. For example, to start numbering your batches with 1000, enter 999 in the Last Number field. If you are defining an Imported transaction batch source, Receivables automatically numbers the batch with the batch source name - request ID.
Automatic Transaction Numbering: To automatically number new transactions you create using this source, check the Automatic Transaction Numbering box and enter a Last Number. You can use automatic transaction numbering with both Imported and Manual sources.
Note: Receivables automatically updates the Last Number fields, so you can review this batch source later and see the last transaction number that was generated (note that this number is only an approximation due to caching).
Document Number to Transaction Number box: To use the same value for both the document number and the transaction number for transactions assigned to this source, check the Copy Document Number to Transaction Number box (optional).
Suggestion: If your application uses Gapless document sequences, check this box if you require gapless transaction numbers. Checking this box ensures that transaction numbers are generated sequentially and there are no "missing" numbers.
Copy Transaction Information Flexfield to Credit Memo: Select the Copy Transaction Information Flexfield to Credit Memo check box if you want to copy an invoice's Transaction Information flexfield data to a related credit memo that uses this batch source (optional).
This check box is enabled only if this source's type is Manual.
Whenever you save a credit memo, Receivables checks the batch source. If the source type is Manual and the box is selected, then Receivables copies Transaction Information flexfield data, if available on the invoice, to the credit memo.
Receipts Handling for Credits:
Indicate your enterprise's policy for automatic receipt handling for imported credits against paid invoices (optional).
Set this option only if you want AutoInvoice to automatically evaluate imported credits for receipt handling.
· Select On Account if you want AutoInvoice to place any credit requests on account.
· Select Credit Card Refund if you want AutoInvoice to automatically create a credit card refund for the amount of the requested credit.
By default, no option is selected.
Note: This setting affects only transactions paid by credit card or purchase card. Transactions paid by other payment types are always put on account.
Additionally, only imported sources use this setting. Manual sources ignore any value entered here.
Reference Field Default Value: Enter the Invoice Transaction Flexfield attribute that you want to appear in the Reference field of the Transactions window. Receivables uses this to further identify the invoice and displays this value under the Reference column in the invoice list of values in the Applications window.
The default value is INTERFACE_HEADER_ATTRIBUTE1.
Standard Transaction Type: Enter the Standard Transaction Type for this batch source. When you choose a batch source during transaction entry, this is the default transaction type. You can define new transaction types in the Transaction Types window.
Credit Memo Batch Source: To number your credit memos created against invoices and commitments with this source differently than the invoices or commitments they are crediting, enter a Credit Memo Batch Source. Before you can assign a credit memo batch source, you must first define your credit memo batch sources using this window. If you do not specify a credit memo batch source, Receivables enters the invoice or commitment batch source here.
Standard Memo Lines
Standard memo lines are lines that you assign to a transaction when the item is not an inventory item (for example, 'Consulting Services'). You can assign memo lines to debit memos, on-account credits, debit memo reversals, chargebacks, commitments, and invoices. Receivables displays your standard memo lines as list of values choices during credit memo entry in the Credit Transactions window and during invoice entry in the Lines window. When you create chargebacks and debit memo reversals, you can either use the standard line that Receivables provides or enter your own. You can create an unlimited number of standard memo lines.
If AutoAccounting depends on standard line items, Receivables uses the revenue account that you enter here along with your AutoAccounting setup to determine the default revenue, freight, AutoInvoice Clearing, Tax, Unbilled Receivable, Unearned Revenue, and Receivable accounts for invoices with this line item.
Warning: When you enter a standard memo line in the Lines window, place the cursor in the Description field and then use the list of values to select a memo line. If AutoAccounting is based on Standard Lines and you type or copy the memo line information, Receivables will not generate the proper accounting entries for this line when you save.
Receivables lets you enter tax code, unit list price, and unit of measure information for each standard memo line. You can also specify a standard invoicing and accounting rule for each standard memo line.
Standard memo line window reference:
Note: The Operating Unit field is provided to support functionality planned for a future release.
Name: Enter the Name and a Description of this memo line. Receivables prints this description on your debit memo, on-account credit, debit memo reversal, chargeback, commitment, or invoice.
Note: If you are modifying your chargeback or debit memo reversal standard line, Receivables lets you embed variables within the text of your description. For example, you may want to print the receipt number on your debit memo reversals. To do this, enter & receipt_number & within your the text of your description. Receivable then prints the corresponding receipt number on your debit memo reversal. The following are valid variable types: receipt_number for debit memo reversals and invoice_number for invoices, chargebacks, and debit memos.
Type: Choose a line type of Chargeback Line, Charges, Debit Memo Receipt Reversal, Freight, Line, or Tax.
Tax Code: Enter the ad hoc tax code to associate with this standard line (optional). If you are defining a standard invoice line and AutoAccounting depends on tax codes, Receivables uses the tax code you enter here along with your AutoAccounting rules to determine the default tax account for invoices with this standard line.
Unit List Price: Enter the Unit List Price for this memo line (optional). Receivables displays this price on the debit memos, on-account credits, chargebacks, and invoices you create using this standard line.
Unit of Measure: If the type of this memo line is 'Line,' enter a Unit of Measure. Receivables defaults the unit of measure to this value when you choose this standard line item during invoice or memo entry.
Revenue Account : Enter the Revenue Account for this memo line (optional). When you create a debit memo or on-account credit, this revenue account will be the default for each standard memo line that you select. When you create debit memo reversals or chargebacks, Receivables uses the Revenue Flexfield from the original receivable item as the credit account. Therefore, Receivables does not let you specify a value for the Revenue Flexfield for your debit memo reversal and chargeback standard lines.
Note: AutoAccounting lets you use the values that you specify for the segments of your standard lines' revenue accounts to determine the revenue accounts of your invoices. Receivables uses these revenue account segment values in combination with the rest of your AutoAccounting structure to determine the default revenue, freight, AutoInvoice Clearing, Tax, Unbilled Receivable, Unearned Revenue, and Receivable accounts for invoices which include this standard invoice line.
Invoicing Rule: Enter the Invoicing Rule to use with this standard line (optional). Receivables does not currently use this information when you select a standard line (in the Lines window during invoice entry) to which you have assigned a standard invoicing rule. Oracle Order Management assigns standard invoicing rules to standard lines for orders that you import through AutoInvoice.
Accounting Rule: Enter the Accounting Rule to use with this standard line (optional). If you select a standard line during invoice entry to which you have assigned a standard accounting rule, Receivables uses this rule to determine this line's revenue recognition schedule. Oracle Order Management lets you assign standard accounting rules to standard lines for orders that you import through AutoInvoice.
Active Dates: Enter the range of Active Dates for this standard line. The start date is today's date, but you can change it. If you do not enter an end date, this memo line will be active indefinitely.
Note: You can have only one line type of Chargeback Line active at a time.
Accounting Rules
Define accounting rules to create revenue recognition schedules for your invoices. Accounting rules determine the number of periods and percentage of total revenue to record in each accounting period. You can use accounting rules with transactions that you import into Receivables using AutoInvoice and with invoices that you create manually in the Transaction windows. You can define an unlimited number of accounting rules.
When you run the Revenue Recognition program for an invoice that is associated with one or more accounting rules, Receivables creates the invoice's revenue distributions for the period or periods in which the rules fall.
Note: Revenue Recognition creates accounting distributions for all periods of status Open, Future, or Not Open. If any period has a status of Closed or Close Pending, then Revenue Recognition creates the distributions in the next Open, Future, or Not Open period.
Depending on your business needs, you may require deferred accounting rules, which you can create by selecting the Deferred Revenue check box during rule definition. Deferred accounting rules let you defer revenue to an unearned revenue account until you are ready to specify the revenue recognition schedule.
Attention: Invoicing and Accounting Rules are not applicable if you are using the Cash Basis method of accounting. If you use the Cash Basis method, AutoInvoice will reject any transaction lines that are associated with invoice or accounting rules.
If you want to credit an invoice that uses invoice and accounting rules to schedule revenue and billed receivable recognition, you can specify how you want to adjust this invoice's revenue account assignments by choosing a Rules Method in the Credit Memos window.
Accounting rule window reference:
Name: Enter a Name for this accounting rule.
Type: Enter an accounting rule Type. Enter 'Accounting, Fixed Duration' to prorate revenue recognition evenly over a predefined period of time. The revenue recognition schedule is always the same every time you choose this accounting rule. For example, if you have four schedules for your rule with this type, you will recognize twenty-five percent of your revenue at the end of each schedule.
Enter 'Accounting, Variable Duration' to be able to specify the number of periods over which you want to recognize revenue for invoices to which you assign this rule. You can assign this type of accounting rule to invoices that you manually enter in the Transaction window or import into Receivables using AutoInvoice. The revenue recognition schedule changes for invoices that are assigned this type of accounting rule depending upon the value that you either pass through AutoInvoice or specify when you manually enter an invoice.
Period: Enter the Period to use for your accounting rule schedule. You can choose from any of the Period Types you defined, but you can only choose a period type that has overlapping dates if it is an adjusting period. In addition, you can only choose 'Specific Date' as your period type for accounting rules to which you have assigned a type of 'Accounting, Fixed Duration.' You can only update this field for the accounting rule 'IMMEDIATE.'
Number of Periods: If this accounting rule type is 'Accounting, Fixed Duration,' enter the Number of Periods to use for your accounting rule schedule. For example, if you entered a period of 'Weekly' and you enter '3' here, Receivables creates a rule schedule for three weekly periods.
Deferred Revenue: If you want to delay specifying the revenue recognition schedule for this rule, check the Deferred Revenue check box. If you select this check box, then revenue is deferred to an unearned revenue account, and you must later use the Actions wizard to recognize the revenue.
Schedule: Define your revenue recognition schedule for this accounting rule. Enter the percentages of revenue to recognize within each period of your accounting rule.
· If this accounting rule type is 'Accounting, Fixed Duration,' Receivables displays a rule schedule according to the period and number of periods you entered. Receivables determines the schedule by evenly prorating all the revenue across all periods (you can change this information). The sum of all periods for this type must equal 100 percent.
· If this accounting rule type is 'Accounting, Variable Duration,' you do not need to enter any information. Receivables does not display the default rule schedule for an accounting rule of this type because the number of periods is unknown. However, if you want to recognize a specific revenue percentage in the first period, you can enter that percentage here. In this case, Receivables prorates the remaining revenue percentage across the remaining periods. Receivables uses the number of periods that you either pass through AutoInvoice or enter manually in the Transaction window to determine the payment schedule of your accounting rule.
· If this accounting rule type is 'Accounting, Fixed Duration,' and you choose Specific Date as your period, enter specific dates for each period of the revenue recognition schedule for this rule.
Deferred revenue Rules
You create deferred accounting rules by selecting the Deferred Revenue check box in the Invoicing and Accounting Rules window during rule definition. When you use deferred accounting rules, the Revenue Recognition program creates a single distribution per line that posts to an unearned revenue GL account. You later earn the revenue using the Actions wizard.
You can use deferred accounting rules only for invoices that are assigned the Bill in Advance invoicing rule. If the invoicing rule on a transaction is Bill in Arrears, the Revenue Recognition program ignores the deferred flag.
If you use a deferred accounting rule with a single accounting period, Receivables recognizes the revenue in the period that you specify with the Actions wizard.
If you use a deferred accounting rule with multiple accounting periods, Revenue Accounting creates the revenue recognition schedule based on the rule, and the start date is determined by the GL start date that you entered using the Actions wizard. If the GL start date occurs in a closed accounting period, Revenue Accounting posts that portion of revenue into the subsequent open accounting period.
If you use a non-deferred accounting rule with multiple accounting periods, Revenue Accounting uses the schedule created by the Revenue Recognition program. If an accounting period is closed, Revenue Accounting posts that portion of revenue into the subsequent open accounting period.
AutoAccounting
Define AutoAccounting to specify how you want Receivables to determine the general ledger accounts for transactions that you enter manually or import using AutoInvoice. Receivables creates default accounts for revenue, receivable, freight, tax, unearned revenue, unbilled receivable, finance charges, bills receivables accounts, and AutoInvoice clearing (suspense) accounts using this information.
You can control the value that AutoAccounting assigns to each segment of your Accounting Flexfield, such as Company, Division, or Account.
You must define AutoAccounting before you can enter transactions in Receivables. When you enter transactions in Receivables, you can override the default general ledger accounts that AutoAccounting creates.
AutoAccounting window reference:
Note: The Operating Unit field is provided to support functionality planned for a future release.
1. Enter the Type of account to define. Choose from the following:
· AutoInvoice Clearing: The clearing account for your imported transactions. Receivables use the clearing account to hold any difference between the specified revenue amount and the selling price times the quantity for imported invoice lines. Receivables only use the clearing account if you have enabled this feature for the invoice batch source of your imported transactions.
· Bills Receivable: The bills receivable account for your transaction. Receivables use this account when you exchange transactions for bills receivable.
· Factored Bills Receivable: The factored bills receivable account for your bills receivable transactions.
· Freight: The freight account for your transaction.
· Receivable: The receivable account for your transaction.
· Remitted Bills Receivable: The remitted bills receivable account for your bills receivable transactions.
· Revenue: The revenue and finance charges account for your transaction.
· Tax: The tax account for your transaction.
· Unbilled Receivable: The unbilled receivable account for your transaction. Receivables use this account when you use the Bill In Arrears invoicing rule. If your accounting rule recognizes revenue before your invoicing rule bills it, Receivables uses this account.
· Unearned Revenue: The unearned revenue account for your transaction. Receivables use this account when you use the Bill In Advance invoicing rule. If your accounting rule recognizes revenue after your invoicing rule bills it, Receivables uses this account.
· Unpaid Bills Receivable: The unpaid bills receivable account for your bills receivable transactions.
2. For each segment, enter either the table name or constant value that you want Receivables to use to get information. When you enter an account Type, Receivables displays all of the segment names in your Accounting Flexfield Structure. Segments include such information as Company, Product, Department, Account, and Sub-Account. Receivables lets you use different table names for different accounts. Choose one of the following table names:
· Bill To Site: Use the bill-to site of the transaction to determine this segment of your revenue, freight, receivable, AutoInvoice clearing, tax, unbilled receivable, and unearned revenue account.
· Drawee Site: Use the drawee site table to determine this segment of your bills receivable, factored bills receivable, remitted bills receivable, and unpaid bills receivable account.
· Remittance Banks: Use the remittance banks table to determine this segment of your factored bills receivable and remitted bills receivable account.
· Salesperson: Use the salesperson's table to determine this segment of your revenue, freight, receivable, AutoInvoice clearing, tax, unbilled receivable, and unearned revenue account. If you choose this option for your AutoInvoice clearing, tax, or unearned revenue accounts, Receivables uses the revenue account associated with this salesperson. If you choose this option for your unbilled receivable account, Receivables uses the receivable account associated with this salesperson. If the transaction has a line type of "LINE" with an inventory item of freight ("FRT"), AutoAccounting uses the accounting rules for the freight type account rather than the revenue type account.
· Standard Lines: Use the standard memo line or inventory item on the transaction to determine this segment of your revenue, AutoInvoice clearing, freight, tax, unbilled receivable, and unearned revenue account. If you choose this option for your AutoInvoice clearing, freight, tax, unbilled receivable or unearned revenue accounts, Receivables uses the revenue account associated to this standard memo line item or inventory item. If the transaction has a line type of "LINE" with an inventory item of freight ("FRT"), AutoAccounting uses the accounting rules for the freight type account rather than the revenue type account.
· Taxes: Enter this option to use tax codes when determining your tax account.
· Transaction Types: Use the transaction types table to determine this segment of your revenue, freight, receivable, AutoInvoice clearing, tax, unbilled receivable, and unearned revenue account, and of your bills receivable, factored bills receivable, remitted bills receivable, and unpaid bills receivable account. If the transaction has a line type of "LINE" with an inventory item of freight ("FRT"), AutoAccounting uses the accounting rules for the freight type account rather than the revenue type account.
3. If you did not enter a Table Name, enter a Constant value for this segment, or select one from the list of values.
Enter a Constant value if you want AutoAccounting to always use the same value for this Accounting Flexfield segment. Be sure to enter information that is valid for this segment. For example, if you defined your Company flexfield segment as a two-character segment with valid values ranging from 00 to 10, you must enter a two-character value within this range.
Approval Limits
Use the Approval Limits window to define approval limits for adjustments created in Receivables, requests for credit memos initiated from iReceivables, and write-offs for receipts.
When you enter an adjustment that is outside your approval limit range, Receivables assigns the adjustment a status of Pending until someone with the appropriate approval limits either approves or rejects it.
Receivables use approval limits that have a document type of Adjustment when you create an adjustment in the Adjustments, Submit Auto Adjustments, and Approve Adjustments windows.
The Credit Memo Request Approval Workflow uses approval limits that have a document type of Credit Memo when forwarding credit memo requests from iReceivables. The workflow sends a notification to an approver if the request is within the approval limit range for the currency and reason code specified.
When you write off an unapplied receipt amount or an underpayment on a receipt, Receivables uses approval limits that have a document type of Receipt Write-off. You cannot write off a receipt amount that is outside your approval limit range.
You define Adjustment approval limits by currency and dollar amount. You define Credit Memo approval limits by reason type, currency, and dollar amount. You define Receipt Write-off approval limits by currency and dollar amount. The approval limits for write-offs are separate from, but cannot exceed, the system level write-off amounts that you define in the System Options window. You must specify both lower and upper approval limits for each approver.
Receivables Activities:
Define receivables activities to default accounting information for certain activities, such as miscellaneous cash, discounts, finance charges, adjustments, and receipt write-off applications.
Activities that you define appear as list of values choices in various Receivables windows. You can define as many activities as you need.
The Tax Code Source you specify determines whether Receivables calculates and accounts for tax on adjustments, discounts, finance charges, and miscellaneous receipts assigned to this activity. If you specify a Tax Code Source of Invoice, then Receivables uses the tax accounting information defined for the invoice tax code(s) to automatically account for the tax. If the Receivables Activity type is Miscellaneous Cash, then you can allocate tax to the Asset or Liability tax accounts that you define for this Receivables Activity.
Receivables uses finance charge activity accounting information when you assess finance charges in your statements and dunning letters.
Query the Chargeback Adjustment activity that Receivables provides and specify GL accounts for this activity before creating chargebacks in Receivables.
You can make an activity inactive by unchecking the Active check box and then saving your work.
Attention: Once you define an activity, you cannot change its type. However, you can update an existing activity's GL account, even if you have already assigned this activity to a transaction.
Activity Types
An activity's type determines whether it uses a distribution set or GL account and in which window your activity appears in the list of values. You can choose from the following types:
Adjustment: You use activities of this type in the Adjustments window. You must create at least one activity of this type.
Note: In the Adjustments window, you cannot select the Adjustment Reversal, Chargeback Adjustment, Chargeback Reversal, and Commitment Adjustment activities to manually adjust transactions. These four activities are reserved for internal use only.
When you reverse a receipt, if an adjustment or chargeback exists, Receivables automatically generates off-setting adjustments using the Adjustment Reversal and Chargeback Reversal activities. When your customers invoice against their commitments, Receivables automatically adjusts the commitment balance and generates an off-setting adjustment against the invoice using the Commitment Adjustment activity.
Bank Error: You use activities of this type in the Receipts window when entering miscellaneous receipts. You can use this type of activity to help reconcile bank statements using Oracle Cash Management.
Claim Investigation: You use activities of this type in the Receipts Applications and QuickCash windows when placing receipt overpayments, short payments, and invalid Lockbox transactions into claim investigation. The receivable activity that you use determines the accounting for these claim investigation applications. For use only with Oracle Trade Management.
Credit Card Refund: You use activities of this type in the Receipts Applications window when processing refunds to customer credit card accounts. This activity includes information about the General Ledger account used to clear credit card refunds. You must create at least one activity of this type to process credit card refunds.
Earned Discount: You use activities of this type in the Adjustments and the Remittance Banks windows. Use this type of activity to adjust a transaction if payment is received within the discount period (determined by the transaction's payment terms).
Endorsements: The endorsement account is an offsetting account that records the endorsement of a bill receivable. This is typically defined with an Oracle Payables clearing account.
Finance Charge: You use activities of this type in the Customers and System Options window. You must define a finance charge activity if you include finance charges on your statements or dunning letters.
Miscellaneous Cash: You use activities of this type in the Receipts window when entering miscellaneous receipts. You must create at least one activity of this type.
Payment Netting: You use activities of this type in the Applications window and in the QuickCash Multiple Application window when applying a receipt against other open receipts.
The GL Account Source field defaults to Activity GL Account and you must enter a GL account in the Activity GL Account field. The GL account that you specify will be the clearing account used when offsetting one receipt against another receipt. The Tax Code Source field defaults to None.
You can define multiple receivables activities of this type, but only one Payment Netting activity can be active at any given time.
Prepayments: Receivables uses activities of this type in the Applications window when creating prepayment receipts. When the Prepayment activity type is selected, the GL Account Source field defaults to Activity GL Account and you must enter a GL account in the Activity GL Account field. The GL account that you specify will be the default account for prepayment receipts that use this receivables activity. The Tax Code Source field defaults to None. You can define multiple receivables activities of this type, but only one prepayment activity can be active at any given time.
Receipt Write-off: You use activities of this type in the Receipts Applications and the Create Receipt Write-off windows. The receivable activity that you use determines which GL account is credited when you write off an unapplied amount or an underpayment on a receipt.
Short Term Debt: You use activities of this type in the GL Account tabbed region of the Remittance Banks window. The short-term debt account records advances made to creditors by the bank when bills receivable are factored with recourse. Receivables assigns short-term debt receivables activities to bills receivable remittance payment methods.
Unearned Discount: You use activities of this type in the Adjustments and the Remittance Banks windows. Use this type of activity to adjust a transaction if payment is received after the discount period (determined by the transaction's payment terms).
Auto cash Rule Sets:
Define AutoCash Rule Sets to determine the sequence of AutoCash Rules that Post QuickCash uses to update your customer's account balances. You specify the sequence and the AutoCash Rules for each AutoCash Rule Set. The AutoCash Rule Sets you define display as list of values choices in the Customers, Customer Addresses, Customer Profile Classes, and the System Options windows. Post QuickCash first checks the customer site, then the customer profile class, and finally at the system options level to determine the AutoCash Rule Set to use.
Receivables provides a default AutoCash Rule Set when you assign a customer to a credit profile, but you can modify individual AutoCash Rule Set assignments at both the customer and customer site levels. If you do not assign an AutoCash Rule Set to a customer's credit profile, and you enter a receipt for this customer, Receivables uses the AutoCash Rule Set that you entered in the System Options window along with the number of Discount Grace Days you specified in this customer's credit profile to apply the receipt. If you assign an AutoCash Rule Set to a customer, but none of the AutoCash Rules apply, Receivables places the remaining amount Unapplied or On-Account, depending on how you set the Remaining Remittance Amount option for the rule set.
If you have set up your system to use bank charges and a tolerance limit, Post QuickCash will also consider these amounts if the current AutoCash rule fails (this is true for all rules except 'Apply to the Oldest Invoice First'). If it finds a match, Post QuickCash applies the receipt; otherwise, it looks at the next rule in the sequence.
You can disable an existing AutoCash Rule Set by changing its status to Inactive and then saving your work.
AutoCash Rule set window reference:
Name: Enter the Name of this AutoCash rule set.
Description: Enter a description for this AutoCash rule set (optional).
Discounts: Enter the type of Discount you want to automatically give to your customer for this AutoCash Rule Set. Choose one of the following Discount options:
· Earned Only: Your customer can take earned discounts according to the receipt terms of sale. You negotiate earned discount percentages when you define specific receipt terms. You can enter this option if Allow Unearned Discounts is set to Yes in the System Options window. In this case, Receivables only allows earned discounts for this AutoCash Rule Set.
· Earned and Unearned: Your customer can take both earned and unearned discounts. An unearned discount is one taken after the discount period passes. You cannot choose this option if the system option Unearned Discounts is set to No.
· None: Your customer cannot take discounts (this is the default).
Items in Dispute: To include transactions in dispute when calculating your customer's open balance, check the Items in Dispute check box.
Finance Charges: To include finance charges when calculating your customer's open balance, check the Finance Charges check box.
Automatic Matching Rule
Remaining Remittance Amount: If this rule set will include the Apply to the Oldest Invoice First rule, choose how you want to apply any Remaining Remittance Amount. Receivables uses this value to determine how to enter the remaining amount of the receipt if none of the AutoCash Rules within this rule set apply. Choose 'Unapplied' to mark remaining receipt amounts as Unapplied. Choose 'On-Account' to place remaining receipt amounts On-Account.
Apply Partial Receipts: To automatically apply partial receipts when using the Apply to the Oldest Invoice First rule, check the Apply Partial Receipts check box. A partial receipt is one in which the receipt minus the applicable discount does not close the debit item to which this receipt is applied.
The applicable discount that Receivables uses for this rule depends upon the value you entered in the Discounts field for this AutoCash Rule Set. If you exclude finance charges (by setting Finance Charges to No) and the amount of your receipt is equal to the amount of the debit item to which you are applying this receipt minus the finance charges, Receivables defines this receipt as a partial receipt. In this case, Receivables does not close the debit item because the finance charges for this debit item are still outstanding.
If Apply Partial Receipts is set to No, this AutoCash Rule Set will not apply partial receipts and will either mark the remaining receipt amount 'Unapplied' or place it on-account, depending on the value you entered in the Remaining Remittance Amount field
Seq: Enter a Sequence number to specify the order of each rule in this AutoCash Rule Set (optional). Receivables uses the rule assigned to sequence 1, then sequence 2, and so on when applying receipts using this AutoCash Rule Set.
Auto Cash Rule: Enter one or more AutoCash Rules for this AutoCash rule set. Choose from the following AutoCash rules:
Apply to the Oldest Invoice First: This rule matches receipts to debit and credit items starting with the oldest item first. This rule uses the transaction due date when determining which transaction to apply to first. This rule uses the values you specified for this AutoCash Rule Set's open balance calculation to determine your customer's oldest outstanding debit item.
Post QuickCash uses the next rule in the set if any of the following are true:
· all of your debit and credit items are closed
· the entire receipt amount is applied
· it encounters a partial receipt application and Allow Partial Receipts is set to No for this AutoCash Rule Set
· the next oldest debit item includes finance charges and Finance Charges is set to No for this AutoCash Rule Set
This rule marks any remaining receipt amount 'Unapplied' or places it on-account, depending on the value you entered in the Remaining Remittance Amount field for this AutoCash Rule set .
Clear the Account: Post QuickCash uses this rule only if your customer's account balance exactly matches the amount of the receipt. If the receipt amount does not exactly match this customer's account balance, Post QuickCash uses the next rule in the set. This rule calculates your customer's account balance by using the values you specified for this AutoCash Rule Set's open balance calculation and the number of Discount Grace Days in this customer's profile class. This rule also includes all of this customer's debit and credit items when calculating their account balance. This rule ignores the value of the Apply Partial Receipts option.
This AutoCash Rule uses the following equation to calculate the open balance for each debit item:
Open Balance = Original Balance + Finance Charges - Discount
Receivables then adds the balance for each debit item to determine the customer's total account balance. The 'Clear the Account' rule uses this equation for each invoice, chargeback, debit memo, credit memo, and application of an Unapplied or On-Account receipt to a debit item.
Note: The discount amount for each item depends upon the payment terms of the item and the value of the Discounts field for this AutoCash Rule Set. The number of Discount Grace Days in this customer's credit profile, along with the payment terms assigned to their outstanding invoices, determine the actual due dates of each debit item.
Clear Past Due Invoices: This rule is similar to the 'Clear the Account' rule because it applies the receipt to your customer's debit and credit items only if the total of these items exactly matches the amount of this receipt. However, this rule only applies the receipt to items that are currently past due. A debit item is considered past due if its due date is earlier than the receipt deposit date. This rule considers credit items (i.e. any pre-existing, unapplied receipt or credit memo) to be past due if the deposit date of the receipt is either the same as or later than the deposit date of this pre-existing receipt or credit memo. In this case, this rule uses a pre-existing receipt or credit memo before the current receipt for your AutoCash receipt applications.
If this AutoCash Rule Set's open balance calculation does not include finance charges or disputed items, and this customer has past due items that are in dispute or items with balances that include finance charges, this rule will not close these items. This rule ignores the value of the Apply Partial Receipts option.
Clear Past Due Invoices Grouped by Payment Term: This rule is similar to the 'Clear Past Due Invoices' rule, but it first groups past due invoices by their payment term, and then uses the oldest transaction due date within the group as the group due date. When using this rule, Receivables can only apply the receipt if the receipt amount exactly matches the sum of your customer's credit memos and past due invoices.
A debit item is considered past due if the invoice due date is earlier than the deposit date of the receipt you are applying. For credit memos, Receivables uses the credit memo date to determine whether to include these amounts in the customer's account balance. For example, if you are applying a receipt with a receipt date of 10-JAN-93, credit memos that have a transaction date (credit memo date) on or earlier than 10-JAN-93 will be included. Credit memos do not have payment terms, so they are included in each group.
Match Payment with Invoice: This rule applies the receipt to a single invoice, debit memo, or chargeback that has a remaining amount due exactly equal to the receipt amount. This rule uses the values that you enter for this AutoCash Rule Set's open balance calculation to determine the remaining amount due of this customer's debit items. For example, if Finance Charges is No for this rule set and the amount of this receipt is equal to the amount due for a debit item minus its finance charges, this rule applies the receipt to that debit item. If this rule cannot find a debit item that matches the receipt amount, Post QuickCash looks at the next rule in the set. This rule ignores the value of the Apply Partial Receipts option.
Application Rule Sets
Use the Application Rules Sets window to review existing and define new application rule sets. Application rule sets specify the default payment steps for your receipt applications and how discounts affect the open balance for each type of associated charges. By defining your own application rule set, you can determine how Receivables reduces the balance due for a transaction's line, tax, freight, and finance charges.
Receivables provides the following application rules:
· Line First - Tax After: Apply to the open line item amount first. Apply any remaining amount in the following order: tax, freight, and then finance charges.
· Line and Tax Prorate: Apply a proportionate amount to the open line item amount and the open tax amount for each line. Apply any remaining amount to freight and then to finance charges.
· Prorate All: Apply a proportionate amount to the line, tax, freight, and finance charges.
Note: In an application rule set, each line type (line, freight, and tax) must appear once and only once.
Application rule set window reference:
Application Rule Set: Enter a Name and Description for this rule set.
Seq: Enter the Sequence number for this application rule. Receivables applies payments in this sequence, beginning with the lowest sequence number.
Note: You cannot enter a sequence number for the Overapplication rule. By default, this rule is last in the sequence for each application rule set.
Rule: Enter an application Rule. Each rule will correspond to a line type (for example, lines, freight, or charges), so you should give your rule a descriptive name. Each rule set must have at least one application rule.
Attention: Receivables automatically assigns the Overapplication rule to each application rule set. You cannot delete this rule. The Overapplication rule applies any remaining amount after the balance due for each item has been reduced to zero. If the transaction type of the debit item allows overapplication, this rule prorates the remaining amount between each line and its associated tax amount, making these amounts negative. If the transaction type does not allow overapplication, you can either place the remaining amount on-account or leave it 'Unapplied'.
Rule details : Enter Rule Details for this application rule. This section indicates the type of charges and the tax handling for this rule. Choose a Type of Line, Freight, or Charges. You need to enter at least one type for your rule set.
Tax Treatment: If you chose a Type of 'Line', choose a Tax Treatment. Choose one of the following:
· Prorate: Choose this option to proportionately reduce the net amount of the line and associated tax amounts.
· Before: Choose this option to first reduce the open tax amount, then apply any remaining amount to the line.
· After: Choose this option to reduce the open line amount, then apply any remaining amount to the associated tax.
· Note: The default Tax Treatment for your Freight and Charges types is None. This option ignores tax, since you cannot tax freight and charges in Receivables. You cannot choose None for your Line type.
Rounding Corrections: To automatically adjust this line type to account for any rounding corrections within this rule set, check the Rounding Correction box. When an amount is prorated among several line types, Receivables must use one of the line types to account for the rounding adjustment. Each application rule set must have one and only one rounding correction line type.
Suggestion: Assign the Rounding Correction to the line type that is usually the largest portion of your invoices. By doing this, the rounding correction will have the least effect on the overall remaining and applied amounts for this line type.
- Repeat the previous steps for each rule you want to add to this rule set.
Freeze box: When you are satisfied with this rule set definition, check the Freeze box. Receivables verifies that your application rule set is defined properly and that it does not violate any basic application guidelines. If this rule set fails validation, Receivables displays an error message. In this case, modify your rule set definition, then check the Freeze box again to revalidate it.
Attention: A rule set must be 'frozen' before you can assign it to a transaction type or use it as your default rule it in the System Options window. Additionally, after you freeze an application rule set, you cannot update or delete it.
Distribution Sets
Define distribution sets to account for your non-invoice related receipts. These receipts can include refunds, revenue from the sale of stock, as well as interest and investment income. Receipts that are not related to an invoice are known as miscellaneous receipts in Receivables.
Distribution sets are predefined groups of general ledger accounting codes that determine the credit accounts for positive miscellaneous receipt amounts and the debit accounts for negative receipt amounts. Distribution sets also let you speed your receivables accounting by reducing time spent on data entry. You can also use distribution sets to apply percentages of other receipts to different accounts.
You can create an unlimited number of distribution set lines for each distribution set. The total distribution lines must equal 100% before you can save your distribution set.
Receivables displays active distribution sets as list of values choices in the Transactions and Receivables Activities windows.
You can make a distribution set inactive by unchecking the Active check box, and then saving your work.
Receipt Sources
Define receipt batch sources to provide default values for the receipt class, payment method, and remittance bank account fields for receipts you add to a receipt batch. You can accept these default values or enter new ones. Receipt batch sources can use either automatic or manual batch numbering.
You can specify a default receipt batch source when defining the profile option AR: Receipt Batch Source. If you specify a default receipt batch source, Receivables displays this source in the Receipt Batches window when you create your receipt batches.
When you select a receipt batch source to enter receipts, Receivables automatically uses the Cash, Receipt Confirmation, Remittance, Factoring, Short Term Debt, Bank Charges, Unapplied Receipts, Unidentified Receipts, On-Account Receipts, Earned and Unearned Discounts, and Bills Receivable account information you assigned to the payment method for this batch source. The payment method accounts for the receipt entries and applications you make using this receipt batch source.
Receivables will issue a warning if you enter a receipt source that includes a payment method that has activities allocated to more than one company. Allocating activities to more than one company will cause some reconciliation reports to distribute data of previously entered transactions across multiple companies. Therefore, information regarding a particular receipt may be distributed across multiple company reports. For example, the Applied and Earned Discount amounts in the Applied Receipt Register would be shown across multiple company reports if you allocated them to different companies.
Receivables provides the automatic receipt source 'Automatic Receipts.' You cannot update this predefined receipt source except for the Last Number field. All of the receipt batch sources you define are created with a Receipt Source Type of Manual.
Receipt Classes
Define receipt classes to determine the required processing steps for receipts to which you assign payment methods with this class. These steps include confirmation, remittance, and reconciliation. For example, you must create and remit a direct debit, but you must create, confirm, and remit a bills receivable remittance. You can specify any combination of these processing steps with one exception: if you confirm and reconcile, then you must also remit. If you enter No for all three of these steps, Receivables automatically creates receipts assigned to this receipt class with a status of Cleared.
Receivables uses the payment method you assign to a receipt class to determine how to account for receipts you create using this receipt class.
For each receipt class, you can specify a creation method, remittance method, and whether to require bank clearance for receipts that you assign to this class. If you are defining a receipt class for bills receivable creation payment methods, then Require Confirmation, Remittance Method, and Clearance Method are disabled.
Receivables lets your customers pay their invoices via credit cards and electronic funds transfer (both non-Automatic Clearing House direct debit and ACH bank account transfers).
· To accept payment via credit cards or non-ACH direct debit, use your existing Receivables setup, or optionally define a new receipt class and payment method to be used with these transactions.
· To accept payment via ACH bank account transfer, define a new receipt class and payment method to be used with these transactions.
Receipt Class window reference:
Name: Enter a unique Name for your Receipt Class.
Notes Receivable: If you are creating a Notes Receivable receipt class, check the Notes Receivable box. You cannot change this attribute after you assign a payment method and then save this receipt class.
Creation Method: Choose a Creation Method. If you choose Automatic, you can create receipts with this receipt class using the Automatic Receipt program. If you choose Manual, receipts using this receipt class must either be entered manually in the Receipts or QuickCash window, or imported into Receivables using AutoLockbox. If you choose Bills Receivable or Bills Receivable Remittance, Receivables enables the Bills Receivable or Bill Receivable Remittance tab.
Require Confirmation: To require automatic receipts assigned to this receipt class to be confirmed before they can be remitted, check the Require Confirmation box. You need to check this box to confirm automatic receipts using this receipt class in the Confirm Automatic Receipts window. If you choose a Creation Method of Bills Receivable Remittance, the box is checked. If you check this box, the Create Automatic Remittances window does not let you create remittances for unconfirmed receipts that were created using a payment method with this receipt class.
If you are defining a receipt class for use with ACH bank account transfers, then you should not check this box.
If you checked the Require Confirmation box, choose a Remittance Method. The remittance method determines the accounts that Receivables uses for automatic receipts that you create using payment methods to which you assign this receipt class. Choose one of the following methods:
· Standard: Use the remittance account for automatic receipts or for standard bills receivable assigned to a payment method with this receipt class.
· Factoring: Use the factoring account for automatic receipts or for factored bills receivable assigned to a payment method with this receipt class.
· Standard and Factoring: Choose this method if you want Receivables to select receipts assigned to this receipt class for remittance regardless of the batch remittance method. In this case, you can specify either of these remittance methods when creating your remittance batches.
· No Remittance: Choose this method if you do not require receipts assigned to this receipt class to be remitted.
Note: If the Require Confirmation box is not checked and you choose a Remittance Method of No Remittance, automatic receipts that you create using this payment method and receipt class will be created as 'Confirmed.'
Clearance Methods: To require receipts created using a payment method assigned to this receipt class to be reconciled before posting them to your cash account in the general ledger, choose one of the following Clearance Methods:
· Directly: Choose this method if you do not expect the receipts to be remitted to the bank and subsequently cleared. These receipts will be assumed to be cleared at the time of receipt entry and will require no further processing. Choosing this method is the same as setting Require Bank Clearance to No in previous releases of Receivables.
· By Automatic Clearing: Choose this method to clear receipts using the Automatic Clearing program. (Receipts using this method can also be cleared in Oracle Cash Management.)
· By Matching: Choose this method if you want to clear your receipts manually in Oracle Cash Management.
Payment Method: Enter the Payment Method to assign to this receipt class.
Collectors:
Receivables lets you define collectors and assign them to a profile class or to a customer's credit profile class. When you assign a collector to a profile class, that collector becomes the collector for all customers assigned that profile class. You can modify collector assignments for your customers in the Customers window and for your profile classes in the Customer Profile Classes window.
You can also print collector names and telephone numbers on dunning letters you send to your customers for past due items. Receivables displays active collectors and their descriptions as list of values choices in the Customers, Customer Profile Classes, and Customer Calls windows. Receivables does not display inactive collectors in the list of values for these windows.
You can make an existing collector inactive by unchecking the Active check box and then saving your work. If the collector you want to make inactive is associated with an active customer, Receivables displays a warning message.
Define statement cycles to determine when to send statements to your customers. You enter statement cycles when you define or modify individual customer and site profile classes in the Customer Profile Classes window.
If a customer site is defined as a statement site, Receivables generates a single, consolidated statement for all of this customer's transactions. This statement is sent to this statement site. If you have not defined a statement site for a customer, Receivables creates statements for each customer site to which you have assigned a Bill-To business purpose and for each credit profile that has the Send Statements parameter set to Yes.
You choose a statement cycle when you print your statements. Active statement cycles appear as list of values choices in the Print Statements and Customer Profile Classes windows. Statement cycle dates appear as list of values choices in the Print Statements window.
You can disable a statement cycle by unchecking the Active box, and then saving your work.
Define standard messages to provide the text that Receivables prints on the bottom of your customer's statements. You can use messages to inform your customers of special promotions or to make your statements more personal. Active standard messages appear as list of values choices in the Print Statements window.
Define remit-to addresses to let your customers know where to send payment for their invoices Receivables uses the addresses that you define in the Remit To Addresses window to provide default remit-to information when you enter transactions.
Defining a Default Remit-To Address
Define default remit-to addresses to ensure that:
· Receivables is able to provide a default remit-to address when you enter transactions
· AutoInvoice will not reject invoices because it is not able to determine a remit-to address
You can only have one default remit-to address for each country and state combination. For example, you can have one default remit-to address for United States/California, one for United States/Nevada, and so on.
System Options
AccountingUse the Accounting tabbed region to specify an accounting method and set of books and define your accounting flexfields. You can also choose whether to use automatic journal import, enable header level rounding, and specify how many days should be included in each posting cycle.
Name: Enter the Name of your receivables accounting set of books. If you are not using the Multiple Organization Support feature, you can have one set or multiple sets of books for your business, but you can only have one set of books for each Receivables installation. You cannot change this value after you enter transactions in Receivables.
Realized Gains and Realized Losses Accounts: If your accounting method is Accrual, enter your Realized Gains and Realized Losses Accounts. Receivables posts changes in your functional currency to your Realized Gains or Losses account in your general ledger if there are differences in exchange rate gains or losses.
For example, if the exchange rate for a foreign currency invoice is 1.7 and the exchange rate of your payment for this invoice is 2.0, Receivables posts the difference as a gain to your Realized Gains account. Receivables provides descriptions of each segment, verifies that all flexfield segments are active, and ensures that you enter a valid combination.
Tax Account: Enter the Tax Account to use as the default value in the Tax Codes and Rates window.
Unallocated Revenue Account: If your accounting method is Cash Basis, enter your Unallocated Revenue Account. Receivables uses this account when you apply a cash receipt with a balance other than zero to an invoice with a zero balance.
Cross Currency Rate Type : Enter the default exchange rate type that Receivables uses when the receipt and transaction currency are different and the two currencies do not have a fixed rate relationship. (If the receipt and transaction do have a fixed rate relationship, then Receivables uses the exchange rate that you defined.)
The Applications and QuickCash windows use the value that you define here to calculate the Allocated Receipt Amount when you enter the Amount Applied and vice versa (if this system option is not defined, then you must manually enter both values).
Additionally, AutoLockbox uses this system option to apply cross currency receipts if the currencies do not have a fixed exchange rate and the program cannot automatically calculate the rate to use.
Cross Currency Rounding Account: Receivables uses this account to record any rounding error amounts created during a cross currency receipt application for currencies that have a fixed rate relationship. You need to define a rounding error account if you create cross currency receipts.
Header Rounding Account: Receivables uses this account to record any rounding differences that occur when converting foreign currency transactions to your functional currency.
Automatic Journal Import: To import the batches of transaction records that you post into your general ledger, check the Automatic Journal Import box. The value you enter becomes the default value for the Run GL Journal Import field in the Run General Ledger Interface window.
Transactions and Customers System Options
Receivables lets you define several options for your invoices and use of the AutoInvoice program. You can choose whether to allow updates to printed invoices and whether you can apply payments to an unrelated customer's transactions. Receivables lets you define the segments to use for Accounting Flex Tuning, System Items Tuning, and Territory Tuning during AutoInvoice.
You can also specify whether to purge the interface tables that you use for AutoInvoice, the maximum number of bytes to use and the grouping rule to use for the revenue and credit transactions you create through AutoInvoice.
Window reference:
Allow Change to Printed Transactions box: To allow updates to transactions that have been printed, check the Allow Change to Printed Transactions box. This option also determines whether you can update a customer's address when printed, posted, or applied transactions are assigned to that address.
Attention: You cannot update a transaction if it has activity against it, regardless of how you set this option. Examples of activity include payments, credit memos, adjustments, and including the transaction on a consolidated billing invoice.
Allow Transaction Deletion: To allow transactions to be deleted from Receivables after they have been saved, check the Allow Transaction Deletion box. If you set this option to Yes, you can still specify at the responsibility level which users can delete transactions by using function security. Setting this option to No prevents all Receivables users from deleting transactions; this is a requirement for installations that are legally required to number transactions sequentially with no missing transaction numbers.
Allow Payment of Unrelated Transactions: To allow receipt applications to debit items of unrelated customers, or to allow bills receivable assignments to transactions of unrelated customers, check the Allow Payment of Unrelated Transactions box. If you check this box, Receivables lets you select debit items for unrelated customers and apply your receipts to them in the Applications window, and lets you select transactions of unrelated customers and assign them to bills receivable in the Assignments window or the Bills Receivable Transaction Batches window.
Show Billing Number: Check this box if you want Receivables to display the consolidated billing invoice number on certain reports and windows. Receivables assigns a unique billing invoice number when you print a draft or final version of your consolidated billing invoices.
Receivables windows that can display the consolidated billing invoice number include the Receipts, Transactions, Account Details, Credit Transactions, Transaction Overview, Customer Calls, Applications, and Search and Apply windows.
Reports that can display the consolidated billing invoice number include the Account Status, Aged Trial Balance, Billing and Receipt History, Disputed Invoice, Dunning Letter Generate, Past Due Invoice, Sales Journal by GL Account, and Transaction Detail reports.
Document Number Generation Level : From the Document Number Generation Level pulldown list, select the point at which Receivables generates a document number for your transactions. Choose one of the following:
· When the transaction is committed
· When the transaction is completed
For bills receivable, Receivables ignores this option and generates the document number when the bill is completed.
Auto Invoice: Enter the Accounting, System Items, and Territory Flexfield segments that are most often selected by AutoInvoice. Receivables uses this information to increase AutoInvoice performance.
Create Reciprocal Customer: If majority of the relationships which are created is of the type “Reciprocal” then this option should be checked. This means that whenever we create the relationship in the customer it shall default as reciprocal. We can change it to a one way relationship if it is required.
Customers:
Automatic Customer Numbering: To automatically assign a unique number to every new customer, check the Automatic Customer Numbering box. Do not check this box if you want to manually assign customer numbers.
Automatic Site Numbering: To automatically assign numbers to your customer's business purposes, check the Automatic Site Numbering box.
Grouping Rule Name: Enter the default Grouping Rule Name you want AutoInvoice to use. AutoInvoice uses grouping rules to group revenue and credit transactions into invoices, debit memos, and credit memos.
Claims System Options
If using Oracle Trade Management, then use the Claims tabbed region to indicate how to evaluate, during Lockbox and Post QuickCash processing, your customers' remittances for claim creation.
Miscellaneous System Options
Use the Miscellaneous tabbed region to specify your split amount and the number of days to use for your Days Sales Outstanding (DSO) Calculation in the Collection Effectiveness Indicators Report.
You can also:
· Choose whether you require a billing location for receipts, and salespersons and remit-to addresses for transactions
· Define the system level write-off limits for receipts
· Specify a chargeback due date
· Define your Automatic Receipts submission parameters,
· Choose a default Application Rule Set
· Set the Sales Credit Percent Limit
Window reference:
Split Amount | Enter the Split Amount that Receivables will use when you generate the Collection Effectiveness Indicators Report. Receivables prints this amount as a selection option for this report. Use the split amount to determine the number of invoices over and under this amount, as well as the total amounts remaining. For example, your company generates invoices that are either $300 or $500. You choose $400 as your split amount so that you can review how much of your open receivables are comprised of your $300 business and how much corresponds to your $500 business |
Discount Basis | Enter the Discount Basis you want Receivables to use when calculating discounts for your invoices. Receivables use this value as the default Discount Basis in the Payment Terms window. Choose one of the following discount methods: Invoice Amount: Choose this option to calculate the discount amount based on the sum of the tax, freight charges, and line amounts of your invoices. Lines Only: Choose this option to calculate the discount amount based on only the line amounts of your invoices. Lines, Freight Items and Tax: Choose this option to calculate the discount amount based on the amount of line items, freight, and tax of your invoices, but not freight and charges at the invoice header level. Lines and Tax, not Freight Items and Tax: Choose this option to calculate the discount amount based on the line items and their tax amounts, but not the freight items and their tax lines, of your invoices |
AutoCash Rule Set | Receivables uses this AutoCash Rule Set when you enter a receipt for a customer whose profile class has not been assigned an AutoCash Rule Set. Your AutoCash Rule set and the Discount Grace Days you specify in a customer's credit profile determine the sequence of AutoCash Rules that Receivables uses when you run Post QuickCash to automatically apply receipts to this customer's open debit items. |
Days in days | Enter the Number of Days to use when calculating your conventional Days Sales Outstanding for the Collection Effectiveness Indicators Report. Conventional DSO = (total outstanding receivables / total sales for last DSO days) * (DSO days) |
Sales Credit Percent limit | This setting applies only to sales credit adjustments that you make using the Revenue Accounting feature. The Sales Credit Percent Limit imposes a limit on the percentage of revenue plus non-revenue sales credit that a salesperson can have on any transaction line. If you do not enter a limit here, then no validation is performed when using Revenue Accounting. |
Write-off limit | Enter the write-off limits per receipt. You cannot write off receipt balances that are less than or greater than the system level write-off limits that you define here. You define the write-off limits range in your functional currency |
Accrue Interest | If you want Receivables to automatically update the open balance in the Transactions workbench for transactions that are past due, check the Accrue Interest box. If this option is set to No, the Lines window in the Transaction workbench will always display the original balance of your transactions; it will not update the balance due to include any finance charges. Note: You can include finance charges for past due items when printing your dunning letters and statements |
Require Billing Location for Receipts | To require that a bill-to location be associated with a cash receipt, check the Require Billing Location for Receipts box. If this option is Yes, the Post QuickCash program does not create receipts that do not have billing locations. If you check this box, be sure that you also check the Require Billing Location box when defining your Lockboxes; otherwise, Receivables displays an error when you submit AutoLockbox. Suggestion: If you have customers without statement sites, we recommend that you check this box. If you do not check this box and you have receipts for customers who do not have statement sites and who do not have a billing location associated with the receipt, the unapplied amount of the receipt will not appear on any of the statements for this customer. |
Allow Unearned Discounts | To allow Receivables to accept unearned discounts, check the Allow Unearned Discounts box. Unearned discounts are discounts a customer takes after the discount period passes. You define discount periods when defining your payment terms |
Print Remit to Address | To print your remit-to addresses on your customers' statements, check the Print Remit to address box. You use remit-to addresses to inform your customers of where they should send their payments. The width and height (in characters) of your customer's remit-to address in your printed dunning letters is 8 characters (height) by 30 characters (width). |
Discounts on partial payments | To allow discounts to be taken for partial payments, check the Discount on Partial Payment box. A partial payment is a payment that is less than the remaining amount due for a transaction. If this option is Yes, you can still choose to not allow discounts on partial payments at the transaction level when defining your Payment Terms. Set this option to No if you never allow discounts on partial payments. |
Print Home Country | To print your home country on your invoices and statements that refer to addresses in that country, check the Print Home Country box. |
Trade Accounting Installed | To enable the Trade Accounting feature, check the Trade Accounting Installed box |
Minimum Refund Amount | Enter an amount in the Minimum Refund Amount field. This field is used for automated receipt handling only. AutoInvoice will automatically create refunds for credit memos that are imported against paid invoices, if the credit request amounts are equal to or greater than the minimum specified here. AutoInvoice will place on account any credit amount that is less than the specified minimum. |
Bills Receivable Enabled | To enable the Bills Receivable Workbench, check the Bills Receivable Enabled box |
Credit Card Payment Method | Select the default Credit Card Payment Method for transactions to be paid by credit card |
Require Salesperson | To require that salespersons be entered when entering your transactions, check the Require Salesperson box. If you plan to use the Revenue Accounting feature, you must check this box |
Bank Account Payment Method | Select the default Bank Account Payment Method for transactions to be paid by Automatic Clearing House bank account transfer. Note: To accept bank account transfer payments via Oracle iPayment and the ACH network, you must select an ACH Bank Account payment method from the list of values. |
Chargeback Due Date | Enter your default Chargeback Due Date. Receivables uses this date when you create a chargeback. Choose from the following: Open Invoice Due Date, Receipt Date, Current Date, Deposit Date |
Default Country | Receivables uses this information to specify the home country for tax calculation, flexible bank structures, flexible address formats, and taxpayer id and tax registration number validation. It also provides a default value of the Country field when you enter addresses. (You can override this value by setting the user profile option 'Default Country. |
Source of Territory | Enter the Source of Territory you want Receivables to default into the Salespersons, Transactions, and Customers windows. Receivables uses the value you enter here to determine the default territory for your invoices and commitments. Choose from the following sources: Bill-To Site, Salesrep, Ship-To Site, None |
Application Rule Set | Select one from the list of values. Your Application Rule Set determines the default payment steps when you use the Applications window or Post QuickCash to apply receipts. Receivables uses this rule set if none is assigned to the debit item's transaction type. |
AR Accounting Periods
Open Next Period: To open the next accounting period after the Latest Open Period, choose Open Next Period. AR changes the status of the next period to 'Open.'
Status: To update the status of an accounting period, place the cursor in the Status field next to that period, then enter a new status. An accounting period can have one of the following statuses:
Closed | Journal entry, posting, and transaction entry are not allowed unless the accounting period is reopened. AR verifies that there are no unposted items in this period. AR does not let you close a period that contains unposted items. |
Close Pending | Similar to Closed, but does not validate for Unposted items. Journal entry, posting, and transaction entry are not allowed unless the accounting period is reopened. |
Future | This period is not yet open, but you can enter transactions in this period. However, you cannot post in this period until you open it |
Not Opened | This period has never been opened and journal entry and posting are not allowed |
Open | Journal entry and posting are allowed |
No comments:
Post a Comment