Content Release Notes 2.x

Updated 1 week ago by Stephanie Krenz

Version + Date

Components

Change

2.8.0

2024-09-11

HR module

Content for SAP HR Module

HR module

Base Tables for master data, action types and organization structure

HR module

Added new analytic steps

HR module

Additional payments

HR module

Salary changes

HR module

Master data duplicates

HR module

Re-employment

MD_UnusualPosting

Option in _Customization_Settings to set movement type

MD_UnusualPosting

Basetable fieldlist adjusted

All DEAN Analyses

Additional split when a chunk is bigger than 1 million records

All DEAN Analyses

Instead of the SUMMARIZE function CLASSIFY is now used to avoid issues with space capacity

AI_MarketBasket

Market Basket analysis for any table

AI_Outliers

Implemented Excel and CSV export

R RAM Check

Check for available RAM memory is now executed properly

Error Message info

Adjusted path info to generated error messages

Basetable flagging

Correct naming of the Basetables makes sure that the Basetables also get uploaded into results

Download Framework

Corrected Repository mapping for different key fields

Enablement v_DL_Dep_Between

Variable for Dependency download between filter

2.7.0

2024-05-21

AI_Outliers (DEAN for any table)

Execute DEAN for any table by adding it into the Input/Output tab of a robot as ACL table

New public sector module

New module containing the analytic steps

AO_BaseTable

New module step added

AO_Daueranordnungen

New module step added

AO_KritischeTexte

New module step added

KK_BaseTable

New module step added

KK_KritischeTexte

New module step added

KK_OffenePosten

New module step added

AI_Outliers (DEAN for base tables)

Reduced memory consumption by processing the data in chunks

PU_BaseTable

Added fields: EKPO_AFNAM, c_PU02_EKPO_AFNAM_DEPARTMENT

PU_BaseTable

Deletion of Temporary tables with remain after Data Download

PU_BaseTable

Check if Both Parallel SAP Download options are enabled at the same time. If Yes stop with Error Message

AU_DetectiveAuthAssurance

Analytic does generate empty result when excel file Authorization_Check.xlsx is empty

SD Module

Extended dab Link DisplaySalesDocuments by Adding VBTYP = "F" for DisplaySalesSchedulingAgreements

AP_ReverseDocs, AP_Round_Amounts, AP_Dupl_Payments

Extended check of Cancelled Documents by adding in the case of BKPF_AWTYP = 'RMRP' check via the RBKP (RBKP_STBLG)

Upfront Check

New variable in customization settings indicates if a task run should crash if execution of R was not successful

Error Messages

Appended when variable is set to False

AP_Dupl_Payments

Executed on ACL Analytics

Upfront Check

Check if project path contains minus and space (- ) or space and minus ( -) which lead to errors

2.6.1

2024-04-10

AP_Tax_CodeCheck & AR_TaxCodeCheck

Tax code (MWSKZ) "**" entries are no longer presented in the final result

Upfront Check R

Check for execution of Root Cause is now implemented properly

AI_Dupl_Payments

Enhance the length of the uniqueID when relating with the R result

AI_Dupl_Payments

Execution in continuous run might crash if executed multiple times on the same day

2.6.0

2024-03-06

AP_Tax_CodeCheck & AR_TaxCodeCheck

In case of MWSKZ = "**" include all line items of Document before applying filter conditions

GL_TaxCodeSample

For option TOP - Document is reported only once per Tax Code in Sample

GL_TaxCodeSample

For option TOP - new parameter v_GL_TaxCodeSample_Partner allows to specify that Partner will appear only once per Tax Code in Sample

TF_Import (Results Upload)

All dynamic fields (fields that contain fiscal year in the technical name) are now selected for the upload by default

AU_DetectiveAuthAssurance

Support For FI only cases

AU_DetectiveAuthAssurance

Added Condition & Info Records

Company Code Attribute

Fixed

Number fields in R-Enabled analytics

Are now independent of local settings

AP_AI_Outliers

Do Detection is now working, as the folder structure is now correct

R Upfront Check

Root Cause is now included properly

R RAM Check TF_AI_Outliers

Correct variable for the module is now used

Root Cause

Excluded DEAN and DQM from execution, additional fields to be encrypted, also possible for single tables

Download_framework

Fixed duplicate entries for dependencies with more than two fields

2.5.3

2024-02-20

AP_Dupl_Payments

Issue with execution of duplicate payment analytics on non-SAP data fixed

2.5.2

2024-02-12

AP_Dupl_Payments

Execution on non-SAP data failed fixed

2.5.1

2024-02-01

AP_Dupl_Payments

Execution on Desktop fixed

AU_DetectiveAuthAssurance

Fixed upload to Results and added column for visualization

R RAM Check

Fixed the RAM check for R-enabled analytics on multiprocessor configurations

2.5

2023-12-21

AR_Overpayments

Multiple incoming payments posted in one transaction as overpayment

GL_AI_MBA_Accounts

Unusual combinations when posting to G/L accounts

Download Framework

Adaptation to the new SAP Connector version V17 for parallel download (Expert setting)

Root Cause

Approach to create interpretation that explains big result sets from by automatically clustering on commonalities available for additional modules (VE, CU, PU, SD, DL, BL, AR, AM, GL, MD, MM)

PU_Open_Pos

Show also information about Incoterms (makes PU_Incoterms_OpenPO obsolete now), updated calculation for open PO amount

SD_BaseTable, BL_BaseTable, DL_Basetable

Add SAP dab Link to relevant documents

AP_Vendor_Ranking, AR_Customer_Ranking

Add Account Group Name to result

PU_CurrencyKeyChanges

Adjusted results sorting

AP_TaxCodeCheck, AR_TaxCodeCheck, GL_AccountCheck

Error message if the conditions reflect all entries in the BaseTable

GL_Commission

Add leading zeros to account number

PU_ExPost_Items

Add number of PO line items

GL_JournalEntryTesting

Upload to Results App

AP_Dupl_Payments, AP_Dupl_CredtiNotes

Use results-id for upload from TF_Import instead _Customization_Settings

PU_InvDate_bef_PO

Use the creation date of the item instead of the creation date of the PO to calculate the difference days

GL_AccountCheck

Add an additional level for conditions that is applied secondarily to the entire document

AU_AuthAssurance

Option to keep detail results (expert setting)

DL module

Add column "Delivered Net Value" to results from delivery (DL) module

Check

Available memory before executing R-Scripts

Analytics

Updated dialog and navigation with TAB when executing in Analytics (Desktop) version

2.4.5

2023-11-09

PU_BaseTable

Inaccurate currency conversion for contracts with a start date before the analysis period fixed

AI_Outliers

Issue identifying outliers in tables with only one numerical column fixed

2.4.4

2023-10-23

AP_Dupl_Payments

AI for detecting false positives can also be trained on data from different SAP systems

Currency Conversion

Optimisation if no exchange rates are available for the analysis period

AP_Invoice_wo_GR

Wrong internal variable used for the language of the description texts fixed

PU_BaseTable

Incorrect relation to display storage location description fixed

PU_ThreeWayMatch

Remove results with differences due to currency conversion into the reporting currency fixed

AP_Dupl_Payments

Different minor issues with the creation or display of the result fixed

PU_Outl_Agreement

Some PO items were not listed even though they were within the contract validity period fixed

2.4.3

2023-09-05

R-Script

Model extended for AI assessment to detect false positives in duplicate payments

AI_Dupl_Payments

Default values in start script and duplicates in pool file fixed

S4/HANA data

Issue with data extraction from S4/HANA tables when PrivacyProtection is enabled fixed

Root Cause

Issue with default interpretation if company code has less than 4 characters fixed

2.4.2

2023-08-29

GL_TaxCodeSample

New analytics: Sample of postings per tax code either top X values or record sample (expert setting)

AR_TaxCodeCheck

New analytics: Check for correct use of tax codes in customer subledger

AI_Dupl_Payments

New analytics: AI assessment to detect false positives on existing duplicate payment results (e.g., non-SAP data)

AP_BaseTable

Adding Indicator, European Union Member for vendor country as new field

AR_BaseTable

Adding country of goods recipient and Indicator, European Union Member for this country as new field

AI_CU_Duplicates, AI_VE_Duplicates, CU_AI_Duplicates, VE_AI_Duplicates

New category field to explain duplicate identification and exclusion of inactive partners

AI_CU_Outliers, AI_VE_Outliers, CU_AI_Outliers, VE_AI_Outliers

Exclusion of inactive partners (booking block, deletion flag)

Log files

Removed unnecessary log files and combined logs into one file package

CU_BaseTable, CU_CredLimit_Chg, SD_BaseTable

Performance issue extracting required SAP tables BUT000 and CVI_Cust_Customer fixed

AP_TaxCodeCheck, GL_Commission, AU_DetectiveAuthAssurance, GL_JournalEntryTesting

Issue with importing parameter files (TF_Import.xlsx) fixed

dab Parallex

Issue with configuration fixed

AI_Outliers

Issue with duplicate column titles fixed

Country keys

Incorrect and duplicate country keys in default list of critical countries fixed

2.4.1

2023-08-08

AU_DetectiveAuthAssurance

New: Detection of did-do authorisation conflicts within P2P process

AP_Dupl_Payments

Deleting temporary tables during the final clean-up fails fixed

2.4.0

2023-07-31

Results App

Create standard visualisations when uploading to Results App

Root Cause

Interpretation that explains big result sets from accounts payable module

AP_Invoice_wo_PO, AP_Open_Items, AP_Dupl_Payments

Default interpretation for common analyses

Electronic Banking (EB)

New module incl. EB_Diff_Payer, EB_Diff_Paym_Country

GL_JournalEntryTesting

Contra account analysis added

SupportPackage

Possibility to generate also for successful runs (expert setting)

2.3.9

2023-05-03

DependencyTables

Error when extracting tables within dependencies if the header table does not contain any records and DependencyWrapping is enabled fixed

2.3.8

2023-05-02

GL_JournalEntryTesting

New analytics: Checking the appropriateness of journal entries recorded in the general ledger (Beta Tester Version)

2.3.7

2023-04-17

GL_AccountCheck

New analytics: Checking general ledger postings by defining individual conditions in TF_Import.xlsx file

AP_BaseTable, AP_Invoice_wo_PO

Show the order number (list) of the contra account(s) in the result

AU_AuthAssurance

Indicator in the result for authorisations at different organisational levels is optional (expert setting)

AU_AuthAssurance

Optional additional parameter to specify a suffix for import file Authorization_Check.xlsx

AU_AuthAssurance

More flexibility in defining your own action IDs

AU_AuthAssurance

Allow the parameter keywords #ALLCC# and #PRODCC# also for runs based on previously extracted data

2.3.6

2023-04-04

AI_Outliers, AP_AI_Outliers, AR_AI_Outliers, BL_AI_Outliers, DL_AI_Outliers, MD_AI_Outliers, MM_AI_Outliers, PU_AI_Outliers, SD_AI_Outliers

New analytics: Statistically abnormal documents/postings

Results App

Allow multiple interpretations per results table when uploading

AU_AuthAssurance

Exclude/Classify of complete user types (USR02_USTYP)

GL_AI_Outliers

Implement a general approach to identify outliers (dab DEAN) and enable uploading to Results App

Dynamic Download

Performance improvement for large tables with dependency headers

Dynamic Download crash

Due to too big .log file (with activated dep_wrapping) fixed

AU_AuthAssurance

Deactivation of "Missing T-Code"-Feature when using ID-list per action fixed

AU_AuthAssurance

Incorrect check of apostrophe symbol as a value of an authorisation object fixed

2.3.5

2023-03-07

AU_AuthAssurance

Definition of several IDs (list) per action within the conflict definition enhanced

AP_Dupl_Payments

With activated AI false-positive detection: Adaptation to general update of R library function (str_detect) fixed

2.3.4

2023-02-27

AU_AuthAssurance

Enable the regular user exits feature

AP_Dupl_Payments

With activated AI false-positive detection: Issue with HighBond region setting for import from Results App fixed

AP_Dupl_Payments

Invalid column mapping in OneLine result on reference (XBLNR) for Results App upload fixed

AU_AuthAssurance

Indicator for authorisations at different organisational levels also shown within same ID/Action fixed

2.3.3

2023-02-08

AP_Dupl_Payments

With activated AI false-positive detection: Issue with key fields and missing initial table for log fixed

2.3.2

2023-02-03

AU_AuthAssurance

Individual classification of users by extending the AllowList definition

AU_AuthAssurance

Indicator in the result for authorisations at different organisational levels

CU_AI_Duplicates, CU_AI_Outliers, VE_AI_Duplicates, VE_AI_Outliers

Extended the field lists in the result by fields of the basetables

AU_Change_User

Typo in the definition of the filter (range filter) fixed

CU_AI_Duplicates, CU_AI_Outliers, VE_AI_Duplicates, VE_AI_Outliers

Invalid results due to different company code assignments fixed

AP_Dupl_Payments

With activated AI false-positive detection: Inconsistent UpdateKey for OneLine and Detail result fixed

2.3.1

2023-01-13

P2P_ImpactBoard

Separation of download and analysis execution enhanced

PI_O2C_Eventlog

Automatic field always being 0 fixed

AI Scripts

Using an invalid package for AI scripts that detect master data duplicates fixed

Statistics

Execution of additional scripts required without valid license fixed

2.3.0

2022-12-22

MasterDataQualityPackage

New analytics: Set of 15 analytics to analyse customer and vendor master data including VAT ID check, duplicates, and outliers

P2P_ImpactBoard

Evaluation of all analyses on purchase-to-pay process, multi-year comparison, company code benchmark

Data Extraction

Option to use alternative packages (expert setting)

Results App

Capability to automatically create visualizations (interpretations)

CU_BA_Changes, CU_Duplicates_BA, VE_BA_Changes, VE_Duplicates_BA

New field with list of company codes in which affected partners exist

VE_BA_ShortLife

Extra field with “Lifetime in Days” added

DL_Del_wo_Inv

Exclude delivery documents if invoice based on sales order and not delivery document; Additional status field added

DL_Delivery_Crit_Cntry

New fields with info about affected material documents added

AP/AR/GL_Round_Amounts

Exclude cancelled documents from result and show more relevant categories

AP_Dupl_Payments

Adjustment and rearrangement of fields for visualization in Results App

AU_AuthAssurance

Rename spreadsheet to AllowList, additional field for conflict identification

GL_AI_Outliers

Smaller performance adjustment in R-Script and renaming from GL_Outliers to GL_AI_Outliers

AI_CU_Outliers, AI_CU_Duplicates, AI_VE_Outliers, AI_VE_Duplicates

Smaller performance adjustment in R-Script and renaming from AI_CU_Quality_Management, AI_VE_Quality_Management

All relevant analytic results

Additional field as indicator for intercompany transactions added

2.2.3

2022-10-14

O2C Event Log

Incorrect field length for Resource field fixed

2.2.2

2022-10-07

Dynamic Download

Additional alternative export-package enhanced

2.2.1

2022-09-13

AP_TaxCodeCheck

New analytics: Check for correct use of tax codes using TF_Import.xlsx

R Analytics

Performance improvement for AP_Dupl_Payments, GL_Outliers

Results App

Length of table name adapted to max 80 characters

GL_Outliers

Fails if the analysis is the only one executed

AI_CU_Quality_Management, AI_VE_Quality_Management

Invalid column titles shown in result fixed

2.2.0

2022-07-14

GL_Outliers

New analytics: Machine learning algorithm used to search for unusual rows

AI_CU_Quality_Management

New analytics: Check data quality of customer master data including duplicates and unusual entries

AI_VE_Quality_Management

New analytics: Check data quality of vendor master data including duplicates and unusual entries

Company Codes

Option to download/analyse all by entering #ALLCC# (all) or #PRODCC# (productive)

Error Messages

Error message for wrong parameters (invalid CompanyCodes, not licensed steps etc.)

Starter Packages

Integration of predefined starter packages as module parameter

Date Period

Parameter to calculate analytic scope automatically

dab Parallex integration

Once licensed, can be easily activated without additional scripts

DLL Version

DLL version shown in StartSkript project and log of every task run

Results App

Automatically set primary field when uploading

AP_Dupl_Payments

Prediction of false positives based on past results, including workflow in Results App

AU_AuthAssurance

dabLink integration to open user with SU01 T-Code in SAP; AllowList to exclude user/conflict combination

AU_AuthAssurance

Simulation to check if assigning an additional role to user leads to conflict

AU_AuthAssurance

Option to exclude "Missing T-Code feature" (expert setting)

AM_NeverDepr, MD_InvCounts, BL_BaseTable, AP_CPD, AU_AutomaticLoginSapStar, PI_O2C_EventLog, CU_VAT_ID_Check, VE_VAT_ID_Check

Extended/improved info presented in result

PU_Basetable

Include contracts/scheduling agreement created before analysis period

PI_O2C_EventLog

Consider multiple account assignment

AU_Critical_Profiles

Allow individual definition of critical profiles/roles in TF_Import.xlsx

Folder Structure

Improved in StartScript project and logs

AP_PaymTerm_Chg, CU_Duplicates_BA, AP_Dupl_Payments_OneLine

Update keys not unique/existing fixed

dab SpreadsheetBeautifier

End time shown twice on cover sheet fixed

TF_Import.xlsx

Incorrect/inconsistent texts and descriptions fixed

ACL$TabaleList.csv

Conflict when CSV selected as export format fixed

Filter Variable

For download of change tables truncated when more than 50 company codes selected

2.1.6

2022-06-01

O2C Event Log

Timestamp (hour specification) not displayed correctly fixed

2.1.5

2022-02-28

Dependency Downloads

Option to outsource into separate ACL project (expert setting) enhanced

2.1.4

2022-02-23

AP_Dupl_Payments

Additional columns for OneLine result enhanced (expert setting)

Privacy Protection

Individual definition of fields to be encrypted (expert setting)

2.1.3

2022-02-15

SD_ConditionChanges

Error with dynamic download fixed

2.1.2

2022-02-01

SD_Critical_Countries

New analytic: identify sales documents with partner in critical country

Dynamic Download

Improvement: filter REGUH/REGUP from BUKRS to ZBUKR

Dependency Tables

Error with downloading additional fields fixed

2.1.1

2022-01-17

CU_Crit_Ctrys_BA_Dtl

Not unique c_updatekey fixed

AP_Dupl_Payments

Issue when activating v_AP_DuplPaym_OneLine = T (expert setting) fixed

Results App

Issue with upload for AR Module fixed

EventLog

Fieldlist issue fixed

TF_Import.xlsx

Duplicate entries fixed

2.1.0

2021-12-14

Scheduling

New parameters and features to facilitate task scheduling

Date Period

Parameter to calculate date period automatically

Results App

Option to upload to existing tables (Append/Overwrite) including spreadsheet in TF_Import.xlsx

Results App

Unique update key field in every result table for primary key

AU_AuthAssurance

New analytics: check on segregation of duties conflicts

AU_AdaptiveAuthAssurance

New analytics: identifies outliers using machine learning (Beta)

AR_PaymTerms_Comp

New analytics: comparing used payment terms on outgoing invoices with sales order

BaseTable

Configuration of used date field basis per BaseTable (expert setting)

Dynamic Download

Option to use individual download packages

Results Visualization

Visualizing the result using decision trees (Beta)

Excel Export

Integrated solution for advanced configurations (Beta)

CU_VAT_ID_Check, VE_VAT_ID_Check

Display response from VIES service

Fiscal Year

Determine automatically from entered date period

GL_CriticalTexts

Additional column to classify critical texts (category from TF_Import.xlsx)

Vendor/Customer Analytics

Additional column: Creation Year Month

Statistical Net Value

Additional column to exclude items when adding up billing documents

VE_DaysTilUsed

Configurable filter for number of days between vendor creation and first FI document (expert setting)

SD_ConditionalChanges

Show changed conditions individually (expert configurable)

AP_Dupl_Payments

Option to structure results into one record for better follow-up management via questionnaires (expert setting)

AP_Dupl_Payments

Different unique IDs and separate time scope for upload to Results App (expert


How did we do?


Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)