Content Release Notes 2.4.x (SQL)
Updated 1 week ago
by
Stephanie Krenz
Release Notes 2.4.6
2024-12-10
Additions & Improvements:
- 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
- Added second result table AR_OpenItems_ReceiverAging_CutOffDate
Release Notes 2.4.5
2024-10-25
Additions & Improvements:
- GL_MarketBasket:
- Splitted the reason value into two separate columns and reduced the field list
Fixes:
- PI_P2P_EventLog:
- Fixed crash due to privacy protection
- GL_ContraAccounts:
- Fixed text determination
- Fixed wrong SKAT mapping
Release Notes 2.4.4
2024-09-06
Additions & Improvements:
- 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
- GL_ContraAccounts
Fixes:
- MD_SegregationsOfDuties:
- Added summary to detect segregation of duty breaches correctly
Release Notes 2.4.3
2024-08-14
Additions & Improvements:
- 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
Fixes:
- AO_BaseTable
- Fixed text determination for c_VGART_Text and T007S_TEXT1
- Changed columnname c_Addresse to c_Adresse
- Currency conversion
- Enhaced currency conversion function to 22 digit
Release Notes 2.4.2
2024-07-26
Additions & Improvements:
- 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
Fixes:
- Currency Conversion:
- Fixed issues with TCURX CURRDEC entries 3 and 5
- Currency Conversion:
- 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 to accomodate small differences in currency conversion
- 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
Release Notes 2.4.1
2024-06-24
Additions & Improvements:
- dab DEAN:
- Split Basetables by values of certain columns in chunks
- Additionally there is a check if a chunk is bigger than 1`000`000 (one million) records and if yes it is splitted again
Fixes:
- 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
Release Notes 2.4.0
2024-06-03
Additions & Improvements:
- 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
Fixes:
- 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
