Content Release Notes 2.4.x (SQL)

Updated 1 week ago by Stephanie Krenz

Version & Date

Components

Change

2.4.6

2024-12-10

GL_AccountValueChanges

Added balance sheet information

GL_ContraAccounts

Changed calculation basis to balance sheet level 3

GL_ContraAccounts

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

GL_ContraAccounts

Fixed wrong SKAT mapping

2.4.4

2024-09-06

PI_P2P_EventLog

Cleanup and standardize events and attributes

PI_P2P_EventLog

Removed tables not directly related to P2P process

PI_P2P_EventLog

Improve performance

GL_AccountValueChanges

New analytics for GL

GL_ContraAccounts

New analytics for GL

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

AO_BaseTable

Changed columnname c_Addresse to c_Adresse

Currency Conversion

Enhanced currency conversion function to 22 digit

2.4.2

2024-07-26

AO_BaseTable

New modules for public sector

AO_Daueranordnungen

New modules for public sector

AO_KritischeTexte

New modules for public sector

KK_BaseTable

New modules for public sector

KK_KritischeTexte

New modules for public sector

KK_OffenePosten

New modules for public sector

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

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

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 1`000`000 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


How did we do?


Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)