Report Archiving Rules (ttaad3542m000)

You can use this session to specify the Report Archiving Rules.

A rule consists of two parts. The first part specifies the criteria to determine whether or not archiving must be carried out for a particular report. The second part offers details about the archive group and splitting of the report. Splitting a Report Archive is essential for the reprint process. To be able to reprint, for example, one particular invoice of a customer, the report must be split on the invoice number.

You can define multiple archive rules for the same report. In this case, the most specific archive rule has the highest priority. For an example, see the session.

The following fields must be defined:

Report code:

The criteria or conditions are:

Other properties include the following:

Field Information

Report

The LN package code.

Examples

td ( LN Order Management)

ti ( LN Manufacturing)

tt ( Tools )

Module

The LN module code.

Examples for package td ( LN Order Management):

tdpur (Purchase Control)

tdsls (Sales Control)

Report

The LN report code

Example for package ci, module sli ( LN Central Invoicing):

cisli220011000 (Invoices)

Specific VRC only

Select this check box if the rule is only set for one specific Package VRC.

This can be important for a customized report. A customized report stored in a specific Package VRC can have a deviating split expression for example.

If selected, you must specify the Package VRC.

Version

The version part of the package VRC.

Example for package td ( LN Order Management):

P V R C

td B61

Release

The Release part the Package VRC.

Example for td ( LN Order Management):

P V R C

td B61 a

Customer

The Customer part of the Package VRC.

Example for td ( LN Order Management):

P V R C

td B61O a cus

Specific Session Only

Select this check box if the rule is only set for one particular session.

This can be important because a particular report can be linked to multiple sessions.

If selected, you must specify a Session code.

Module

The module part of the session code:

Example for package ci (Central Invoicing):

ci sli (Sales Invoicing)

Session

The session part of the session code:

Example for package / module cisli (Central Invoicing, Sales Invoicing):

cisli2200m000 (Compose / Print / Post Invoices)

Specific Company Only

Select this check box if the rule is only set for one particular company. If selected, you must specify a company number.

Company

The company number.

Example

200 (Company 200)

Split Expression

The split expression is used to split up a Report Archive into separate Report pages.

A good example of a split expression is the "invoice number" for the "Print Invoices" report. In this case the Invoices Archive is split up on invoice number. As a result, every invoice is stored in a separate file. By having separate files per invoice, you can reprint a single invoice.

The split expression is executed when the report is printed and must return a string (alphanumeric) value. In an expression, you can use any table field or variable that is used as a report input field in the report. You can view the report input fields in the Report Input Fields (ttadv3532m000) session.

Note: It is useful to specify one of the four keyword expressions with the same value as the split expression. To find later on, for example, a particular invoice number in the Invoices Archive to reprint the archive, you can search on Keyword Invoice number.

Example

In the Central Invoicing (ci) package, the Invoice number in the Invoice (cisli120011000) report is made up from three separate "report input fields":

  • Financial company (r.cn.org.inv.comp)
  • Sales invoice transaction type (r.ih.trns.typ)
  • Invoice Number (r.ih.doc.nr)

The following expression composes the invoice number to split the Invoice Archive on the invoice number:

str(r.cn.org.inv.comp) & r.ih.trns.typ & str(r.ih.doc.nr)

Explanation:

The Financial company and the Sales invoice transaction type and the Invoice number are concatenated, resulting in a unique invoice number.

The individual parts in the expression must be of type string; otherwise this error will occur: Incompatible types in expression with operator "&".

Report Archive Group

The Report Archive Group, for details see Report Archive Groups (ttaad3541m000)

Archiving Active

Archiving active:

You can choose one of the following options:

  • Yes: Archiving is always carried out for this report
  • No: No archiving is carried out for this report
  • Conditional: Archiving for this report is carried out conditionally

If you select conditional archiving, you must specify a conditional expression.

Conditional Expression

This conditional expression will be compiled and evaluated when the report is printed. This expression will return a Boolean value.

True means: Archive

False means: Do not Archive

Examples

  • strip(spool.device) = "INVOICE" (Archive only when printed to printer INVOICE)
  • strip(spool.device) <> "D" and strip(spool.device) <> "D66" (Do not archive when printed to display printers D or D66).
  • r.print.option=cisli.prno.original (Only archive original prints of an invoice (Report cisli120011000).
Related topics