Content Release Notes 2.5.x (SQL)

Updated 3 days ago by Stephanie Krenz

Version & Date

Component

Changes

2.5.5

2025-12-10

AP_TaxCodeCheck

Added indicator for european union T005_XEGLD for vendors

AR_TaxCodeCheck

Added indicator for european union T005_XEGLD of goods recipient

GL_TaxCodeCheck

Made field list configurable

Multiple analytics

Added ADCP department information to analytics where it cannot be retrieved directly from the basetables

AP_CPD

AP_DuplicatePayments

AR_CPD

CU_BaseTable_BankAccount

CU_BankAccountChanges

VE_BaseTable_BankAccount

Fixed reference for BANKN field, when customizing for BANKN is extended

AP_BaseTable

AR_BaseTable

Fixed reference for ZBNKN field, when customizing for ZBNKN is extended

VE_BankAccountChanges

Fixed reference for BANKN field, when customizing for BANKN is extended

VE_ShortBankAccountLifetime

Fixed reference for ZBNKN field, when customizing for BANKN is extended

2.5.4

2025-11-14

AM_BaseTable

Added ANLC_NAFAL and ANLC_NAFAV in local and reporting currency

AM_NoDepreciation

Added filter to only show activated assets

PU_PurchaseOrderSplits

Referenced EKKN fields directly

PI_O2C_EventLog

Triggered deletion of unspecified events now before attribute enhancement

AP_TaxCodeCheck

Added new analytic for AP Tax Code Check

AR_TaxCodeCheck

Added new analytic for AR Tax Code Check

GL_TaxCodeSample

Added new analytic for GL Tax Code Sampling and Top Selection

AI_MarketBasketAnalysis

Generic market basket analysis for any table

GL_AccountValueChanges

Fixed updating of parameter

2.5.3

2025-09-25

All BaseTables

Added department info from ADCP

MM

Add c_Calendar_Year_Month to MM analyses for Root Cause

GL_JournalEntryTesting

Add Balance Sheet information into the GL_Basetable

dab DEAN

Fixed issue where outlier was too special

VE_BaseTable

Extended the length of field T052U_TEXT1 to MAX

2.5.2

2025-07-24

fieldlists for DEAN (Outliers)

Analytics can now be adjusted dynamically to avoid RAM issues

AM_IncorrectImpairments

Correct calculation of the incorrect impairments value

new result structure for DEAN-Analytics

AP_DuplicatePaymentsEnhanced

Added field AUGDT for all three potential duplicate payments to the one line table

GL_AccountValueChanges

Added balance sheet values for aktiva and passiva

VE_DuplicateBankAccounts

Group over Vendors to have the total turnover on general level

GL_AccountValueChanges

Changed selection criteria from ERGSL to ID for KPI identification

AM_IncorrectImpairments

Correct calculation of the incorrect impairments value

VE_BankAccountChanges

Exclude entries with "No end time" that were used during lifetime

CU_BaseTable

Extend length of field T052U_TEXT1 to MAX

AP_ManualPayments

Bugfix

2.5.1

2025-04-30

AI-Analyst

Initial release for AP-Module

PU_FunctionMatch

New analytic that does a SOD check for vendor, purchase order, goods receipt and invoice receipt

AP_DuplicatePaymentsEnhanced

Add status columns to Duplicate Payments AI analytic for Power BI dashboards

GL_BalanceSheet

New analytic to create a balance sheet based on SAP data

GL_AccountValueChanges

Added parameter for financial statement version

GL_AccountValueChanges

Added company code filter

AP_RootCause

Creation of two result tables for proper visualization of the root causes

HR

Added analytics for human resources

HR_BaseTable

Introduction of HR_BaseTable

HR_AdditionalPayment

New analytic

HR_BaseSalaryChanges

New analytic

HR_DuplicateAddress

New analytic

HR_DuplicateBankAccount

New analytic

HR_ReEmployment

New analytic

DEAN Analytics

Temporary tables for DEAN Analytics are dropped to avoid error message that they already exist

AP_VendorRanking

Bugfix

AR_CustomerRanking

Bugfix

2.5.0

2025-02-19

AP_Outliers

Switched default output for Outlier_Score and Detected_by_DEAN_because in case of an error

DEAN Scripts

RowNr, which is only used technically, is not handed over to the R-script

AP_EarlyPaid

Fixed calculation for column c_Age_Cluster

AP_BaseTable

Fixed issue with final due date calculation when BSAK_ZFBDT was an invalid value

AR_BaseTable

Fixed issue with final due date calculation when BSAD_ZFBDT was an invalid value

dab DEAN

Fixed potential bug generating 2^31 output elements and crashing the analytic


How did we do?


Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)