ERP document reconciliation

ERP connection setup steps

Initial Request: Send an email to DB Ops for Product enablement in IDT (API Admin Tab).
ERP Provisioning: DB OPS will provision the ERP (SAP, Oracle, and MS.) for the respective user/client.
Credential Creation: Customer or Tenant administrator will create a Machine user with Client ID (Username) and Client Secret (Password).
Establish Connection: Use the provided credentials to establish the connection from ERP with the selected endpoint or host.
UAT Environment
Token endpoint: https://api-uat.onesourcetax.com/oauth2/v1/token
Document endpoint: https://api-uat.onesourcetax.com/indirect-recon-report/document/eap/documents
PROD Environment
Token endpoint: https://api.onesourcetax.com/oauth2/v1/token
Document endpoint: https://api.onesourcetax.com/indirect-recon-report/document/eap/documents

ERP recon batch status report

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 the 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

'Not in Reporting'
'Not in ERP'
'Taxes Different'
'Match'

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

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 are available in Edit Mode/Ad-hocView.
note
These fields can be found under 'Measures', which is only available in Edit mode. These fields are not included in the standard template. Users who want to use them need to customize their reports in Edit mode and add the fields as columns or filters.
Custom Attributes 1-50
ERP User Defined Fields 1-20
External Company ID