Skip to Content

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.

  • Release ID: Standard