Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: SAP Concur: Support for the additional columns for the rejected expenses in Concur connector

Answered
Astuti Saxena User

The customer needs support for the below mentioned columns for the rejected expenses in the Concur connector.

The ERD is missing fields in the API that they have in their instance of the Concur connector. The fields are for the rejected expenses object and the field names are:

Employee ID 
Employee Org Unit 1 - Code    
Report Name 
Approval Status   
Sent for Payment Date   
First Submitted Date    
Sent Back Date/Time     
Report ID   
Commenter's Name  
Comment     
Comment Date/Time 
Sent Back Reason Code   
Sent Back Reason Text

In the Expense module, the customer wants to pull the information on the exception, if the expense report has one. Specifically, the fields listed above.
Thank you.

Please sign in to leave a comment.

Comments

5 comments

Date Votes
  • Official comment
    Frank Fivetranner

    Hi Mark, 

    We use this endpoint to sync information about reports. This should help clarify that if there are certain fields that are missing we don't receive it from the Concur API. Let me know if you find documentation on the specific fields that you would like to include. 

    Frank

  • Mark Ruprecht User
    Field Concur Location Comment
    Employee ID  [Expense].[Report Header Information]  
    Employee Org Unit 1 - Code     [Expense].[Report Header Information]  
    Report Name  [Expense].[Report Header Information]  
    Approval Status    [Expense].[Report Header Information]  
    Sent for Payment Date    [Expense].[Report Dates and Statuses]  
    First Submitted Date     [Expense].[Report Dates and Statuses]  
    Sent Back Date/Time      [Expense].[Expense Report Workflow Trail] "Step Action Date/Time" is actual field
    Report ID    [Expense].[Report Header Information]  
    Commenter's Name   [Expense].[Report Header Comments]  
    Comment      [Expense].[Report Header Comments]  
    Comment Date/Time  [Expense].[Report Header Comments]  
    Sent Back Reason Code    [Expense].[Report Header Information]  
    Sent Back Reason Text [Expense].[Report Header Information]  
  • Mark Ruprecht User

    The ERD does not show the requested fields which are a part of the Expense object.

  • Mark Ruprecht User

    Hi Frank,

    Does Fivetran plan on supporting the Exceptions endpoint for SAP Concur?

  • Frank Fivetranner

    Thanks for submitting this information. At this time exception information is blocked by our support for the v4 endpoints for expense. Fivetran cannot implement this endpoint at this time as SAP does not provide a way to sync this data incrementally which is important to the performance of this connector. We will add this functionality if the capabilities change in the future. 

    Thanks, 

    Frank