Skip to main content

Tryton module to automate statement import with rules

Project description

The account_statement_rule module allows rules to be defined to complete statement lines from imported files. When the “Apply Rule” button is clicked on a statement, each rule is tested in order against each origin that does not have any lines until one is found that matches. Then the rule found is used to create the statement lines linked to the origin.

Rule

A rule is composed of two parts: matching criteria and lines.

Criteria

The criteria are matched with each origin of the statement:

  • Company

  • Journal

  • Amount: Check if the amount is between two values

  • Description: A regular expression to search for a match in the origin description.

  • Information rules:

    • Key: the statement information key on which the rule applies

    • The matching value depending of the type of the key:

      • Boolean

      • Numeric: A range of value.

      • Char: A regular expression.

      • Selection

The regular expression can register the group names party, bank_account and invoice which are later used to search for a party and an invoice.

Lines

They define how to create the statement lines from the matching origin:

  • Amount: A Python expression evaluated with:
    • amount: the amount of the origin.

    • pending: the amount from which previous lines have been deducted.

  • Party

  • Account

If the party is not filled in, one will be searched for using the bank_account or the party group names from the regular expressions. If the invoice group name appears in a regular expression, it will be used to find an invoice to link with.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

trytond_account_statement_rule-5.4.2.tar.gz (29.2 kB view details)

Uploaded Source

Built Distribution

File details

Details for the file trytond_account_statement_rule-5.4.2.tar.gz.

File metadata

  • Download URL: trytond_account_statement_rule-5.4.2.tar.gz
  • Upload date:
  • Size: 29.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/46.4.0 requests-toolbelt/0.9.1 tqdm/4.51.0 CPython/3.7.9

File hashes

Hashes for trytond_account_statement_rule-5.4.2.tar.gz
Algorithm Hash digest
SHA256 db3e94b5b20a65d0e370ab40c11279ec1574d1c4fe05ff2841e12a5ac3b498ff
MD5 26fe89bbe61318c6e52e211354f25018
BLAKE2b-256 a222f6f3378e6dd46b0b34d83439592e06ad3ab09060b0a1d5cec2bc2fd4a758

See more details on using hashes here.

File details

Details for the file trytond_account_statement_rule-5.4.2-py3-none-any.whl.

File metadata

  • Download URL: trytond_account_statement_rule-5.4.2-py3-none-any.whl
  • Upload date:
  • Size: 50.2 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.2.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/46.4.0 requests-toolbelt/0.9.1 tqdm/4.51.0 CPython/3.7.9

File hashes

Hashes for trytond_account_statement_rule-5.4.2-py3-none-any.whl
Algorithm Hash digest
SHA256 f1e56e46ad539d89f86c6448057186b2eeec4d2f96f79d65810a690d4fbd63a5
MD5 136a62b915b74f1d10b6d2dfd9ab825e
BLAKE2b-256 13b3d5a3d36031cd841c5a9da57f8b4d79a4399bc6c30bebcb79e8caa4b34acc

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page