Content Release Notes 2.x

Updated 3 months ago by Stephanie Krenz

Release Notes 2.8.0

New:

• HR module:
  • Content for SAP HR Module
  • Base Tables for master data, action types and organization structure
  • Added new analytic steps
    • Additional payments
    • Salary changes
    • Master data duplicates
    • Re-employment

Enhanced:

• MD_UnusualPosting
  • Option in _Customization_Settings to set movement type
  • Basetable fieldlist adjusted
• All DEAN Analyses
  • Additional split when a chunk is bigger than 1 million records
  • 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 

Fixed:

• 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

Release Notes 2.7.0

New:

• 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 containing the analytic steps
  • AO_BaseTable
  • AO_Daueranordnungen
  • AO_KritischeTexte
  • KK_BaseTable
  • KK_KritischeTexte
  • KK_OffenePosten

Enhanced:

• 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
• Deletion of Temporary tables with remain after Data Download
• 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)

Fixed:

• Upfront Check
  • AU_DetectiveAuthAssurance
  • GL_JournalEntryTesting
• AI Logging
  • New variable in customization settings, that indicates if a task run should crash, if the execution of R was not successfull
  • Error Messages are appended when variable is set to False
• AP_Dupl_Payments executed on ACL Analytics
  • Upfront check if project path contain minus and space (- ) or space and minus ( -) which lead to errors

Release Notes 2.6.1

Enhanced:

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

Fixed:

• 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
  • Execution in continuous run might crash if executed multiple times on the same day

Release Notes 2.6.0

Enhanced:

• Added c_XX02_CONTRA_HKONT fields in tax code analytics
• Added BKPF_GLVOR and amount binning to root cause analytics
• Added c_GL02_HKONT_SKAT_TXT20 to GL_AI_MBA_Accounts_Dtl Fieldlist
• Adjust structure of import file of AI_Dupl_Payments
• Add files AI_Dupl_Payments_Pool and Unseen_Data_Dtl_Template required for AI_Dupl_Payments to Additional_Files
• AP_Tax_CodeCheck & AR_TaxCodeCheck
  • In case of MWSKZ = "**" we do 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
  • For option TOP - new parameter v_GL_TaxCodeSample_Partner - which allow 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
  • Added Condition & Info Records
  • Fixed Company Code Attribute

Fixed:

• Number fields in R-Enabled analytics are now independed of local settings
• Selection of dynamic fields in Results upload in AP_Vendor_Ranking
• AP_EntryTimeLags
  • c_AP32_BSAK_BLDAT -> c_AP23_BSAK_BLDAT
• GL_AI_MBA_Accounts_Dtl
  • Changed Error Handling
  • Excluded from Root Cause execution for GL
• Dependency Extraction
  • It is now also possible to extract layout only for dependency tables
• AP_AI_Outliers
  • Do Detection is now working, as the folder structure is now correct
• R Upfront Check
  • Root Cause is now included properly
  • Version in start script updated
• 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

Release Notes 2.5.3

Fixed:  

• An issue with the execution of duplicate payment analytics on non-SAP data was fixed

Release Notes 2.5.2

Fixed:  

• Execution of duplicate payment analytics on non-SAP data failed

Release Notes 2.5.1

Fixed:  

• Execution of duplicate payment analytics on Desktop
• AU_DetectiveAuthAssurance: Fixed upload to Results and added column for visualization
• Fixed the RAM check for R-enabled analytcis on multiprocessor configurations which prevented running of those analytics

Release Notes 2.5

New:  

• AR_Overpayments: Multiple incoming payments posted in one transaction as overpayment 
• GL_AI_MBA_Accounts: Unusual combinations when posting to G/L accounts 

Enhanced:  

• Adaptation of the download framework 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) 
• Add column "Delivered Net Value" to results from delivery (DL) module 
• Check available memory before executing R-Scripts 
• Updated dialog and navigation with TAB when executing in Analytics (Desktop) version 

Fixed:  

• AP_Dupl_Payments: Issue with executing duplicate payments analytic in ACL Desktop 
• AR_Tax_CodeCheck:  missing fields in results upload 
• MM_MaterialText_Changes, MM_TaxClassification, VE_BA_Changes, AP_CPD, PU_SchedOvrlap, VE_AI_Fuzzy_Duplicates: Update key not unique  
• CU_BaseTable: Currency conversion issue and update relations  
• AM_BaseTable: Currency conversion issue 
• Typo in field list selection used for download framework 
• Individual analytic parameter is case sensitive 
• Metric in Results App with the number of data records shows per year instead of total 
• Issue executing StarterPackage_P2P

Release Notes 2.4.5

Fixed:

• PU_BaseTable: Inaccurate currency conversion for contracts with a start date before the analysis period 
• **_AI_Outliers: Issue identifying outliers in tables with only one numerical column 

Release Notes 2.4.4

Enhanced:

• AP_Dupl_Payments: AI for detecting false positives can also be trained on data from different SAP systems
• Optimisation of currency conversion if no exchange rates are available for the analysis period    

Fixed:

• AP_Invoice_wo_GR: Wrong internal variable used for the language of the description texts
• PU_BaseTable: Incorrect relation to display storage location description
• PU_ThreeWayMatch: Remove results with differences due to currency conversion into the reporting currency  
• AP_Dupl_Payments: Different minor issues with the creation or display of the result (character limits, decimal place symbol, NotFirst-flag, VendorDuplicate-flag)
• PU_Outl_Agreement: Some PO items were not listed even though they were within the contract validity period
• **_AI_Outliers: Issue of displaying date fields as a reason for statistically abnormal documents

Release Notes 2.4.3

Enhanced:

• Improve performance by extending the R-Script model for AI assessment to detect false positives in the analysis of duplicate payments and credits 

Fixed:

• AI_Dupl_Payments: Default values in start script and duplicates in pool file
• Issue with data extraction from S4/HANA tables when PrivacyProtection is enabled
• Issue with default interpretation (root cause) if the company code has less than 4 characters

Release Notes 2.4.2

New:

• New analytics:
  • GL_TaxCodeSample: Sample of postings per tax code either top X values or record sample (expert setting) 
  • AR_TaxCodeCheck: Check for correct use of tax codes in customer subledger using defined conditions in TF_Import.xlsx file
  • AI_Dupl_Payments: AI assessment to detect false positives on existing duplicate payment results (e.g., non-SAP data).

Enhanced:

• 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 (booking block, deletion flag)
• AI_CU_Outliers, AI_VE_Outliers, CU_AI_Outliers, VE_AI_Outliers: Exclusion of inactive partners (booking block, deletion flag)
• Removed unnecessary log files and combined logs into one file package

Fixed:

• CU_BaseTable, CU_CredLimit_Chg, SD_BaseTable: Performance issue extracting required SAP tables BUT000 and CVI_Cust_Customer
• AP_TaxCodeCheck, GL_Commission, AU_DetectiveAuthAssurance, GL_JournalEntryTesting: Issue with importing parameter files (e.g. TF_Import.xlsx) when running in Analytics for Windows
• Issue with configuration of dab Parallex
• **_AI_Outliers: Issue with duplicate column titles
• Incorrect and duplicate country keys in default list of critical countries predefined in TF_Import.xlsx

Release Notes 2.4.1

New:

• AU_DetectiveAuthAssurance: Detection of did-do authorisation conflicts (flexibly configurable) within the P2P process

Fixed:

• AP_Dupl_Payments: Deleting temporary tables during the final clean-up fails if the AI approach for detecting false positives is enabled

Release Notes 2.4.0

New:

• Create standard visualisations when uploading to Results App
  • Interpretation that explains big result sets from accounts payable module by automatically clustering on commonalities (Root Cause approach) 
  • Default interpretation for our most common analyses e.g. AP_Invoice_wo_PO, AP_Open_Items, AP_Dupl_Payments...
• New module Electronic Banking (EB) inclulding two new AnalyticSteps
  • EB_Diff_Payer: Payer on bank statement is different to customer master data
  • EB_Diff_Paym_Country: Incoming payments where the bank country is different to the home country of the customer
• Contra account analysis added to GL_JournalEntryTesting
• Possibility to generate a SupportPackage also for successful runs (expert setting)

Enhanced:

• Updated selection of relevant AnalyticSteps that are part of various StarterPackages
• More detailed description of the start scripts (Download Data, Run AnalyticSuite, Run Process Intelligence) and its parameters
• P2P_ImpactBoard:
  • Individual start script and download package for execution
  • Updated selection of relevant AnalyticSteps 
  • Keep detail results for AnalyticSteps with valid licese after KPI generation 
  • Upfront check of the licences
  • Additional result table to create visualisations on
• AI_CU_Duplicates, AI_CU_Outliers, AI_VE_Duplicates, AI_VE_Outliers, CU_AI_Duplicates, CU_AI_Outliers, VE_AI_Duplicates, VE_AI_Outliers:
  • Improve the approach to identifying outliers and duplicates using AI methods by standardising the data to be transferred into R
  • Display UniqueID as a character and not as a numeric field
• VE_BA_Changes: Show change of bank details only once if the change is due to an adjustment of the IBAN. The SAP change log tracks such adjustments for both tables (TIBAN and LFBK) by default.
• CU_FirstPayment, VE_FirstPayment: Allow to configure the number of days between vendor creation and the first payment and sets the default to 1 day (expert setting)
• CU_BaseTable, CU_CredLimit_Chg, SD_BaseTable, SD_CredLimit, SD_CredLimit_Exceed, SD_CredLimitCh: Consider S/4 tables for credit limit calculation 
• PU_GRVal_vs_IRVal, PU_GRQty_Vs_IRQty: Exclude records from result where no goods receipt is expected
• PU_InvVal_vs_PO: Exclude records with goods receipt expected
• PU_Outl_Agreement: List of contract numbers that could have been used at creation of PO items and exclude records from the result for which no valid contract existed
• PU_InvDate_bef_PO: Using item creation date instead of PO document creation date for calculation of "Invoice days before PO date"-field 
• PU_BlockRemove: Exclude records without postings after reactivation by removing the block
• PU_Comp_Quantities: Additional field indicating whether the difference is above tolerance or unlimited overdelivery is allowed, and excluding records that have a difference within tolerance
• PU_NetPriceChanges, PU_PriceUnitChanges, PU_QuantityChanges:
  • Additional field to display the category for change impact e.g. price increase >50% or quantity reduction < 10%
  • Additional results table comparing the oldest and the most recent value 
• DL_BaseTable: Adding the delivery type [LIKP_LFART] as an additionally available field
• AP_Dupl_Payments:
  • Flag records where a credit note for the vendor and the compnay in the same amount exists
  • Exclude potential duplicates with different month names in the invoice reference
  • Additional field showing date of script execution and analysed periode
  • Improving the approach to predict false positives using AI methods by combining pool and unseen data in the transfer to R
  • Upfront check of initial pool to see if at least 5 hits are flagged as actual duplicates and 5 hits are flagged as false-positive duplicates before running the AI algorithm 
  • Add combined field "Name of Company Code, Country and Currency Key" to OneLine result
• AR_Dupl_CreditNotes: Prediction of false positives based on past results using AI methods, including workflow in Results App to flag new results and train the algorithm
• AU_AuthAssurance: Additonal field with list of roles/profiles responsible for the conflict in the summarised conflict result
• GL_AI_Outliers: Possibility to upload the result to Results App
• Updated fields displayed in the result (/reason area): AP_CPD, AR_CPD, PU_Reanimated_POs, CU_VAT_ID_Check, VE_VAT_ID_Check, DL_Incoterms_MD, GL_CriticalTexts, PU_CurrencyKeyChanges, VE_BA_Changes
• Updated parameter files (TF_Import.xlsx)
  • Proposal for definition of critical countries
  • Adding missing fields from the results tables in worksheet FieldlistSelection
  • Adjusting the default setting for fields to be uploaded to the Results App 
  • Adding missing result tables in worksheet ScheduledResultsUpload
  • Rename worksheets: WhiteList to AllowList
  • Activate KPIWiz by default for PU_Tolerances
• Automatic upfront check on proper installation of R-Studio and required libraries to perform analyses using AI algorithms
• Removed unnecessary variables and restructure the script _Customization_Settings which is used for expert settings
• A respective error message if no value for parameter X was specified at dynamic calculation of the analysis period
• Adaptation of the new Excel export engine available as of ACL version 16.1
• Improve all analyses with AI methods by changing the file type for internal data transfer to .json.

Fixed:

• AI_CU_Duplicates, AI_CU_Outliers, AI_VE_Duplicates, AI_VE_Outliers, CU_AI_Duplicates, CU_AI_Outliers, VE_AI_Duplicates, VE_AI_Outliers:
  • In some cases, the same company code is listed twice
  • Issue with the display of UNICODE characters
  • Missing folder structure for result tables when running in ACL Analytics (local)
• VE_BA_Changes: Stating the master data information in different languages depending on the table with changes
• SD_BaseTable: Invalid field lengths of user, data and time 
• SD_ConditionChanges: Incorrect preparation of raw tables when running on S/4HANA-Systems 
• BL_TaxClass_Diff: Not all tax classifications were considered in comparison
• AP_Invoice_wo_PO: Incorrect naming of a UserExit location
• AP_Dupl_Payments: Incorrect column titles
• AM_BaseTable:
  • UpdateKey not unique as depreciation area is missing
  • Shows the most recent asset allocation instead of the allocation within analysis period
• GL_AI_Outliers: Formatting issues in column Detected_by_DEAN_because
• GL_AccountCheck: Wrong field name used in the rule definition example 
• MM_BaseTable:
  • Issue with lenght of material number when running on S/4HANA-Systems 
  • Incorrect column title for a separator field
• MD_InvCounts: Invalid description for a status field value
• Inaccurate currency conversion for documents created outside the analysis period
• Script Error if the robot name has a dot in the name and Dependency-Download-wrapping is activated
• Issue with error messaging when using the start script Download Data
• Limited length of variables for expert settings

Release Notes 2.3.9

Fixed:

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

Release Notes 2.3.8

New:

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

Release Notes 2.3.7

New:

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

Enhanced:

• 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)
  • Optional additional parameter to specifiy a suffix for import file Authorization_Check.xlsx
  • More flexibility in defining your own action IDs
• Allow the parameter keywords #ALLCC# and #PRODCC# also for runs based on previously extracted data

Release Notes 2.3.6

New:

• New analytics:
  • AP_AI_Outliers, AR_AI_Outliers, BL_AI_Outliers, DL_AI_Outliers, MD_AI_Outliers, MM_AI_Outliers, PU_AI_Outliers, SD_AI_Outliers: Statistically abnormal documents/postings

Enhanced:

• Allow multiple interpretations per results table when uploading to the Results App
• 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 the Results App.
• Performance improvement for dynamic download (for large tables with dependency headers)

Fixed:

• Dynamic download crash due to too big .log file (with activated dep_wrapping)
• AU_AuthAssurance:
  • Deactivation of the "Missing T-Code"-Feature when using the ID-list per action is not working properly
  • Incorrect check of the apostrophe symbol as a value of an authorisation object  

Release Notes 2.3.5

Enhanced:

• AU_AuthAssurance: Definition of several IDs (list) per action within the conflict definition

Fixed:

• AP_Dupl_Payments (with activated AI false-positive detection): Adaptation to the general update of an R library function (str_detect)

Release Notes 2.3.4

Enhanced:

• AU_AuthAssurance: Enable the regular user exits feature

Fixed:

• AP_Dupl_Payments (with activated AI false-positive detection): Issue with HighBond region setting for import from Results App
• AP_Dupl_Payments: Invalid column mapping in OneLine result on reference (XBLNR) for Results App upload 
• AU_AuthAssurance: Indicator for authorisations at different organisational levels also shown within same ID/Action

Release Notes 2.3.3

Fixed:

• AP_Dupl_Payments (with activated AI false-positive detection): Issue with key fields and missing initial table for log

Release Notes 2.3.2

Enhanced:

• AU_AuthAssurance:
  • Individual classification of users by extending the AllowList definition
  • 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

Fixed:

• AU_Change_User: Typo in the definition of the filter (range filter)
• CU_AI_Duplicates, CU_AI_Outliers, VE_AI_Duplicates, VE_AI_Outliers: Invalid results due to different company code assignments
• AP_Dupl_Payments (with activated AI false-positive detection): Inconsistent UpdateKey for OneLine and Detail result

Release Notes 2.3.1

Enhanced:

• Separation of download and analysis execution for P2P_ImpactBoard

Fixed:

• PI_O2C_Eventlog: Automatic field always being 0
• Using a invalid package for AI scripts that detect master data duplicates
• Execution of additional scripts required for statistics, withouth valid lizesese for P2P_ImpactBoard

Release Notes 2.3.0

New:

• MasterDataQualityPackage: Set of 15 analytics to analyse customer and vendor master data from different point of views including VAT ID check and via artificial intelligence identified duplicates and outliers
• P2P_ImpactBoard: Evaluation of all our analyses on the purchase-to-pay process in terms of hit quantity and volume, multi-year comparison and company code benchmark for various use cases e.g.: identification of weak points in the process, risk-oriented audit planning, performance indication of measures... 
• Option to use alternative packages for data extraction (expert setting)
• Capability to automatically create visualizations (interpretations) when uploading to Results App

Enhanced:

• CU_BA_Changes, CU_Duplicates_BA, VE_BA_Changes, VE_Duplicates_BA: New field with list of company codes in which the affected partners exist
• VE_BA_ShortLife: Extra field with “Lifetime in Days” next to the existing composite field to improve the filtering options during the follow-up
• DL_Del_wo_Inv:
  • Exclude delivery documents if the invoice is based on a sales order and not on a delivery document
  • Additional status field explaining the results
• DL_Delivery_Crit_Cntry: New fields with information about affected material document added to the result
• AP/AR/GL_Round_Amounts: Exclude cancelled documents from result and show more relevant categories
• AP_Dupl_Payments: Adjustment and rearrangement of some fields relevant for the visualization in the Results App
• AU_AuthAssurance:
  • Rename the spreadsheet to exclude users and conflicts from the result to AllowList
  • Additional field for clear identification of conflicts when creating metrics and visualisations in the Results App.
• 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 
• Additional field as indicator for intercompany transactions in all relevant analytic results (additional to the value of VBUND-field)
• More informative error messages for failed runs
• Adjustment of the default separator for CSV export
• Updated default settings for uploading to the Results App, such as hiding the UpdateKey field and other minor adjustments

Fixed:

• AP_Vendor_Ranking, AR_Customer_Ranking: No exclusion of intercompany partners despite selection in the analysis parameter
• AP_Vendor_Ranking: Including years that come after the specified end date of the analysis period
• MM_MovAvgPrice_Compare: Incorrect formatting (missing leading 0) in the field of the current posting period within a temporary result table
• CU_DelBlock_Chg: Incorrect information shown in the sales organization field
• SD_Inco_Changes: Duplicates in the result presentation
• PU_PriceUnitChanges: Update key for upload to Results App not unique
• AP_TaxCode_Check: Old open items part of the result and run fails if no condition was defined
• PI_O2C_Eventlog: Automatic field always being 0 when privacy protection was enabled
• TF_Import.xlsx: Incorrect/inconsistent texts and descriptions and irrelevant dabLink-fields
• Missing columns in upload to Results App e.g., for AP_Vendor_Ranking
• Error when setting additional fields for the extraction although they are already included in the download package
• Irrelevant logs from upload to Results App process

Release Notes 2.2.3

Fixed:

• incorrect field length for Resource field in O2C event log

Release Notes 2.2.2

Enhanced:

• additional alternative export-package for dynamic download framework

Release Notes 2.2.1

New:

• New analytics:
  • AP_TaxCodeCheck: Check for correct use of tax codes using defined conditions in TF_Import.xlsx file

Enhanced:

• Performance improvement for analytics using R (AP_Dupl_Payments, GL_Outliers)
  

Fixed:

• Length of the table name for upload to Results adapted to the new maximum length of 80 character for interpretations
• 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 

Release Notes 2.2.0

New Feature:

• New analytics:
  • GL_Outliers: A machine learning algorithm is used to search for unusual rows in our general ledger BaseTable.
  • AI_CU_Quality_Management: Check data quality of customer master data (KNA1) including duplicates and unusual entries.
  • AI_VE_Quality_Management: Check data quality of vendor master data (LFA1) including duplicates and unusual entries.
• Option to download and analyse all company codes by entering a keyword as a parameter;
  #ALLCC# for all and #PRODCC# for only those marked as productive.
• Error message when entering wrong parameters e.g. invalid ComanyCodes, not licensed steps etc.
• Integration of predefined starter packages as module parameter.
• Parameter to calculate date period (analytic scope) automatically in download start script.
• dab Parallex integration - once a client has licensed this feature, it can be easily activated without the need for additional scripts.  
• DLL version shown in StartSkript project and log of every task run.
• Automatically set primary field when uploading to the Results App.

Enhanced:

• AP_Dupl_Payments:
  • Prediction of false positives based on past results, including workflow in Results App to flag new results.
  • Including not cleared invoices, activated by default (expert setting).
• AU_AuthAssurance:
  • dabLink integration to open user with SU01 T-Code in SAP.
  • AllowList to exclude user/conflict combination.
  • Simulation to check whether assigning an additional role to the user will lead to a conflict.
  • Creating own IDs (sets of authorization objects) to be checked in conflicts.
  • 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 information presented in result. 
• PU_Basetable: Include contracts/scheduling agreement created before the analysis period.
• PI_O2C_EventLog: consider multiple account assignment.
• AU_Critical_Profiles: allow individual defintion of critical profiles/roles in TF_Import.xlsx.
• Folder structure in StartScript project and generated result package project.
• Folder structure of logs stored on the server (VATID-Check, dab SpreadSheetBeautifier ...).

Fix:

• AP_PaymTerm_Chg, CU_Duplicates_BA, AP_Dupl_Payments_OneLine: update keys not unique/existing.
• dab SpreadsheetBeautifier: end time is shown twice on the cover sheet.
• TF_Import.xlsx: incorrect/inconsistent texts and descriptions.
• Conflict with ACL$TabaleList.csv when CSV is selected as export format.  
• Filter variable for download of change tables is truncated when more than 50 company codes selected.

Release Notes 2.1.6

Fix

• Timestamp (hour specification) in the O2C event log was not displayed correctly

Release Notes 2.1.5

Enhanced

• Option to outsource dependency downloads into a separate ACL project to avoid size limitations (expert setting)

Release Notes 2.1.4

Enhanced

• Additional columns for AP_Dupl_Payments (OneLine) result used for better follow-up management (expert setting)
• Individual definition of fields to be encrypted at privacy protection feature (expert setting) [compatible only with dab AS Configurator version 5.0.0] 

Release Notes 2.1.3

Fix

• Error with dynamic download for analytic SD_ConditionChanges  

Release Notes 2.1.2

New Feature

• New analytic: SD_Critical_Countries to identify sales documents with at least one partner in a critical country

Enhanced

•  Improve Standard-Package for dynamic download by changing filter on REGUH and REGUP from BUKRS to ZBUKR  

Fix

• Error with dependency tables when downloading additional fields required for customer adjustments (expert setting)

Release Notes 2.1.1

Fix

• Not unique c_updatekey for CU_Crit_Ctrys_BA_Dtl
• Error when activating v_AP_DuplPaym_OneLine = T (expert setting)
• Issue with upload to Results for AR Module
• Fieldlist issue with EventLog creation
• Duplicate entries in TF_Import.xlsx

Release Notes 2.1.0

New Feature

• New parameters and features to facilitate the scheduling of tasks:
  • Parameter to calculate date period (analytic scope) automatically
  • Option to upload to existing tables in Results App (Append or Overwrite) including a new spreadsheet in TF_Import.xlsx to specify the table IDs
  • Unique update key field in every result table to be used for primary key field selection in Results App
• New analytics:
  • AU_AuthAssurance to check on segregation of duties conflicts
  • AU_AdaptiveAuthAssurance identifies outliers using machine learning (Beta Tester Version)
  • AR_PaymTerms_Comp comparing used payment terms on outgoing invoices with payments terms defined in sales order and master data
• Configuration of used date field basis per BaseTable (expert setting)
• Dynamic download for eventlog generation (dab ProcessInteligence)
• Option to use individual download packages (setting done by consultant)
• Visualizing the result using decision trees (Beta Tester Version)
• Integrated Excel export solution for advanced configurations (Beta Tester Version)

Enhanced

• CU_VAT_ID_Check, VE_VAT_ID_Check: display response received from VIES service on qualified check fields (name, address)
• Determine Fiscal Year(s) parameter automatically from entered date period – In case of deviating fiscal year, setting can be done by an expert
• Additional column in GL_CriticalTexts to classify critical texts (category defined in TF_Import.xlsx)
• Additional column: Creation Year Month in all vendor and customer master data analytic steps
• Additional column: Statistical net value of the billing item in reporting currency to exclude such items when adding up billing documents
• Configurable filter in VE_DaysTilUsed on number of days between vendor creation and first FI document (expert setting)
• Show changed conditions in SD_ConditionalChanges as individual configuration of such is possible by an expert
• Option to structure AP_Dupl_Payments results into one record for better follow-up management via questionnaires in Results App (expert setting)
• Different unique IDs for AP_Dupl_Payments and a separate time scope (expert setting) for upload to Results App to create an individual update and follow-up process.
• Separate selection on fields to be exported to Excel (TF_Import.xlsx)
• Adjusted download package for better performance

Fix

• Error when generating Eventlogs on S4/HANA data
• Sorting of tables presented in Results App after upload
• Incomplete names/descriptions used for upload to results (TF_Import.xlsx)
• Bad dialog visibility when executing locally in Analytics and having a low screen resolution
• Limited number of company codes that can be entered

How did we do?

Related Articles

• Release Notes 2.x
• Release Notes 2.x
• Content Release Notes 2.3.x (SQL)