WinVask -  Faktura

Kundebildet Attributtflik

Kundebildet Attributtflik

Previous topic Next topic  

Kundebildet Attributtflik

Previous topic Next topic  

Dersom du behøver å lagre spesifikk informasjon på ordrer for noen kunder, kan du lage attributter for kunden.

Denne informasjonen kan du så søke frem igjen (f.eks med PowerSøk), skrive ut på ordren (eller faktura)

 

Merk: Gjelder kun for installasjoner på Serviceavtale

 

clip0451

 

Viser skjermbildet for definisjon av attributter.

 

Man kan lage så mange attributter man vil på kunder, og av hvliken type man måtte ønske.

 

Feltnavn - Navn på attributt.

 

Felttype - Type felt som kan være:

 

Tekst - Tekstfelt godtar alle tegn.

Tall - Tallfelt godtar kun tall og 2 desimaler bak komma.

Heltall - Tallfelt ingen desimaler bak komma.

Dato - Godtar kun dato

Tid - Godtar kun tidspunkt.

Liste - godtar kun valg fra liste (valg separeres med | tegnet)

Ansattnummer - Lager knapp for å velge ansatt fra WinVask

Kundenummer- Lager knapp for å velge kundenummer fra WinVask.

Leverandørnummer - Lager knapp for å velge leverandør fra WinVask.

Maskinnummer - Lager knapp for å velge maskin. (Ikke ferdig enda)

Logisk - Godtar bare JA/Nei, 1/ 0 etc.

Bruttovekt - Henter bruttovekt fra tilknyttet vekt.

Nettovekt - Henter nettovekt fra tilknyttet vekt.

Taravekt - Henter taravekt fra tilknyttet vekt.

Vektenhet - Henter vektenhet (kg, g, tonn etc.) fra tilknyttet vekt.

 

Standardverdi - Inneholder standardverdi for attributt.

 

Merk: Begynner standardverdi med ' = ' tegnet (er lik) er standardverdi en formel.

 

 

Formler (engelsk forklaring / avansert)

 

Some basic rules:

 

1. All formulas must start with equal sign ( = )

 

2. Formulas not understood will result in the actual formula as a "default value"

 

= A+B

Example of incorrect formula

 

=1+2

Example of a correct formula

 

 

An example of an expiry field explained:

 

The spreadsheet expects date (mmddyyyy) and time (hhmmss) in a certain format this is solved width an formula:

 

The example I`m about to show you fills 2 date fields one width the current date (9. December. 2010) and one expiry date 14 days ahead.

 

the to field is defined like this:

 

 

Where the formula for today is:

=Format(Month(today()),@n02)&format(Day(today()),@n02)&Year(today())

 

And the formula for the expiry date is:

=Format(Month(today()),@n02)&format(Day(today())+14,@n02)&Year(today())

 

If I`m only is to print the values I could do it in a simpler manner, I could use a text field and the formulas stated below:

 

I would define the fields like this:

 

Today field:

=Format(Today(),@d17)

 

Expiry Field:

=Format(Today()+14,@d17)

 

 

As you can see from the example same output as a result of a much shorter formula so I recommend using text as much as possible when dealing width formulas.

 

 

Try this:

=Format(Month(today()),@n02)&format(Day(today()),@n02)&Year(today())

(Returns todays date into a date field)

=Choose(Today() % 7,'Monday','Tuesday','Wednesday','Thursday','Friday','Saturday','Sunday')

(Returns day of week as text)

=Format(Clock(),@t5)

(Returns current time into a time field)

 

 

Some (not all) functions:

TODAY()

CLOCK()

DATE(month,day,year)

DAY(date)

MONTH(date)

YEAR(date)

AGE(birthdate [,base date])

UPPER(string)

CHOOSE(condition,if true,if false)

CHOOSE(number,value1,value2,value3,...)

ALL(string [,length])

CHR(code)

CLIP(string)

DEFORMAT(string,picture)

FORMAT(value,picture)

INLIST(searchstring,liststring,liststring [,liststring...])

INSTRING(substring,string [,step] [,start])

LEN(string)

LOWER(string)

NUMERIC(string)

SUB(string,position,length)

UPPER(string)

VAL(symbol)

ABS(expression)

INRANGE(expression,low,high)

INT(expression)

LOGE(expression)

LOG10(expression)

RANDOM(low,high)

ROUND(expression,order)

SQRT(expression)

SIN(radians)

COS(radians)

TAN(radians)

ASIN(expression)

ACOS(expression)

ATAN(expression)

 

 

Number format:

@N [currency] [sign] [fill] size [grouping] [places] [sign] [currency] [B]

 

@N        All numeric and currency pictures begin with @N.

 

currency        Either a dollar sign ($) or any string constant enclosed in tildes (~). When it precedes the sign indicator and there is no fill indicator, the currency symbol "floats" to the left of the high order digit. If there is a fill indicator, the currency

symbol remains fixed in the left-most position. If the currency indicator follows the size and grouping, it appears at the end of the number displayed.

 

sign        Specifies the display format for negative numbers. If a hyphen ( - ) precedes the fill and size indicators, negative numbers will display with a leading minus sign. If a hyphen follows the size,  places, and currency indicators, negative numbers will display with a trailing minus sign. If parentheses are placed in both positions, negative numbers will be displayed enclosed in parentheses. To prevent ambiguity, a trailing minus sign should always have grouping specified.

 

fill        Specifies leading zeros, spaces, or asterisks (*) in any leading zero positions, and suppressesdefault grouping. If the fill is omitted, leading zeros are suppressed.

           0 (zero) Produces leading zeroes

   _ (underscore) Produces leading spaces

   * (asterisk) Produces leading asterisks

size        The size is required to specify the total number of significant digits to display, including the number of digits in the places indicator and any formatting characters.

 

grouping        A grouping symbol, other than a comma (the default), can appear right of the size indicator to specify a three digit group separator. To prevent ambiguity, a hyphen grouping indicator should also specify the sign.

               . (period) Produces periods

 - (hyphen) Produces hyphens

 _ (underscore) Produces spaces

places        Specifies the decimal separator symbol and the number of decimal digits. The number of decimal digits must be less than the size. The decimal separator may be a period (.), grave accent (' ) (produces periods grouping unless overridden), or the letter "v" (used only for STRING field storage declarations--not for display).

 

               . (period) Produces a period

 ` (grave accent) Produces a comma

 v Produces no decimal separator

B        Specifies blank display whenever its value is zero.

 

The numeric and currency pictures format numeric values for screen display or in reports. If the value is greater than the maximum value the picture can display, a string of pound signs (#) is displayed.

 

Example:

 

Numeric  Result     Format

 

@N9      4,550,000  Nine digits, group with commas (default)

@N_9B    4550000    Nine digits, no grouping, leading blanks if zero

@N09     004550000  Nine digits, leading zero

@N*9     ***45,000  Nine digits, asterisk fill, group with commas

@N9_     4 550 000  Nine digits, group with spaces

@N9.     4.550.000  Nine digits, group with periods

 

Decimal  Result     Format

@N9.2    4,550.75   Two decimal places, period decimal separator

 

@N_9.2B  4550.75    Two decimal places, period decimal separator, no grouping, blank if zero

 

@N_9`2   4550,75    Two decimal places, comma decimal separator

@N9.`2   4.550,75   Comma decimal separator, group with periods

@N9_`2   4 550,75   Comma decimal separator, group with spaces

 

Signed   Result     Format

@N-9.2B  -2,347.25  Leading minus sign, blank if zero

@N9.2-   2,347.25-  Trailing minus sign

@N(10.2) (2,347.25) Enclosed in parens when negative

 

Dollar

Currency   Result      Format

@N$9.2B    $2,347.25   Leading dollar sign, blank if zero

@N$10.2-   $2,347.25-  Leading dollar sign, trailing minus when negative

@N$(11.2)  $(2,347.25) Leading dollar sign, in parens when negative

 

International

Currency      Result        Format

@N12_`2~ F~   1 5430,50 F   France

@N~L. ~12`    L. 1.430.050  Italy

@N~£~12.2     £1,240.50     United Kingdom

@N~kr~12`2    kr1.430,50    Norway

@N~DM~12`2    DM1.430,50    Germany

@N12_`2~ mk~  1 430,50 mk   Finland

@N12`2~ kr~   1.430,50 kr   Sweden

 

 

 

Date pictures:

@Dn [s] [direction [range] ] [B]

 

@D        All date pictures begin with @D.

 

n        Determines the date picture format. Date picture formats range from 1 through 18. A leading zero (0) indicates a zero-filled day or month.

s        A separation character between the month, day, and year components. If omitted, the slash ( / ) appears.

               . (period) Produces periods

 ` (grave accent) Produces commas        

 - (hyphen) Produces hyphens

 _ (underscore) Produces spaces

direction        A right or left angle bracket (> or <) that specifies the "Intellidate" direction (> indicates future, < indicates past) for the range parameter. Valid only on ENTRY date pictures with two-digit years.

 

range        An integer constant in the range of zero (0) to ninety-nine (99) that specifies the "Intellidate" century for the direction parameter. Valid only on ENTRY date pictures with two-digit years. If omitted, the default value is 80.

B        Specifies that the format displays as blank when the value is zero.

 

Dates may be stored in numeric variables (usually LONG), a DATE field (for Btrieve compatibility), or in a STRING declared with a date picture. A date stored in a numeric variable is called a "Clarion Standard Date."  The stored value is the number of days since December 28, 1800. The date picture token converts the value into one of the date formats.

The century for dates in any picture with a two-digit year is resolved using "Intellidate" logic. Date pictures that do not specify direction and range parameters assume the date falls in the range of the next 19 or previous 80 years. The direction and range parameters allow you to change this default. The direction parameter specifies whether the range specifies the future or past value. The opposite direction then receives the opposite value (100-range) so that any two-digit year results in the correct century.

 

For example, the picture @D1>60 specifies using the appropriate century for each year 60 years in the future and 39 years in the past. If the current year is 1996, when the user enters "5/01/40," the date is in the year 2040, and when the user enters "5/01/60," the date is in the year 1960.

For those date pictures which contain month names, the actual names are customizable in an Environment file (.ENV). See the Internationalization section for more information.

 

Example:

 

 

Picture  Format               Result

 

@D1      mm/dd/yy             10/31/59

@D1>40   mm/dd/yy             10/31/59

@D01     mm/dd/yy             01/01/95

@D2      mm/dd/yyyy           10/31/1959

@D3      mmm dd,yyyy          OCT 31,1959

@D4      mmmmmmmmm dd, yyyy   October 31, 1959

@D5      dd/mm/yy             31/10/59

@D6      dd/mm/yyyy           31/10/1959

@D7      dd mmm yy            31 OCT 59

@D8      dd mmm yyyy          31 OCT 1959

@D9      yy/mm/dd             59/10/31

@D10     yyyy/mm/dd           1959/10/31

 

@D11     yymmdd               591031

@D12     yyyymmdd             19591031

@D13     mm/yy                10/59

@D14     mm/yyyy              10/1959

@D15     yy/mm                59/10

@D16     yyyy/mm              1959/10

@D17                          Windows Control Panel setting for Short Date

@D18                          Windows Control Panel setting for Long Date

 Alternate separators    

@D1.     mm.dd.yy             Period separator

@D2-     mm-dd-yyyy           Dash separator

 

@D5_     dd mm yy             Underscore produces space separator

@D6`     dd,mm,yyyy           Grave accent produces comma separator

 

 

Time Pictures:

 

@Tn[s][B]

 

@T        All time pictures begin with @T.

 

n        Determines the time picture format. Time picture formats range from 1 through 8. A leading zero (0) indicates zero-filled hours.

s        A separation character. By default, colon ( : ) characters appear between the hour, minute, and second components of certain time picture formats. The following s indicators provide an alternate separation character for these formats.

               . (period) Produces periods

 ' (grave accent) Produces commas        

 - (hyphen) Produces hyphens

 _ (underscore) Produces spaces

 

B        Specifies that the format displays as blank when the value is zero.

 

Times may be stored in a numeric variable (usually a LONG), a TIME field (for Btrieve compatibility), or in a STRING declared with a time picture. A time stored in a numeric variable is called a "Standard Time."  The stored value is the number of hundredths of a second since midnight. The picture token converts the value to one of the eight time formats.

For those time pictures which contain string data, the actual strings are customizable in an Environment file (.ENV). See the Internationalization section for more information.

 

Example:

 

 

Picture   Format       Result

 

@T1       hh:mm        17:30

@T2       hhmm         1730

@T3       hh:mmXM      5:30PM

@T03      hh:mmXM      05:30PM

@T4       hh:mm:ss     17:30:00

@T5       hhmmss       173000

@T6       hh:mm:ssXM   5:30:00PM

@T7                    Windows Control Panel setting for Short Time

@T8                    Windows Control Panel setting for Long Time

 

 Alternate separators    

@T1.      hh.mm        Period separator

@T1-      hh-mm        Dash separator

@T3_      hh mmXM      Underscore produces space separator

 

@T4'      hh,mm,ss     Grave accent produces comma separator