Forum Discussion

tschen01's avatar
tschen01
New Member
6 years ago

Account Schedule Line Table

Hi,

I am trying to query using postman for the Account Schedule Line Table. Looking specifically for the totaling and Dimension 2 Totaling columns.


If I try this:

https://api.businesscentral.dynamics.com/v2.0/{tenantID}/Production/ODataV4/{CompanyID}/powerbifinance

I am able to get something like this

 

 

"value": [
        {
            "@odata.etag": "W/\"JzQ0O2RaeGZDSmZ6aVNkZmFqcFNRMjNXNUU2dnFpMURwZWpMek13UHlidWloMmM9MTswMDsn\"",
            "No": 1,
            "Date": "2019-01-01",
            "Closed_Period": true,
            "Account_Schedule_Name": "_INC_ALL",
            "KPI_Code": "code",
            "KPI_Name": "NET INCOME (LOSS)",
            "Net_Change_Actual": 0,
            "Balance_at_Date_Actual": 0,
            "Net_Change_Budget": 0,
            "Balance_at_Date_Budget": 0,
            "Net_Change_Actual_Last_Year": 0,
            "Balance_at_Date_Actual_Last_Year": 0,
            "Net_Change_Budget_Last_Year": 0,
            "Balance_at_Date_Budget_Last_Year": 0,
            "Net_Change_Forecast": 0,
            "Balance_at_Date_Forecast": 0
        },

 

 

 

 

But When I export the Config File and get the Acc. Schedule Line table it has more columns then the powerbifinance query.

Account Schedule Lines Columns

I have also tried using the webservice endpoint to look for endpoints that could get me this table(I have tried Account_Schedules and Acc_Schedule_Overview) which both have relvant information but not the columns im looking for.

 

 

How should I approach this? Or is it even possible to get that information?

Thanks!

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    tschen01 

    Did you figure it out ? This URL shows me an error.

     

    Regards
    Paul