Appendix: Keywords - Revision history

Nele.scherrens at 09:19, 29 May 2017

2017-05-29T09:19:58Z

Onea at 08:12, 13 January 2017

2017-01-13T08:12:26Z

Onea at 09:44, 12 January 2017

2017-01-12T09:44:01Z

Onea: /* List of keywords */

2016-12-22T09:41:30Z

‎List of keywords

Onea at 10:23, 17 October 2016

2016-10-17T10:23:54Z

Onea: /* List of keywords */

2016-10-07T12:52:39Z

‎List of keywords

Onea at 09:55, 13 July 2016

2016-07-13T09:55:56Z

Show changes

Onea: Created page with "In templates, it is possible to make use of keywords.
Through these keywords, validated fields (that are not empty) can be used when the templates on the invoice are appl..."

2014-09-05T12:21:34Z

Created page with "In templates, it is possible to make use of keywords. Through these keywords, validated fields (that are not empty) can be used when the templates on the invoice are appl..."

New page

In templates, it is possible to make use of keywords. 
Through these keywords, validated fields (that are not empty) can be used when the templates on the invoice are applied. 
Keywords can only be used in text fields (Remarks on header level, Description on posting level), eventually in combination with fixed text.

== Examples ==

Following examples are usefull:

'''Incoming: fe. invoice date = 28/08/2014, supplier = Belgacom'''

Consumption #{HEADERFIELD(SUPPCODE,NAME)} #{HEADERFIELD(INVDATE,yyyy)} —> Consumption Belgacom 2014

Consumption #{HEADERFIELD(INVDATE,yyyy)} —> Consumption 2014

Consumption #{HEADERFIELD(INVDATE,yyyy,-1y)} —> Consumption 2013

Consumption #{HEADERFIELD(INVDATE,yyyy,+1y)} —> Consumption 2015

Consumption #{HEADERFIELD(INVDATE,MM-yyyy)} —> Consumption 8-2014

Consumption month #{HEADERFIELD(INVDATE,MM,-1M)} —> Consumption month 7

Consumption month #{HEADERFIELD(INVDATE,MM)} —> Consumption month 8

Consumption month #{HEADERFIELD(INVDATE,MM,+1M)} —> Consumption month 9

Consumption #{HEADERFIELD(YEAR,CODE)} —> Consumption 2014

'''Outgoing: fe. invoice date = 28/08/2014, customer = Belgacom'''

Consumption #{HEADERFIELD(CUSTCODE,NAME)} #{HEADERFIELD(INVDATE,yyyy)} —> Consumption Belgacom 2014

{{Warning|When an incorrect keyword is given, an error will occur when the template is applied.}}

{{Warning|Case sensitive!}}

== Date formats ==

Day = d 
Month = M 
Year = y 
Hour = H 
Minutes = m 
End of month: EOM 
Begin of month: BOM 

== list keywords ==

On several objects, keywords can be used on all the fields in the system.

{|
! style="text-align:left; width:150px"|Keyword function
! style="text-align:left; width:150px"|Parameter 1
! style="text-align:left; width:150px"|Parameter 2
! style="text-align:left; width:150px"|Parameter 3
! style="text-align:left"|Example
|-
|HEADERFIELD
|SUPPCODE
|CODE
|
|Only incoming! #{HEADERFIELD(SUPPCODE,CODE)} --> 6
|-
|
|SUPPCODE
|NAME
|
|Only incoming! #{HEADERFIELD(SUPPCODE,NAME)} --> Belgacom
|-
|
|SUPPVATID
|
|
|Only incoming! #{HEADERFIELD(SUPPVATID)}
|-
|
|CUSTCODE
|CODE
|
|Only outgoing! #{HEADERFIELD(CUSTCODE,CODE)} --> 6
|-
|
|CUSTCODE
|NAME
|
|Only outgoing! #{HEADERFIELD(CUSTCODE,NAME)} --> Belgacom
|-
|
|CUSTVATID
|
|
|Only outgoing! #{HEADERFIELD(CUSTVATID)}
|-
|
|JOURNAL
|CODE
|
|#{HEADERFIELD(JOURNAL,CODE)}
|-
|
|JOURNAL
|NAME
|
|#{HEADERFIELD(JOURNAL,NAME)}
|-
|
|INVOICENR
|
|
|#{HEADERFIELD(INVOICENR)}
|-
|
|INVDATE
|dateformat
|calculation
|#{HEADERFIELD(INVDATE,yyyy,+1y)} --> 05/09/2014 becomes 2015
|-
|
|COMMENT1
|
|
|#{HEADERFIELD(COMMENT1)}
|-
|
|OGM
|
|
|#{HEADERFIELD(OGM)}
|-
|
|NETAMNT
|
|
|#{HEADERFIELD(NETAMNT)} --> 100.00
|-
|
|VATAMNT
|
|
|#{HEADERFIELD(VATAMNT)} --> 21.00
|-
|
|TOTAMNT
|
|
|#{HEADERFIELD(TOTAMNT)} --> 121.00
|-
|
|CURRENCY
|CODE
|
|#{HEADERFIELD(CURRENCY,CODE)} --> EUR
|-
|
|CURRENCY
|NAME
|
|#{HEADERFIELD(CURRENCY,NAME)} --> Euro
|-
|
|YEAR
|CODE
|
|#{HEADERFIELD(YEAR,CODE)}
|-
|
|YEAR
|NAME
|
|#{HEADERFIELD(YEAR,NAME)}
|-
|TECHNICALFIELD
|SCANBATCH
|
|
|#{TECHNICALFIELD(SCANBATCH)}
|-
|
|SCANUSER
|
|
|#{TECHNICALFIELD(SCANUSER)}
|-
|
|SCANNINGDATE
|dateformat
|calculation
|#{TECHNICALFIELD(SCANNINGDATE,yyyyMMdd,EOM)} --> 05/09/2014 becomes 20140930
|-
|
|INCOMINGDATE
|dateformat
|calculation
|#{TECHNICALFIELD(INCOMINGDATE,yyyyMMdd,BOM)} --> 05/09/2014 becomes 20140901
|-
|COMPANYNAME()
|
|
|
|#{COMPANYNAME()}
|-
|USERNAME()
|
|
|
|#{USERNAME()}
|-
|USERREALNAME()
|
|
|
|#{USERREALNAME()}
|-
|CURRENTDATE()
|
|dateformat
|calculation
|#{CURRENTDATE(yyyyMMdd)} --> system date
|}

@@ Line 87: / Line 87: @@
 |-
+|
-|INVOICENR
+|INVNR
+|
+|
-|#{HEADERFIELD(INVOICENR)}
+|#{HEADERFIELD(INVNR)}
 |001201600424
 |-

@@ Line 38: / Line 38: @@
 |-
+|
-|SUPPCODE
 |NAME
+|
@@ Line 59: / Line 59: @@
 |-
+|
-|CUSTCODE
 |NAME
+|
@@ Line 80: / Line 80: @@
 |-
+|
-|JOURNAL
 |NAME
+|
@@ Line 143: / Line 143: @@
 |-
+|
-|CURRENCY
 |NAME
+|
@@ Line 157: / Line 157: @@
 |-
+|
-|YEAR
 |NAME
+|
@@ Line 171: / Line 171: @@
 |-
+|
-|PERIOD
 |NAME
+|

@@ Line 232: / Line 232: @@
 |#{CURRENTDATE(yyyyMMdd)}
 |system date
 |}

@@ Line 16: / Line 16: @@
 == List of keywords ==
-On several objects, keywords can be used on all the fields in the system.
+A keyword can be used to automatically fill in the value of a field inside a template. They are always constructed in the same way: '''#{FIELDNAME/FUNCTION, PARAMETERS}'''.<br/>
 {| class="wikitable"
@@ Line 229: / Line 233: @@
 |system date
 |}

@@ Line 228: / Line 228: @@
 |#{CURRENTDATE(yyyyMMdd)}
 |system date
 |}
 <br/>{{Warning|When an incorrect keyword is given, an error will occur when the template is applied.}}<br/>
 {{warning|The keywords are case sensitive, you have to enter the upper case code of the field (not the name!)}}

@@ Line 23: / Line 23: @@
 ! style="text-align:left; width:150px"|Parameter 1
 ! style="text-align:left; width:150px"|Parameter 2
-! style="text-align:left"|Example input
+! style="text-align:left"|Example keywords
 ! style="text-align:left"|Example output
 |-

Appendix: Keywords - Revision history

Nele.scherrens at 09:19, 29 May 2017

Onea at 08:12, 13 January 2017

Onea at 09:44, 12 January 2017

Onea: /* List of keywords */

Onea at 10:23, 17 October 2016

Onea: /* List of keywords */

Onea at 09:55, 13 July 2016

Onea: Created page with "In templates, it is possible to make use of keywords. Through these keywords, validated fields (that are not empty) can be used when the templates on the invoice are appl..."

Onea: Created page with "In templates, it is possible to make use of keywords.
Through these keywords, validated fields (that are not empty) can be used when the templates on the invoice are appl..."