ERP document reconciliation

ERP Recon batch status report

The ERP Recon Batch Status report allows users to easily monitor the status of their Batch UUIDs, providing users with clear visibility into their ERP Recon Data as it arrives within the Reports & Analytics platform.
Key features include:
  • Batch UUID Monitoring
    : Track the status of Batch UUID effortlessly.
  • Enhanced Visibility
    : Gain insights into ERP Recon data with ease.
  • Mandatory Input Control parameters:
    • Batch UUID
    • Batch Status
  • Default Columns in the report:
    • Start Date Timestamp: UTC format 'MMM DD, YYYY, hh: mm: ss AM/PM'
    • End Date Timestamp: UTC format 'MMM DD, YYYY, hh: mm: ss AM/PM'
    • Batch UUID (No duplicates)
    • Batch Status (NEW, IN PROGRESS, COMPLETED WITH ERRORS, SUCCESS, FAILED)
  • Report Features:
    • No Edit allowed (Read only report)
    • View Full report, Export and schedule options available
    • No preview data option available for this report
    • User can create Filters for following fields:
      • Batch UUID - Options for Select, Select all and None
      • Batch Status- Options for Select, Select all and None
    • Reporting Roles Report access requirements: All Reporting roles will be able to view the report

ERP document reconciliation report

The ERP Document Reconciliation report is now available for customers to enable the reconciliation process of ERP data. This powerful tool enables users to efficiently reconcile payables, receivables, and FI transaction data from the General Ledger.
Key Updates
ERP Document Reconciliation Report will be visible for all customers and there must be an enablement step to see data in the report, until that is done the report will not show any output. Review the SAP Integrations Reconciliation extract report for more information.
The report will display various reconciliation statuses, including:
Key Updates
  • 'Not in Reporting'
  • 'Not in ERP'
  • 'Taxes Different'
  • 'Match'
Input Controls
  • Mandatory
    • Company Name
    • Date Type
    • Start Date
    • End Date
    • Omit Zero Tax Transactions
    • Show Only Match Records
    • Show Missing ERP Documents
    • Show Missing Reporting Documents
    • Show Tax Differences as Exception Records
  • Optional
    • Host System
    • Calling System Number
    • Company Roles
    • Batch UUID
Report Features
  • Preview Report, Export and Schedule Options:
    Available for the report.
  • Reporting Roles Report access requirements:
    All Reporting roles will be able to view the report.
  • Default Columns in Edit Mode
    • Company Name
    • Company Role
    • Document Number
    • Document Date
    • Reconciliation Result
    • Tax Amount
    • ERP Tax Amount
    • Tax Difference (Note: Calculated only when values are present in both Tax amount and ERP Tax Amount)
    • % Tax Difference (Note: Calculated only when values are present in both Tax amount and ERP Tax Amount)
    • Gross Amount
    • ERP Gross Amount
    • ERP Document Type
    • ERP Transaction ID
    • ERP Partner Number
    • ERP Partner Name
    • ERP Document Description
    • ERP Document Currency
    • ERP Period
    • ERP Fiscal Date
    • Fiscal Date
    • Fiscal Date Difference Options: "Yes" if there is a discrepancy between the ERP Fiscal Date and the Fiscal Date. "Null" if the ERP Fiscal Date and the Fiscal Date match.
    • Document Currency
    • Host System
    • Calling System Number
    • ERP User Defined Field 1-5
    • Batch UUID
    • Additional Columns available in Edit Mode/Ad-hocView.
      • Custom Attributes 1-50
      • ERP User Defined Fields 1-20
      • External Company ID
Field information
Field Name
Description
Company Name
The Company Name from Determination if Reconciliation Result is 'Match', 'Taxes Different', or 'Not in ERP'. If the Reconciliation Result is 'Not in Reporting' then the Company Name is displayed from ERP
Document Number
The Document Number from Determination if Reconciliation Result is 'Match', 'Taxes Different', or 'Not in ERP'. If the Reconciliation Result is 'Not in Reporting' then the Company Name is displayed from ERP
Document Date
The Document Date from Determination if Reconciliation Result is 'Match', 'Taxes Different', or 'Not in ERP'. If the Reconciliation Result is 'Not in Reporting' then the Company Name is displayed from ERP
Calling system
The Calling system from Determination if Reconciliation Result is 'Match', 'Taxes Different', or 'Not in ERP'. If the Reconciliation Result is 'Not in Reporting' then the Company Name is displayed from ERP
Host system
The Host system from Determination if Reconciliation Result is 'Match', 'Taxes Different', or 'Not in ERP'. If the Reconciliation Result is 'Not in Reporting' then the Company Name is displayed from ERP
Company Role
The Company Role from Determination if Reconciliation Result is 'Match', 'Taxes Different', or 'Not in ERP'. If the Reconciliation Result is 'Not in Reporting' then the Company Name is displayed from ERP
Tax Amount
Tax Amount from Determination
ERP Tax Amount
ERP Tax Amount from ERP
Gross Amount
Gross Amount from Determination
ERP Gross Amount
ERP Gross Amount from ERP
ERP Document Type
ERP Document Type from ERP
ERP Transaction ID
ERP Transaction ID from ERP
ERP Partner Number
ERP Partner Number from ERP
ERP Partner Name
ERP Partner Name from ERP
ERP Document Description
ERP Document Description from ERP
ERP Document Currency
ERP Document Currency from ERP
Document Currency
Document Currency from Determination
ERP Period
ERP Period from ERP
ERP Fiscal Date
ERP Fiscal Date from ERP
Fiscal Date
Document Fiscal Date from Determination
Fiscal Date Difference
Fiscal Date Difference calculated by Reports and Analytics
Reconciliation Result
Reconciliation Result calculated by Reports and Analytics
Tax Difference
Tax Difference calculated by Reports and Analytics
% Tax Difference
% Tax Difference calculated by Reports and Analytics
ERP User Defined Field 1 – 5
ERP User Defined Field 1 – 5 from ERP
ERP User Defined Field 6 – 20
ERP User Defined Field 6 – 20 from ERP
Custom Attributes 1-50
The User Attribute field enables companies to submit and return user-defined elements that are not directly supported in Determination. These elements can be used in conjunction with Trans Editors to enable tax calculations and may be stored in the Audit database for reporting purposes. Each User Attribute field contains a single name/value pair. Inclusive of Amount Attributes and Date Attributes.
Batch UUID
The unique identifier to check the status of data sent in a batch
External Company ID
The unique identifier used by your business application to indicate which company to use in Determination. This identifier also distinguishes between different calling applications that may be used by your company. This element may be passed at the batch level or with each document, and is passed through to the Determination response, and to the Audit database.
Data source information
Column Name
Reconciliation Result
Source of Data
Company Name
Match
Determination
Company Name
Taxes Different
Determination
Company Name
Not in ERP
Determination
Company Name
Not in Reporting
ERP Recon Data
Document Number
Match
Determination
Document Number
Taxes Different
Determination
Document Number
Not in ERP
Determination
Document Number
Not in Reporting
ERP Recon Data
Document Date
Match
Determination
Document Date
Taxes Different
Determination
Document Date
Not in ERP
Determination
Document Date
Not in Reporting
ERP Recon Data
Calling system
Match
Determination
Calling system
Taxes Different
Determination
Calling system
Not in ERP
Determination
Calling system
Not in Reporting
ERP Recon Data
Host system
Match
Determination
Host system
Taxes Different
Determination
Host system
Not in ERP
Determination
Host system
Not in Reporting
ERP Recon Data
Company Role
Match
Determination
Company Role
Taxes Different
Determination
Company Role
Not in ERP
Determination
Company Role
Not in Reporting
ERP Recon Data
Tax Amount
All 4 Reconciliation results
Determination
ERP Tax Amount
All 4 Reconciliation results
ERP Recon Data
Gross Amount
All 4 Reconciliation results
Determination
ERP Gross Amount
All 4 Reconciliation results
ERP Recon Data
ERP Document Type
All 4 Reconciliation results
ERP Recon Data
ERP Transaction ID
All 4 Reconciliation results
ERP Recon Data
ERP Partner Number
All 4 Reconciliation results
ERP Recon Data
ERP Partner Name
All 4 Reconciliation results
ERP Recon Data
ERP Document Description
All 4 Reconciliation results
ERP Recon Data
ERP Document Currency
All 4 Reconciliation results
ERP Recon Data
Document Currency
All 4 Reconciliation results
Determination
ERP Period
All 4 Reconciliation results
ERP Recon Data
ERP Fiscal Date
All 4 Reconciliation results
ERP Recon Data
Fiscal Date
All 4 Reconciliation results
Determination
Fiscal Date Difference
All 4 Reconciliation results
Reports and Analytics (Calculated)
Reconciliation Result
All 4 Reconciliation results
Reports and Analytics (Calculated)
Tax Difference
All 4 Reconciliation results
Reports and Analytics (Calculated)
% Tax Difference
All 4 Reconciliation results
Reports and Analytics (Calculated)
ERP User Defined Field 1 – 5
All 4 Reconciliation results
ERP Recon Data
For more information, refer to the Data Dictionary.