Skip to main content

Release Notes Content SQL 2.5.x

Version & DateComponentChanges
2.5.8
2026-01-23
AP_TaxCodeCheckRemoved canceled documents and documents with ** as tax code
Added document date and old open info to standard result set
Removed internal ID from standard result set
Changed behaviour for False check, provided tax codes are now not allowed for check conditions
AR_TaxCodeCheckRemoved canceled documents and documents with ** as tax code
Added document date and old open info to standard result set
Changed behaviour for False check, provided tax codes are now not allowed for check conditions
SD_OpenOrdersUpdated calculation for open days to show an positive value
Added c_Open_Days to standard resultset
BL_TaxClassDifferenceAdded check for not maintained master data information
PaymentProposalAdded new analytic for Payment Proposal Run
AP_BaseTableFixed calculation of c_BSAK_SKFBT_LC
AR_BaseTableFixed calculation of c_BSAD_SKFBT_LC
PI_P2P_EventLogFixed c_DabLink_Document creation
AU_CriticalProfilesSpecified data from USR02
2.5.7
2025-12-15
AP_TaxCodeCheckAdded parameter table for selection
AR_TaxCodeCheckAdded parameter table for selection
2.5.5
2025-12-10
AP_TaxCodeCheckAdded indicator for european union T005_XEGLD for vendors
AR_TaxCodeCheckAdded indicator for european union T005_XEGLD of goods recipient
GL_TaxCodeCheckMade field list configurable
Multiple analyticsAdded 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_BankAccountChangesFixed reference for BANKN field, when customizing for BANKN is extended
VE_ShortBankAccountLifetimeFixed reference for ZBNKN field, when customizing for BANKN is extended
2.5.4
2025-11-14
AM_BaseTableAdded ANLC_NAFAL and ANLC_NAFAV in local and reporting currency
AM_NoDepreciationAdded filter to only show activated assets
PU_PurchaseOrderSplitsReferenced EKKN fields directly
PI_O2C_EventLogTriggered deletion of unspecified events now before attribute enhancement
AP_TaxCodeCheckAdded new analytic for AP Tax Code Check
AR_TaxCodeCheckAdded new analytic for AR Tax Code Check
GL_TaxCodeSampleAdded new analytic for GL Tax Code Sampling and Top Selection
AI_MarketBasketAnalysisGeneric market basket analysis for any table
GL_AccountValueChangesFixed updating of parameter
2.5.3
2025-09-25
All BaseTablesAdded department info from ADCP
MMAdd c_Calendar_Year_Month to MM analyses for Root Cause
GL_JournalEntryTestingAdd Balance Sheet information into the GL_Basetable
dab DEANFixed issue where outlier was too special
VE_BaseTableExtended 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_IncorrectImpairmentsCorrect calculation of the incorrect impairments value
DEAN-Analyticsnew result structure
AP_DuplicatePaymentsEnhancedAdded field AUGDT for all three potential duplicate payments to the one line table
GL_AccountValueChangesAdded balance sheet values for aktiva and passiva
VE_DuplicateBankAccountsGroup over Vendors to have the total turnover on general level
GL_AccountValueChangesChanged selection criteria from ERGSL to ID for KPI identification
AM_IncorrectImpairmentsCorrect calculation of the incorrect impairments value
VE_BankAccountChangesExclude entries with "No end time" that were used during lifetime
CU_BaseTableExtend length of field T052U_TEXT1 to MAX
AP_ManualPaymentsBugfix
2.5.1
2025-04-30
AI-AnalystInitial release for AP-Module
PU_FunctionMatchNew analytic that does a SOD check for vendor, purchase order, goods receipt and invoice receipt
AP_DuplicatePaymentsEnhancedAdd status columns to Duplicate Payments AI analytic for Power BI dashboards
GL_BalanceSheetNew analytic to create a balance sheet based on SAP data
GL_AccountValueChangesAdded parameter for financial statement version
Added company code filter
AP_RootCauseCreation of two result tables for proper visualization of the root causes
HRAdded analytics for human resources
HR_BaseTableIntroduction of HR_BaseTable
HR_AdditionalPaymentNew analytic
HR_BaseSalaryChangesNew analytic
HR_DuplicateAddressNew analytic
HR_DuplicateBankAccountNew analytic
HR_ReEmploymentNew analytic
DEAN AnalyticsTemporary tables for DEAN Analytics are dropped to avoid error message that they already exist
AP_VendorRankingBugfix
AR_CustomerRankingBugfix
2.5.0
2025-02-19
AP_OutliersSwitched default output for Outlier_Score and Detected_by_DEAN_because in case of an error
DEAN ScriptsRowNr, which is only used technically, is not handed over to the R-script
AP_EarlyPaidFixed calculation for column c_Age_Cluster
AP_BaseTableFixed issue with final due date calculation when BSAK_ZFBDT was an invalid value
AR_BaseTableFixed issue with final due date calculation when BSAD_ZFBDT was an invalid value
dab DEANFixed potential bug generating 2^31 output elements and crashing the analytic