Tax Engine - Use Case Configuration

This topic provides information about use case configuration.

Use cases

Use case describes a business scenario, conditions which need to be met and event which will trigger the calculation of tax. A use case can be enabled or disabled as per the business need.

Use Case consist of following stages for calculation:

  • Condition:

    Condition which determine whether the use case should be executed or not.

    Example of Condition:

    Operator Value Condition Value 2
    "Applies-to Doc No." Not Equals ''
    or "Applies-to ID" Not Equals ''
    and "GST Vendor Type" Equals 'Unregistered'
    and "Account Type" Equals 'Vendor'
    and "Document Type" Equals 'Invoice'
    and "GST Bill-to/Buy-from State Code" Equals 'Location State Code'
    and "GST Group Code" Not Equals ''
    and "HSN/SAC Code" Not Equals ''
    and "GST Reverse Charge" Equals 'Yes'

    • Attribute Mapping:

      This is defined to map the required attributes with their source of value. Example : In case, GST is to be calculated on Sales Line and value of field ‘Type’ on General Journal Line is ‘G/L Account’ then, HSN Code will flow from G/L Account table.

    • Rate Parameter Mapping:

      Rate parameter needs to be mapped with their source, but this mapping will be done only for column types ‘Range’ and ‘Value’. If an applicable tax rate is found, then system will return ‘component percent’ defined for that tax rate. Example:

      Type Description
      Date This column will be mapped with posting date of sales header and system will analyze whether the posting date comes in the range of ‘Date from’ and ‘Date To’.
      From State In case of sales, parameter 'From State' needs to be mapped with state of location code.
      To State In case of Sales, parameter 'To State' needs to be mapped with state of customer code.

    • Use Case Variables:

      Variables can be used at the time of computation of an intermediate value or defining validations in a use case. Example: showing alert message on tax execution.

  • Computation Script:

    This is an optional step, which will be used to store values in variables. Example: storing value of TDS Amount and adding INR 1000 freight to get the final amount.

    • Component Formula:

      Define ‘Component formula’ for the components which are specific to the use case. Example: CGST = {“Line Amount” from “Sales Line”} * {CGST %} /100

  • Use Case Posting:

    There is a posting entity where the 'G/L Accounts' are configured for the specific 'tax type'. Based on the filters applied on the posting entity, tax engine points to the record from which components can be mapped to posting accounts. In case of reverse charge, same component is adjusted with its payable or receivable account. Configuration will have “Reverse Charge” flag as true and account can be mapped for same to “Reverse Charge G/L Field Name”.

  • Tax Ledger Mapping:

    Calculated tax, which is an output of a use case needs to be mapped to a tax ledger table. Example: On posting of general ledger entry for GST, there will be a new GST Entry created as a tax ledger for the posted transaction.

How to check tax information for a transaction

There are two fact boxes available on transaction page to view calculated tax

  • Tax Information
  • Tax Component

Statistics Page, will show the tax information in Tax Summary Tab.

See Also

Tax Engine Lookup

Kostenlose E-Learning-Module für Business Central finden Sie hier