Tax Payables Analysis - CI_​TXPYBL

Parameters

Parameter

Parameter Code

Description

Start Date

P_​FROM_​DT

Show summary of the tax amounts starting from this date. If not specified, the system will default this value to the current date minus 7 days.

End Date

P_​TO_​DT

Show summary of the tax amounts up to this date.

If not specified, the system will default this value to the current date.

Account Type Characteristic

P_​CHAR_​TYPE

Defines a Characteristic Type for a characteristic linked to the Distribution Code to define an Account Type.

Account Type

P_​TAX_​ACCTY_​CHAR

Account Type Char Value for tax related GL Accounts. The char type defined for this parameter should match the Char Type code defined as parameter #3. The parameter value indicated for this parameter should be one that represents tax liability accounts.

Report Description

This report displays a summary of the tax amounts that were levied by the company to customers within the input date range. It also includes the tax exemption information for that period.

This report select all records in the financial transaction GL collection that satisfy the following criteria:

  • The financial transaction is frozen.
  • The Accounting Date on the financial transaction within the input date range
  • The distribution code associated with the GL entry has a characteristic type and value that matches the input Account Type Characteristic and Account Type (parameters 3 & 4)

The report also provides tax exemption information for bill segments whose financial transactions satisfy the above criteria. The tax exemption information is retrieved by looking at the bill calculation lines associated with the FT's bill segment.

Note:

Performance Consideration. If your implementation chooses to use this report, you may consider adding an index to the CI_​FT table on ACCOUNTING_​DT to aid in performance. When making this decision, carefully weigh the benefit of improving report performance against the possible degradation to the performance of day-to-day processing as a result of defining a new index. In addition, many companies opt to create a reporting database that is a shadow of production to ensure that indexes defined to benefit reports may be created without any affect on the production environment.