Home » Categories » Multiple Categories

Which Price Matrix Entries

The Discount Matrix has an facility where instead of a single discount item you can have a series of up to four discount settings that are applied in turn when calculating the value of the order line – you might for example have 10% discount for being a trade customer, a supplementary 2% discount for reaching targets in a previous month, and so on.  As part of this facility you can record a price number that acts as a base price for the discount chain overriding the price number from the customer record.

This new feature separates the Which Price option from the Discount Chain option allowing use as a stand-alone matrix entry.

 

As with the Multiple Discount option the Which Price entry can be used in conjunction with the discount rate - so an entry can be set that a customer uses price band 2 with a 5% discount instead of their usual price - or can be operated on its own so that a customer who is usually on price band 1 is on price band 3 for this product.

Support for this feature is available within the standard Order Entry options including Quick Forms and Order Replication (presuming not set to retain original order pricing) with support also available in Invoicer and Batch Order Creation (again only if set to apply matrix prices on import).

Installation

Database Changes 

New Items are required on the Discount Matrix for this facility.  Note that the Discount Matrix uses a fixed file structure so items are required to be created in set positions.  To add these new items selectInstallation from the main menu followed by Application Manager and then Restructure A Database. Select the Sales Ledger application. Elect to update the Live Files and then select the Discount Matrix File. The existing data items are then displayed on screen, scroll-down to the required item number and create the following items:

No       Item                            Type               Description

97        WHICH-PRICE          X (1)                Allows entry of a matrix entry to apply a set which price to be applied (optionally with a discount adjustment).  If items 98-101 are in use then the which price option operates with the multi-discount set-up.

To insert a new item press <Enter> against a blank entry, enter the title as required and press <Enter>, select the item type (using the drop-down list if required), and depending on item type select the size required. 

Once the additional items have been recorded press the <ESC> key and select the UPDATE button to save the database changes. When prompted respond ‘Y’ to the prompts to ‘Extract Existing Data to New Database Structure’ and, if appropriate, ‘Copy Table Entries from Old Database to New Database. Final prompts ask to ‘Remove (.OLD) Database’ and to ‘Carry Out the Same Restructure on the BASE File as well’ – respond as required. If you select to update the base file you need to manually insert the new items at the same data item positions as on the live file.

Custom Fields
  • Release ID: 6.8
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Record Groups as Items in Discount and Supplier Matrix
Viewed 2623 times since Fri, May 27, 2016
Extra 160 Items per Database
Viewed 1943 times since Wed, Jun 13, 2012
Group Account Credit Limit Checking Sales Ledger Only
Viewed 6929 times since Mon, Mar 2, 2020
Update Job Record within Enquiry
Viewed 2069 times since Tue, Jun 12, 2012
Update Nominal Ledger
Viewed 1830 times since Mon, Jul 2, 2012
Default Text as Data Items
Viewed 4145 times since Wed, Jun 13, 2012
VAT Summary – Include Out of Scope VAT Codes
Viewed 19418 times since Tue, Oct 12, 2021
Additional Forecast Date Options
Viewed 2605 times since Mon, Jun 11, 2012
General System Options - Hide Post/Collect Messages Options
Viewed 148 times since Thu, Oct 17, 2024
Document Design Manager - Parameters
Viewed 4574 times since Wed, Jun 13, 2012