Appendix: Keywords

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.

1 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

When an incorrect keyword is given, an error will occur when the template is applied.

Case sensitive!

2 Date formats

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

3 list keywords

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

Keyword function	Parameter 1	Parameter 2	Parameter 3	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