---
id: object/table/135
type: object
title: Table 135 "Acc. Sched. KPI Web Srv. Setup"
summary: Table 135 "Acc. Sched. KPI Web Srv. Setup" in Base Application (Microsoft.Finance.FinancialReports). 10 fields, 6 public procedures. Present since at least BC23, still in BC30, changed in BC24, BC26, BC29.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "29"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: da5aef36557a4d862c89193c9951a26ea58b793e2d57bca71b4b6d6accb856c1
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/FinancialReports/AccSchedKPIWebSrvSetup.Table.al
    title: src/Layers/W1/BaseApp/Finance/FinancialReports/AccSchedKPIWebSrvSetup.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/bi-column-definitions
    - https://learn.microsoft.com/dynamics365/business-central/bi-how-to-set-up-and-publish-kpi-web-services-based-on-account-schedules
    - https://learn.microsoft.com/dynamics365/business-central/bi-how-work-account-schedule
    - https://learn.microsoft.com/dynamics365/business-central/bi-row-definitions
    - https://learn.microsoft.com/dynamics365/business-central/bi-troubleshoot-financial-reports
    - https://learn.microsoft.com/dynamics365/business-central/finance-financial-reporting-faq
  objects: []
  features: []
  topics:
    - topic/business-central/analytics-business-intelligence-and-repo/built-in-reports/finance
    - topic/business-central/analytics-business-intelligence-and-repo/kpis-dashboards-and-financial-reports
    - topic/business-central/business-functionality/finance/financial-analytics/financial-reporting
    - topic/business-central/business-functionality/set-up-business-central/set-up-finance
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 135
name: Acc. Sched. KPI Web Srv. Setup
namespace: Microsoft.Finance.FinancialReports
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "26"
  - "29"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 10
  procedures: 10
  events: 0
  subscribers: 0
relations:
  out: 1
  referenced_by: 0
  pages: 1
  extended_by: 0
  event_subscribers: 1
  calls: 3
  called_by: 0
  implements: 0
---

# Table 135 "Acc. Sched. KPI Web Srv. Setup"

> Table 135 "Acc. Sched. KPI Web Srv. Setup" in Base Application (Microsoft.Finance.FinancialReports). 10 fields, 6 public procedures. Present since at least BC23, still in BC30, changed in BC24, BC26, BC29.

Base Application · Microsoft.Finance.FinancialReports · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/FinancialReports/AccSchedKPIWebSrvSetup.Table.al) · facts from BC29

Learn documents this table through its pages: [Page 195 "Acc. Sched. KPI Web Srv. Setup"](../page/195.md) (6 Learn pages).

## Properties

| Property | Value |
|---|---|
| Caption | Acc. Sched. KPI Web Srv. Setup |
| DataClassification | CustomerContent |

## Fields

Explanation: the field's ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Primary Key | Code[10] | — |  |
| 2 | Forecasted Values Start | Option | Specifies at what point in time forecasted values are shown on the financial-report KPI graphic. The forecasted values are retrieved from the selected general ledger budget. | OptionCaption: After Latest Closed Period,After Current Date |
| 3 | G/L Budget Name | Code[10] | Specifies the name of the general ledger budget that provides budgeted values to the financial-report KPI web service. | TableRelation [Table 95 "G/L Budget Name"](../table/95.md) (G/L Budget Name) |
| 4 | Period | Option | Specifies the period that the financial-report KPI web service is based on. | OptionCaption: Fiscal Year - Last Locked Period,Current Fiscal Year,Current Calendar Year,Current Calendar Quarter,Current Month,Today,Current Period,Last Locked Period,Current Fiscal Year + 3 Previous Years |
| 5 | View By | Option | Specifies which time interval the financial-report KPI is shown in. | OptionCaption: Day,Week,Month,Quarter,Year,Period |
| 6 | Web Service Name | Text[240] | Specifies the name of the financial-report KPI web service. This name will be shown under the displayed financial-report KPI. |  |
| 7 | Published | Boolean | Specifies if the financial-report KPI web service has been published. Published web services are listed in the Web Services window. | FlowField: exist("Web Service" where("Object Type" = const(Page), "Object ID" = const(197), Published = const(true))); not editable |
| 8 | Data Last Updated | DateTime | Specifies the last time data was refreshed through the web service. | not editable; DataClassification SystemMetadata |
| 9 | Last G/L Entry Included | Integer | — | not editable; DataClassification SystemMetadata |
| 10 | Data Time To Live (hours) | Integer | Specifies how long data is stored in Business Central before being refreshed from the service. The longer the duration is the smaller the performance impact. <small>via [Page 195 "Acc. Sched. KPI Web Srv. Setup"](../page/195.md)</small> |  |

## Keys

- Key1: Primary Key (clustered)

## Trigger event subscribers

- OnAfterModifyEvent: [Codeunit 198 "Acc. Sched. KPI Event Handler"](../codeunit/198.md) OnModifyAccSchedKpiSetup

## Procedures

- `GetPeriodLength(var NoOfLines: Integer; var StartDate: Date; var EndDate: Date)`: Calculates period length and date range based on the configured period type. Determines start date, end date, and number of time segments for KPI data collection.
- `CalcNextStartDate(OrgStartDate: Date; OffSet: Integer): Date`: Calculates the next start date based on the original start date and offset value. Handles different view-by periods including accounting periods, years, quarters, months, weeks, and days.
- `GetLastClosedAccDate(): Date`: Retrieves the last closed accounting date based on general ledger setup. Returns the date before the allow posting from date or work date if not set.
- `GetLastBudgetChangedDate(): Date`: Retrieves the last modification date from G/L budget entries for the configured budget. Returns the most recent change date or zero date if no budget entries exist.
- `PublishWebService()`
- `DeleteWebService()`

Plus 4 local procedures.

## Triggers

OnDelete, OnInsert, OnModify

## Relations

- G/L Budget Name: TableRelation [Table 95 "G/L Budget Name"](../table/95.md)

## Pages and codeunits on this table

- [Page 195 "Acc. Sched. KPI Web Srv. Setup"](../page/195.md) (source table)

## Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an `Object::"Name"` argument. Interface dispatch and calls through events are not counted, so the list is not complete.

- [Codeunit 457 "Environment Information"](../codeunit/457.md) (2 calls: `DeleteWebService → IsSaaS`, `PublishWebService → IsSaaS`)
- [Codeunit 9750 "Web Service Management"](../codeunit/9750.md) (2 calls: `PublishWebService → CreateTenantWebService`, `PublishWebService → CreateWebService`)
- [Codeunit 198 "Acc. Sched. KPI Event Handler"](../codeunit/198.md) (1 call: `DeleteWebService → ResetAccSchedKPIWevSrvSetup`)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC26, BC29

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "table", object_name: "Acc. Sched. KPI Web Srv. Setup")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.
