Allowances are discounts, charges, or accruals that you can add to sales orders to be applied to customer invoice lines. Allowance rules allow you to set criteria to define how and when those allowance are applied either automatically or manually on sales order lines and headers.
Allowances and their allowance rules enable more complex business transactions allowing sales order modifications and invoice handling like the following:
You can define new allowances from either the Allowances or the Manage Allowances page.
Define allowances to apply discounts, charges, and accruals on sales order lines or headers before the time of invoice creation. You can see the effect and the amount of allowances at any stage in the sales order life cycle by opening the Allowances page from a Sales Order, but they are not accounted for (applied) until an invoice is created either by ad hoc creation or by invoice grouping rule process.
All the prerequisites for creating sales orders and invoices are required for allowance processing. Refunding of allowance accruals by manual claim require accounts set with a bank account to create payments.
Setting the allowance type determines the base allowance behavior.
Allowances have many other fields with values that determine how the allowance will be applied. To learn more about Allowance field definitions see the Allowance Page Definitions table.
While the Allowance type (discount, charge, accrual or new price) determines the base allowance behavior, the allowance rules that are part of the allowance define how and when that allowance may be applied.
Allowances can have one or many allowance rules and each allowance rule may be applied independently of the other allowance rules.
Allowance Manual Checkbox
By selecting the Manual checkbox on the allowance you give the user creating (or modifying) the sales order the ability to manually apply allowance rules on the sales order lines or header.
To apply allowances automatically leave the manual checkbox cleared. When the manual checkbox is not selected, allowance rules are applied automatically according to the matching details defined in the allowance rules.
To learn more about Allowance field definitions see the table Allowance Page Definitions.
Allowance rules are constrained by their matching details. Allowance rule matching details are used to restrict usage to those sales order headers and lines that match exactly.
Allowance Rules matching details can use the following to apply an Allowance:
Allowance rules matching details and automatic allowances:
When an allowance is automatic (Manual checkbox cleared) matching allowance rules are applied automatically to corresponding sales order headers and lines.
Manual allowances can be added to a sales order only when allowance rule matching details allow them to be chosen as options that can be applied.
No allowances can be applied to any sales order after invoicing.
You can generate an allowance accrual for your customers on either standard or resale orders. Allowance accruals allow you to:
When applying allowances, there are several types of customers and the terminology here is different from the Parent Customer, Bill To, Sold To, and Ship To. The definition of customer here is important to credit allowance accruals to the proper account for sales orders of type resale. For allowance rule matching with sales orders the following definitions apply:
A customer is generally the recipient of the goods and services, but in the case of a resale sales order the customer can be a broker, distributor, or reseller, and the recipient of the goods and services is called the end customer (or end customer reference).
For example: On a sales order of type resale, the distributor or reseller (the customer in SO header) is the beneficiary when an allowance accrual rule is set to accrue to the Customer. When the accrue to is set to End Customer, the end customer specified by the sales order line gets the allowance accrual.
From either the Allowances page or the Manage Allowances page you can create a new allowance using these steps.
See the table Allowance Page Definitions, for descriptions of the settings and their effects on your allowance.
From an Allowance detail page or from the page listing all Allowance Rules you can create a new allowance rule using these steps:
See the table Allowance Rule Page for descriptions of the settings and their effects on your allowance rule and the parent allowance.
Example: Creating allowance accruals for customers
You can reward customers with credit for purchases in the form of allowance accruals. Allowance accruals are customer credits collected as a bill back commitment or liability owed to the customer account which can be refunded to the customer at a later date.
To create an allowance that credits the customer:
Note: Accruals support use of Rate By or Percentage as your basis.
Contact your accounting group to verify what account should be used for your company as the account number depends on your accounting implementation. It may be ok to use the pre-existing accounts 220000 - Accrued Expense or 230500 - Allowances Payable, but really you should check because the proper account for accruals needs to be specified.
Most useful allowance rule names will summarize the matching details that will be used to qualify the sales order line as valid for applying the allowance.
Every matching details field entry acts as an additional query condition behaving as a logical 'AND' requiring all matching details to be true before the sales order line can qualify for the allowance.
To learn more about matching conditions see Allowance Rule Page.
Allowance accruals can be awarded based on restricted membership in a customer group or by purchase of specific products within a product hierarchy. Specify the matching details values in the allowance rule to limit application of the allowance to those sales orders that match the allowance rule setting. The allowance will apply to all standard sales orders that match the details specified by the allowance rule.
In the allowance and allowance rule example shown below, any customer purchasing the "Amazon Product-20" will automatically receive the accrual credit of $0.10 per unit purchased. The allowance is applied automatically (because the Manual checkbox is cleared) when the allowance rule matching details are true when compared to the sales order.
Allowance accruals can be used to support reseller agreements to reward brokers, resellers, or distributors with credits based on sales orders from customers. Whether the basis is a flat fee, percentage or a rate multiplied by quantity sold, the allowance accrual provides a way to credit the account of a third party beneficiary for qualified sales order lines.
To create an allowance that credits a third-party beneficiary:
Contact your accounting group to use the proper GL account for accruals for your company. Some default accounts that may be suitable for use are: 220000 (Accrued Expense) or 230500 (Allowances Payable), but the proper account to use will depend on your company's implementation and business process.
When set this way, other sales order types will not qualify for this allowance rule accrual even if the matching details criteria are met. You can set the SO type to Standard or None to open the allowance rule to apply to all sales orders.
Every matching details field entry acts as an additional query condition behaving as a logical 'AND' requiring all matching details to be true before the sales order line can qualify for the allowance.
To learn more about matching conditions see Allowance Rule Page.
Example: Creating Allowance Accruals for a reseller based on a percentage of gross sales
An agreement with a reseller named BuyItHere.com would reward them with 3% of gross sales for purchases made by their referred customer, ABC. The following field settings would create an accrual allowance and associated allowance rule to support this agreement.
Your allowance would be of type: accrual, with 3% of target field: Gross. Your allowance definition would have field settings like the following:
Note: Some default values and optional settings have been omitted for clarity and page layout is subject to user customizations.
Your allowance rule would be applied to sales orders of type resale that have matching details to qualify all purchases made by end customer ABC to accrue the allowance credit on behalf of the beneficiary, your customer BuyItHere.com.
When BuyItHere.com starts referring more customers it's easy to add more allowance rules to the Allowance for BuyItHere.com. Go to the related allowance rule and click the Clone button to start a new allowance for a new referred end customer, XYZ, who would have allowance rule field set values like the following:
When you create a sales order, all sales order lines that match allowance rule details for allowances configured with the Manual checkbox is clear (automatic), get the allowance rule applied automatically. Allowances applied on the SO header can be seen as AP-00000XXXXX lines in the Allowances Applied section of the sales order. You can view all sales order allowances as well as modify, delete, or add manual allowances from the Allowances page, accessible from the sale order detail page.
The Sales Order Allowances page shows all allowances applied on the sales order regardless of whether they are applied on the header or on specific sales order lines.
For resale sales orders and adjustment orders automatically applied allowances can be deleted. If needed, they can also be restored by clicking Reapply Allowances.
Only allowance rules that match the sales order are available. See Allowance Rules Matching Details to learn what criteria qualify an allowance rule for use with a sales order.
Some allowance rules allow override to change the allowance amount or the value used to calculate the amount.
Enter an override value if the default value should be changed.
The allowance you applied will appear under the section where you added it. If you need to change or delete it you can click edit or del on the left side of the row.
Click Go Back to return to the sales order detail page.
The sales order details page displays and you can scroll down to the Allowances Applied section which shows only the applied allowances at the header level. You can open Allowances page with a click on the Allowances button or open the sales order lines to view the allowances applied at the line level.
The following table lists the fields that Kenandy provides. Your system administrator selects the fields that are displayed on your user interface.
The following table lists the fields that Kenandy provides. Your system administrator selects the fields that are displayed on your user interface.
| Field | Description |
|---|---|
|
|
Determines the organization that receives credit for the transaction. The settings are End Customer, Beneficiary, and None. When None is selected, this setting defaults to the customer. |
| Allowance Code | Optional: Alpha-numeric string defined for an allowance rule. The allowance code can be used to tell a customer about a discount they can ask for or to add an allowance. The code can also be used to find applied allowance. |
|
|
Not shown by default. Internal use only. |
| Allowance Type |
Synonym for allowance to which the allowance rule belongs. The actual type can be charge, discount, or accrual and that type determines the behavior of the allowance. See the Allowance Page Definitions table to learn more. |
|
|
Defines the party that received the credits from the allowance accrual. |
| Customer |
The customer for the allowance rule. |
| Customer Group |
The customer group for the allowance rule. |
|
|
The end date for the allowance rule. The start and end dates are automatically validated before applying the allowance rule to an invoice. |
|
|
Required when SO type is resale. Used to determine which customer this rule will apply to. Usually, the end customer is the entity that receives your goods or services. Values must be a pre-defined customer record. If your reseller names a customer that is not recorded as a customer in Kenandy, then you can enter that customer name as an End Customer Reference to bypass the requirement for an End Customer entry when saving a sales order. |
|
|
Required when SO type is resale. Not shown by default. Information only (string 255 chars) field which may be used in place of an End Customer entry to audit reseller reports of sales to an end customer that earned an allowance. Because End Customer Reference can be any string, it allows save of a resale order when the End Customer is not a defined record in the system. |
|
|
Displays the external identifier used by integrated records. |
|
|
A matching filter value that can be either Standard or Resale. The allowance rule will only be available for sales orders that match the type specified in addition to any other matching detail criteria specified. For the purposes of allowances matching details "Standard" means all sales orders types that are not "Resale". |
|
|
The product for the allowance rule. The allowance rule can apply to a single product, a product group, or a product hierarchy. |
| Product Group |
The product group for the allowance rule. The allowance rule can apply to a single product, a product group, or a product hierarchy. |
| Product Hierarchy |
The product hierarchy for the allowance rule. The allowance rule can apply to a single product, a product group, or a product hierarchy. |
|
|
The start date for the allowance rule. The start and end dates are automatically validated before applying the allowance rule to an invoice. |
The following table lists the fields that Kenandy provides. Your system administrator selects the fields that are displayed on your user interface.
| Field | Description |
|---|---|
| Allowance Amount | The monetary amount of the applied allowance. |
| Allowance Rule |
The allowance rule for the applied allowance. |
| BillBack Commitment | The billback commitment is the amount the company is committed to pay to the beneficiary of an applied allowance. |
| Customer Invoice |
The customer invoice for the applied allowance. |
| Customer Invoice Line |
The customer invoice line for the applied allowance. |
| Description | The user-defined description for the applied allowance. |
| Name | The system-generated reference for the applied allowance. |
| Override Value | If the Allow Override checkbox is selected then the user may replace the existing value used in the selected allowance rule on the SO. |
| Sales Order |
The sales order for the applied allowance. |
| Sales Order Line |
The sales order line for the applied allowance. |
_________________________________
To search the KnowledgeBase and documentation, ask a question, or log a case, please visit the Kenandy Community. To access our online training, visit the Kenandy Learning Center.
Version: Spring 2017