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.
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 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.
Opt Purchase Group, if you want to define matrix entries against a different stock group for suppliers than that used for the customer matrix
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.
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.
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.
Article ID: 990
Created On: Wed, Jun 27, 2012 at 10:53 AM
Last Updated On: Mon, Jun 12, 2023 at 7:31 PM
Online URL: https://kb.datafile.co.uk/article/set-database-profiles-discount-matrix-990.html