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
General System Options - D02.DFD – Include Sales and Purchase Order Authorisation Limits
Viewed 74 times since Thu, Oct 17, 2024
Document Design Manager - Converting A Document
Viewed 2608 times since Wed, Jun 13, 2012
User-Definable Ledger Enquiry Applications
Viewed 21886 times since Tue, Jun 12, 2012
Enquire Account Details
Viewed 2292 times since Mon, Jul 2, 2012
Separate Look-Ups for Extra Maintenance Screens
Viewed 1837 times since Wed, Jun 13, 2012
Duplicate Purchase Ledger Reference Checks
Viewed 2293 times since Fri, May 27, 2016
General System Options - Increased No of Saved Selection Criteria
Viewed 211 times since Thu, Oct 17, 2024
VAT Reports
Viewed 1998 times since Mon, Jul 2, 2012
Data Interchange Omit First Row from Import
Viewed 2102 times since Fri, May 27, 2016
System Profiles Screen 6 (Sub-Contractors Accessory)
Viewed 1868 times since Mon, Jul 2, 2012