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
Filter Records on Enquiry Search
Viewed 5114 times since Fri, Oct 26, 2012
Set Application Code Formats
Viewed 2160 times since Mon, Jul 2, 2012
Order Enquiry - Allow Label Print from Order Details
Viewed 2071 times since Mon, Jun 11, 2012
Table Maintenance
Viewed 2095 times since Mon, Nov 25, 2013
Increased Size of User-2 / User-3 Items
Viewed 1894 times since Wed, Jun 13, 2012
Desktop Database Tools - Additional F4-Select Options
Viewed 2697 times since Fri, Jun 8, 2012
Day Book Listings
Viewed 2086 times since Mon, Jul 2, 2012
Reprint Period Invoices
Viewed 2125 times since Mon, Jul 2, 2012
Print Supplier Payments - Purchase Ledger
Viewed 2008 times since Mon, Jul 2, 2012
Turnover Analysis
Viewed 2066 times since Mon, Jul 2, 2012