Appendix: Keywords

From 1Archive help
Revision as of 13:21, 5 September 2014 by Onea (talk | contribs) (Created page with "In templates, it is possible to make use of keywords.<br/> Through these keywords, validated fields (that are not empty) can be used when the templates on the invoice are appl...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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

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


Warning.png 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