Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.
Versions
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store
Close

Create a financial data source

Create a financial data source

Database columns referring to raw expense details must be identified to create a new data source in Financial Management.

Before you begin

Role required: budget_admin, cost_transparency_admin

About this task

Data sources are available for both cost transparency and financial planning modules.

Procedure

  1. Navigate to Data Sources from Cost Transparency or Financial Planning.
  2. Click New.
  3. Fill out the fields on the form (see table).
  4. Click Submit.
    Field descriptions to create a new data source record in Financial Management.
    Field Description
    Name Enter a descriptive name for the new data source record.
    Table Select a database table with actual raw expense data.
    GL Account Select the database column that refers to general ledger account expenses.
    Currency Select the database column that refers to currency values for the expenses.
    Amount Select the database column that refers to actual expense amount.
    Posting date Select the database column that refers to the date when the expense was incurred.
    Condition Apply conditions to filter records.

What to do next

Create field maps for the data source.

This site is scheduled for a small content update on Tuesday, December 18th, between the hours of 4:00pm and 8:00pm Pacific Time (Dec 19 00:00 – Dec 19 4:00 UTC). Access to this site may be slightly delayed during that time.