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