Parameters
Parameter | Description |
P1 | Gross Line Total |
P2 | Remaining Total (Excl. Expenses) |
P3 | Net Line Total |
P4 | Line Quantity (Line Unit) |
P5 | Line Quantity (Main Unit) |
P6 | Line Additional Tax Amount |
P7 | Remaining Total (Distributed Discount and Promotions) |
P8 | Total Quantity of Goods Received from AR/AP (Main Unit) |
P9 | Shipping Agent |
P11 | Total Quantity of Goods Issued to AR/AP (Main Unit) |
P14 | Total Net Amount of Goods Received from AR/AP |
P15 | Total Net Amount of Goods Issued to AR/AP |
P29 | Line Additional Tax Amount Total (Promotion Excluded) |
P30 | Line Additional Tax Amount Total (Promotion Included) |
P42 | AR/AP Debit |
P43 | AR/AP Credit |
P44 | AR/AP Debit Balance |
P45 | AR/AP Credit Balance |
P46 | AR/AP Balance |
P47 | AR/AP Purchase Invoices Total Amount |
P48 | AR/AP Sales Invoices Total Amount |
P49 | Line Width (Line Unit) |
P50 | Line Width (Main Unit) |
P51 | Line Length (Line Unit) |
P52 | Line Length (Main Unit) |
P53 | Line Height (Line Unit) |
P54 | Line Height (Main Unit) |
P55 | Line Area (Line Unit) |
P56 | Line Area (Main Unit) |
P57 | Line Volume (Line Unit) |
P58 | Line Volume (Main Unit) |
P59 | Line Weight (Line Unit) |
P60 | Line Weight (Main Unit) |
P75 | Unit Price (Line Unit) |
P76 | Unit Price (Main Unit) |
P77 | Material Purchase VAT Rate (%) |
P78 | Material Sale VAT Rate (%) |
P79 | Material Return VAT Rate (%) |
P80 | Invoice Type |
P82 | Line Amount (VAT Included) |
P83 | Gross Total (VAT Included) |
P101 | Material Code |
P102 | Transaction Aux. Code |
P103 | Delivery Code |
P104 | Line Payment Plan Code |
P105 | AR/AP Code |
P106 | Trading Group |
P107 | Payment Plan |
P108 | Payment Plan Group Code |
P109 | City |
P110 | Town |
P111 | District |
P112 | Slip Aux. Code |
P113 | Slip Auth. Code |
P114 | Material Aux. Code |
P115 | Material Auth. Code |
Functions
Name | Description |
MIN | Gives the minimum numbers from within the function. MIN (5,6) = 5 |
MAX (,) | Gives the maximum number from within the function. MAX (5,6) = 6 |
MOD (,) | (Divides the higher valued parameter/constant into the lower valued one and takes the remainder.) MOD (35,6) = 5 MOD (42,7) = 0 |
DIV (,) | Indicates the integer part of the division result. DIV (35,6) = 5 DIV (42,7) = 6 |
ABS () | Gives the absolute value of the number. ABS (7) = 7 ABS (-7) = 7 |
ROUND (number) | Converts the number into the nearest integer. ROUND (5.25) = 5 ROUND (5.61) = 6 |
TRUNC (number) | Eliminates the decimal characters if the parameter/constant within parenthesis is decimal. TRUNC (5.25) = 5 TRUNC (26.85) =26 |
CEIL (number) | Rounds the decimal parameter/constant upwards. TRUNC (5.25) = 5 TRUNC (26.85) =26 |
FRAC (number) | After removing the integer part of the number given, converts the remaining figure to 0 or +/-1, whichever is the closest. FRAC (3,15) = 0 FRAC (-3,15) = 0 FRAC (3,75) = 1 FRAC (-3,75) = -1 |
EXP (number) | The opposite of the natural logarithm (ln) function. Gives the number closest to the multiplication of the base (e) of the natural logarithm function with itself for the number given. EXP (1) = 3 (approximate value of e) EXP (2) = 7 |
LN (number) | Natural logarithm function. Converts the result of the logarithm function to the nearest integer according to base “e”. LN (2) = 1 EXP (LN (5)) = 5 |
POWER (base, exponent) | Shows the specified power of a number. Example; POWER (9,2) =81 (92) POWER (2,3) =8 (23) |
SQR(number) | Shows the square (multiplication with itself) of a number. SQR (2) = 4 SQR (7) = 49 |
SQRT () | Shows the square root of a number. Example; SQRT (81) =9 SQRT (225)=15 |
TAN(number) | Indicates the tangent of a number (an angle given as radiant). |
VAL () | (Converts info within brackets into numerical value) |
STR () | Writes a numeric field in text format. Example STR (1234) =1234 |
SUBSTR (, ,) | Used to right into the selected text field starting from the required character and for the length required. SUBSTR(“abcdef”,2,3) = bcd SUBSTR(“abcdef”,1,4) = abcd |
UPCASE () | Writes the text given in uppercase. UPCASE(“Text”) =TEXT |
LOWCASE () | Writes the text given in lowercase. LOWCASE(“Text”) =text |
TRIMSPC (,) | Removes the space from the beginning or end of the selected text. TRIMSPC (“ ABC ”,1) = ABC TRIMSPC (“ ABC ”,2) = ABC TRIMSPC (“ ABC ”,3) = ABC |
JUSTIFY(, , , ) | Writes the text given with the required length. Fills the spaces in the text with the required character. JUSTIFY (STR (4),1, “0”,3) =004 JUSTIFY (“ABC”,2, “F”,7) =FFABCFF |
NUMSTR (, , ) | Converts the number given into text and writes in the required format. |
STRPOS (, ) | Indicates the position within the text of the character to be searched within the text. STRPOS (“E”, “KALEM”) =4 |
STRLEN() | Displays the number of characters of the selected text. The field type is numeric. STRLEN(“abcdefg”) =7 STRLEN(“999”) =3 |
DATE(day,month,year) | Converts day, month and year info into date format. DATE(31, 12, 2010)=31.12.2010 |
AFTER(, ) | Displays the date after a specified number of days from a specified date. AFTER(10, DATE(10,02,2011)) =20.02.2011 AFTER(10, [current date]) =15.02.2011 (if the current date is 05.02.2011) |
DAYS(, ) | Gives the number of days between two dates. DAYS(DATE(13,10,2010), DATE(21,10,2010)=8 |
DAYOF() | Displays the day of the date given. DAYOF(DATE(10,12,2010))=10 |
MONTHOF(, ) | Displays the month of the date given. MONTHOF(DATE(10,12,2010))=12 |
YEAROF() | Displays the year of the date given. YEAROF (DATE(10,12,2010))=2010 |
WDAYOF() | Displays the day of the week to which a given date corresponds. WDAYOF (DATE(30,03,2011))=5 |
IF(expression, value 1, value 2) | (Assigns values by defining conditions. The “If (p1>1000, 10,5)” definition uses 10 if p1 is bigger than 1000, or 5 if otherwise.) |
MONTHSTR(date) | Writes the month corresponding to the number given. MONTHSTR(2) = February MONTHSTR(12) = December |
WDAYSTR(date) | Writes the day corresponding to the number given. WDAYSTR(3) = Wednesday WDAYSTR(5) = Friday |
RESSTR(string, resource) | Displays the texts in the LRF files located under the Resource folder. RESSTR(29057) = No matching record found. |
WRNUM(language, number, part) | Converts the integer or decimal part of a number into text in the specified language. Numbers corresponding to the languages are defined in Goldset.sys, ERPset.sys files. (1=Turkish 2=English 3=German etc). In order to write the integer part in the required language, Part is assigned 1. In order to write the fractions in the required language, Part is assigned 2. WRNUM(1,100,1) = Yüz WRNUM(2,1000,1) = OneThousand WRNUM(1,100.05,2) = Beş WRNUM(4,100.05,1) = Ein(s)Hundert |
WEEKNUM(, , ) | Displays information about the week of the year to which the related date corresponds. 1: The first week of the year starts in January. 2: The first 4-day week is the first week of the year. (If January 1 falls on Friday, the first week of the year starts on the 4th.) 3: The first full week is the first week of the year. WEEKNUM(DATE(01,01,2011),1,Delivery Date) |
FLOOR(number) | Rounds the decimal parameter/constant downwards. |
SQLINFO(fieldname,tablename,where) | Used to access to different tables with queries in the application. One or more fields can be used in the Fieldname. If it is required to use the value of any of these fields in a report field, the order number is entered into the "Variableindex" field located under the Characteristic section of the relevant field. The relevant table from which information will be transferred is entered in Tablename field. The criteria for the required records in this table is specified after Where sentence. |
COS(number) | Indicates the cosine of a number (an angle given as radiant). |
SIN(number) | Indicates the sine of a number (an angle given as radiant). |
ERATE(, ) | Indicates the rate of the type in use of the required currency at the specified date. Example, ERATE(DATE(05,05,2002),20) |
DATESTR(, ) | Converts the date given into text and writes in the required format. |
TIMESTR(, ) | Converts the hour given into text and writes in the required format. |
DATE(, , ) | Converts into date format according to day, month and year information. |
RESXSSTR(, ) | Brings list resource and tag of the LRF files. |
FRAC() | After removing the integer part of the number given, converts the remaining figure to 0 or +/-1, whichever is the closest. |
LN() | Natural logarithm function. Converts the result of the logarithm function to the nearest integer according to base “e”. |
EXP() | The opposite of the natural logarithm (ln) function. Gives the number closest to the multiplication of the base (e) of the natural logarithm function with itself for the number given. |
CRATE(, , , ) | Displays the value of the required amount in FC converted with cross-rate. |
CRESSTR(, ) | Brings list id., tag. |
Operations
+ | Aggregation |
- | Subtraction |
/ | Division |
* | Multiplication |
= | If equal |
> | Greater than |
< | Smaller than |
( | Open brackets |
) | Close brackets |
() | Brackets |
& | and |
I | If greater or equal |