Home » Categories » Solutions by Business Process » Order Processing and Invoicer » Invoicer and Discount Matrix

Set Database Profiles - Discount Matrix

Datafile Software

Set Database Profiles - Discount Matrix

Although there are no Database Profiles for the matrix files themselves there are settings within the application profiles that control how the matrix options are applied.

Sales (Purchase) Ledger - Account Optional 3

Discount Group, if you allocate customers/suppliers to one of a number of discount groups, then this code (either N-type or T-type) holds the account group number.

Stock Control – Stock Optional 2

Stock Group, if you want to define matrices against particular stock groups, then this code (either N-type or T-type) holds the stock group number.

Stock Control – Stock Optional 3

Opt Purchase Group, if you want to define matrix entries against a different stock group for suppliers than that used for the customer matrix

Sales (Purchase) Order Processing - Header Optional 3

Matrix Expiry Date, for Order Processing the date used for expiry checking is the system date (usually today’s date or end of current period). Referencing this item, to a field such as Date Input, would use this date as the basis for expiry checking.

Matrix Discount Group, for Order Processing the system uses the discount group recorded on the customer/supplier when checking for matrix entries recorded against the account group. If this option is referenced then checks for this account group instead.

Sales (Purchase) Order Processing – Detail Optional 2

Price Matrix Date, if matrix entry configured for ‘Prices by Expiry Date’ then this option records the expiry date of the matrix entry applied for later enquiry.

Sales (Purchase) Order Processing – Detail Optional 4

Disc Mat "Item 13”, if a data item exists in the matrix file at item 13 then this is prompted for when maintaining the matrix. Referencing this item copies the contents of this field from the matrix entry to the order detail record when a matrix entry is applied.

Mult-Disc 1-4, if using the staged discounts facility these items record the discount stages on the order detail database.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Sales Credit Notes - Application User Facilities
Viewed 1243 times since Wed, Jun 27, 2012
Print Preview and Test Print - Document Design Manager
Viewed 1576 times since Wed, Jun 27, 2012
View System Status
Viewed 1205 times since Tue, Jun 26, 2012
Product File Item Screen Design
Viewed 1216 times since Wed, Jun 27, 2012
System Status - Application User Facilities
Viewed 1142 times since Wed, Jun 27, 2012
Create New Account and Stock Record Maintenance Screens
Viewed 1234 times since Fri, Jun 8, 2012
Product File Listings - Application User Facilities
Viewed 1129 times since Wed, Jun 27, 2012
Enter Prices Inclusive of VAT
Viewed 1372 times since Mon, Jun 11, 2012
Document Design Manager
Viewed 1381 times since Wed, Jun 27, 2012
Prompts: Request Information from Keyboard
Viewed 3820 times since Wed, Jun 13, 2012