Debtor Price Group pricing is used when a special price, discount, or promotional price applies to customers that have been grouped together using Debtor Price Groups.
This article explains how to create and maintain Debtor Price Group pricing elements in Jiwa. Debtor Price Group pricing is usually used where customers share the same pricing level or pricing arrangement, rather than pricing being applied to an individual Debtor account or Debtor Classification.
The Debtor Price Group matrix is one of the inventory item specific pricing matrices available in Jiwa. Price elements in this matrix can be used to apply pricing rules to customers based on their Debtor Price Group.
If the pricing rule needs to apply using a different grouping method, another price matrix may be more suitable, such as Debtor Classification, Debtor Group, Inventory Debtor Classification, or Selling Prices.
We cover two methods for creating and maintaining Debtor Price Group pricing:
-
using the Inventory Maintenance form, and
-
using the Sell Prices form.
Before you begin
Before creating Debtor Price Group pricing, we recommend reviewing the article Understanding Price Schemes so that you understand how pricing elements are applied through a price scheme.
Debtor Pricing Groups
Before we can start to create special pricing or set up promotions based on Debtor Pricing Groups we must first set-up our price groups and link our Debtors (Customers) to a group.
From the Debtors module select Configuration | Pricing Groups
Add new price groups by entering in the group name in the Description field
Tick the Default check box on the default price group.
Select Save from the menu ribbon to save your updates.
To link your Debtor to a group load the Debtor account into the Debtor Maintenance form and move to the Financials | Pricing tab.
Select the applicable group from the Price Groups available list.
Inventory Maintenance Form
From the Inventory menu select Inventory Maintenance
Load the inventory item that the discount is applicable for into the form.
Move to the Prices | Debtor Price Group tab
Select the Debtor Price Group that the price element is applicable to by clicking on the lookup icon next to the Debtor Price Group field to bring up the search window.
Enter in the pricing details.
|
Field |
Description |
|
Debtor Price Group |
Applicable Debtor Price Group Note: When this field is left blank then it is implied that the price element is applicable to all Debtors. |
|
Note |
Note about the pricing element. |
|
Use Qty Break |
Tick this option if the discounted price is based on a quantity break |
|
Quantity Break |
This field is enabled when the Use Qty Break field is ticked. Enter in the quantity break that is applicable. If tiered quantity breaks have been agreed to create a new line for each quantity break applicable |
|
Source |
Which price is to be used when calculating the new sell price. This field is only applicable when applying a percentage or actual amount discount. The options available include Sell Price, Last Cost, RRP and Sell Prices 1 - 10 (P1-P10) |
|
Mode |
The mode determines how the new sell price is calculated, the available options are;
|
|
Amount |
The value entered into this field is used to calculate the NewPrice. When entering in a percentage or actual discount amount the value entered into this field must be entered in as a negative value. For example 10% discount or $25 discount is entered as -10.0, -25.0 respectively. When basing your price on the Last Cost + margin then the value entered into this field must be entered in as a positive value. For example 25% or $50 dollar increase is entered as 25.0, 50.0 respectively. When using the mode None the value entered into this field is the new price |
|
New Price |
This field displays the calculated new Debtor Specific price that will be applicable to this item. The field is a read only field and is calculated based on the options selected in the preceding fields . |
|
Start Date |
This is the date that the specific price is to apply from. The field automatically defaults to the current login date however can be overridden if required. |
|
End Date |
This is the date that the specific price is to end. The field automatically defaults to the 20 years from the login date however can be overridden if required. |
The following example demonstrates the different ways in which Debtor Price Group prices can be set up.
When a Debtor Price Group is not linked to a price element as in the two (2) examples above then it is implied that the price element is applicable to all Debtors.
Sell Prices Form
The Sell Prices form was introduced in Jiwa version 7.0.115, this form provides a central location were all pricing elements can be viewed and updated from. New pricing elements can also be created in this form.
To access the form from the Inventory module select Configuration | Sell Prices
Move to the Inventory | Debtor Price Group tab
Debtor Price Groups can be added, updated or deleted from this form.
To add a new price element in this matrix move to the last blank line and start entering the details.
To delete a price simply click on the rubbish bin icon next to the price
To update a price simply change the required fields. Fields that are not greyed out are editable.
To save any changes made in this form and update the inventory items click on Save from the menu ribbon.
The contents of the grid can be copied to Excel by selecting the Select All option
Pressing Ctrl + C on your keyboard then pasting into Excel.
Video walkthrough