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 The parameters, and arithmetical and logical functions used to define conditions are as follows:
Parameter |
|---|
Description |
|---|
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
P1 | Line Quantity (Line Unit) |
P2 | Line Quantity (Main Unit) |
X1 | Warehouse No. |
X2 | Shipment Address Code |
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) |