Skip to main content

Selecting account assignments based on conditions

Account assignments can be linked to conditions, so that SQUEEZE picks the right account assignment setup for a document automatically.

Setup

Open the Document Class Setup of the document class. In the Rules section at the bottom, create a new value in the Account Assignment Code field.

{add screenshot of Document Class Setup, Rules section, here}

This value is a rule group. From now on, account assignments can be set by rules: in this rule group you create and define individual rules, for example one per vendor.

{add screenshot of the rules of the account assignment rule group here}

Example

A rule for an insurance company as vendor:

{add screenshot of Rule here}

The upper part of the rule defines the if. Your conditions can refer to any field of the SQUEEZE document header and to any information linked to it, compared with the various operators. Conditions can be combined with AND or OR.

Example: if the vendor no. equals 4711 AND the Description field of a document line contains "Examination fee", the then is applied. It is defined in the lower DEXPRO Squeeze part of the rule, where you select the matching account assignment setup in the Account Assignment Code field.

The account assignment setup

The account assignment setup itself defines which VAT rates are taken into account and how they are assigned. This lets you handle the VAT rates of each vendor specifically, so that invoices with several VAT rates are later assigned automatically in one go.

An example for a VAT rate of 19%:

{add screenshot of Squeeze Account Assignment Setup Line here}

  • At the top is the VAT Rate to be assigned.
  • In the middle is the account assignment itself.
  • At the bottom are the shortcut dimensions, such as cost centre or cost object, which are also set by the automatic account assignment.

Which account assignment setup is used: if a rule of the rule group applies and has an account assignment code, that code is used. Otherwise SQUEEZE takes the account assignment code from the Vendor Related Setup of the vendor and, failing that, the one in the document class setup.

This way, a requirement like the one in the example can be met in the standard app without any programming.

Back to top