Release Notes Content SQL 2.4.x
| Version & Date | Component | Changes |
|---|---|---|
| 2.4.6 2024-12-10 | GL_AccountValueChanges | Added balance sheet information |
| GL_ContraAccounts | Changed calculation basis to balance sheet level 3 Added fallbacks for cases where no description for accounts exists | |
| AP_OpenItems | Added second result table AP_OpenItems_CutoffDate, which shows open items at last date of analytic time period | |
| AR_OpenItems | Added second result table AR_OpenItems_CutoffDate, which shows open items at last date of analytic time period | |
| AR_OpenItems | Added second result table AR_OpenItems_ReceiverAging_CutOffDate | |
| 2.4.5 2024-10-25 | GL_MarketBasket | Splitted the reason value into two separate columns and reduced the field list |
| PI_P2P_EventLog | Fixed crash due to privacy protection | |
| GL_ContraAccounts | Fixed text determination Fixed wrong SKAT mapping | |
| 2.4.4 2024-09-06 | PI_P2P_EventLog | Cleanup and standardize events and attributes Removed tables not directly related to P2P process Improve performance |
| New analytics for GL | GL_AccountValueChanges and GL_ContraAccounts | |
| MD_SegregationsOfDuties | Added summary to detect segregation of duty breaches correctly | |
| 2.4.3 2024-08-14 | AO_BaseTable | Separized localization part from table generation |
| AO_Daueranordnungen | Changed columnname c_UpdateKey_AnalyticStep to c_UpdateKey_AuditStep | |
| AO_KritischeTexte | Added c_UpdateKey_AuditStep | |
| KK_BaseTable | Separized localization part from table generation | |
| KK_KritischeTexte | Added c_UpdateKey_AuditStep | |
| KK_OffenePosten | Added c_UpdateKey_AuditStep | |
| GL_AccountBalances | Added column T880_RCOMP, c_UpdateKey_AuditStep | |
| PU_PriceChanges | Added indication column for simultaneous currency change | |
| AO_BaseTable | Fixed text determination for c_VGART_Text and T007S_TEXT1 Changed columnname c_Addresse to c_Adresse | |
| Currency Conversion | Enhanced currency conversion function to 22 digit | |
| 2.4.2 2024-07-26 | New modules for public sector | AO_BaseTable, AO_Daueranordnungen, AO_KritischeTexte, KK_BaseTable, KK_KritischeTexte, KK_OffenePosten |
| AI_OutlierDetection | Outlier Detection for any table | |
| PU_PriceChanges | Implemented currency conversion based on the currency active at the change | |
| Currency Conversion | Fixed issues with TCURX CURRDEC entries 3 and 5 Fixed issue with precision in conversion table | |
| AP_ManualPayments | Only clearings are considered now | |
| PU_InvoiceVsPurchaseOrderValue | Implemented a tolerance of 0.01 in reporting currency for result selection | |
| AM_BaseTable | Added parameters for analytic time period to consider the correct values from SAP table ANLZ | |
| CU_BaseTable and VE_BaseTable | Reference fiscal year parameter to avoid missing customer turnover columns | |
| 2.4.1 2024-06-24 | dab DEAN | Split Basetables by values of certain columns in chunks, additionally check if a chunk is bigger than 1000000 records and split again |
| PU_BaseTable | Exceeded length of column c_EKKO_ZTERM_TEXT to NVARCHAR(MAX), now also texts from the table T052U bigger than 50 characters can be processed | |
| 2.4.0 2024-06-03 | PU_BaseTable | Add description for payment terms to result set -> c_EKKO_ZTERM_TEXT |
| AP_VendorRanking | Added GJAHR to result set | |
| AR_CustomerRanking | Added GJAHR to result set | |
| Currency Conversion | Allowed numbers till precision NUMERIC(20,10) instead of NUMERIC(18,10) for conversion | |
| AP_PaymentTermsComparison | Fixed broken join for payment terms | |
| CU_DuplicateBankAccounts | Fixed count for customers | |
| VE_DuplicateBankAccounts | Fixed count for vendors |