You can list material/material class purchase and sales prices list with required records. Filter option located in Material/Material Class Purchase and Sales Prices List is used to do this transaction.
Required conditions are specified in filter lines. These filter options are as follows:
Filter | Value |
Code | Group / Range |
Group Code | Group / Range |
Sorting | Group / Range |
Material Code | Group / Range |
Material Description | Group / Range |
VAT | Included / Excluded |
Start Date | Start / End |
End Date | Start / End |
AR/AP Code | Group / Range |
AR/AP Aux. Code 1-5 | Group / Range |
Payment Plan | Group / Range |
Delivery Code | Group / Range |
Trading Group | Group / Range |
Brand Code | Group / Range |
The parameters, and arithmetical and logical functions used to define conditions:
Parameter | Description |
P1 | Line Quantity (Line Unit) |
P2 | Line Quantity (Main Unit) |
X1 | Warehouse No. |
X2 | Delivery Address Code |
P3 | AR/AP Code |
P4 | AR/AP Trading Group |
P5 | AR/AP Auth. Code |
P6 | AR/AP Aux. Code |
P7 | AR/AP Aux. Code 2 |
P8 | AR/AP Aux. Code 3 |
P9 | AR/AP Aux. Code 4 |
P10 | AR/AP Aux. Code 5 |
Function Name | Description |
MIN ( , ) | Returns the parameter with the lower value. |
MAX ( , ) | Returns the parameter with the higher value. |
ABS ( ) | Shows the absolute value of the number. |
AND | AND (If all the conditions used together are true) |
OR | OR (If at least one of the conditions is true) |
MOD ( , ) | Shows the remainder of the division. |
DIV ( , ) | Indicates the integer part of the division result. |
> | Greater than |
< | Smaller than |
>= | If greater or equal |
<= | If smaller or equal |
= | If equal |
<> | If different (not equal) |