Early Payment Discount In Account Receivable

Early Payment Discount

Example
customer order received for item A and we have scheme for item A if user order item A we will give him discount of 200 $ on each items but only in case if he pay in 3 days how it will be handled ?


Solution Example:

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 define proximal payment terms to pay regular expenses such as telephone bills and credit card bills that occur on the same day each month. You can also create split payment terms for invoice installments that have different due dates.

You can use payment terms to determine the amount of each installment. Receivable 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.

To define a payment term:

1. Navigate to the Payment Terms window.
2. Enter the Name of this payment term.
3. 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.

4. 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.

5. 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.

6. 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.

7. 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.

8. If this payment term uses proximate 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 checkbox. 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.

9. 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.

10. 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.


11. Enter a range of Effective Dates for this payment term. If you do not enter an end date, this payment term will be active indefinitely.

12. 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.

13. 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.

14. 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.

15. 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.

16. If you are defining proximate 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.’

17. If you are defining proximate terms and you entered a value for Day of Month, enter the Months Ahead to which these installment terms of the proximate 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.

18. Save your work. To assign discounts to each payment schedule line of your payment term

Entering Discount Information
Receivables lets you assign discounts to your payment terms. You can also assign multiple discount line terms to each installment of your payment terms. For example, you might give your customer a 10% discount if they pay within 10 days, but only a 5% discount if they pay 11 to 20 days after the invoice date.
Discounts do not apply to Automatic Receipts. If you use the automatic receipts feature to create your Bills of Exchange and Direct Debits, Receivables will not calculate discounts, even if your customers pay before the due date.


Prerequisites
Define payment terms
To assign discount information to a payment term:
1. Navigate to the Payment Terms window.
2. Query or enter the payment term.
3. Choose Discounts.
4. 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.
5. 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.
6. Save your work.

Source: – Metalink, Receivable User Guide

About these ads

One thought on “Early Payment Discount In Account Receivable

  1. Hi Rasheed

    Nice Blog, I found you searching google for apps related blogs. I also run an Oracle Forum, requesting you to check out and give me some feedback.

    Btw I am an Oracle Apps Manufacturing consultant. :)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s