Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Unanswered

please guide me on how to retrieve the daily cash flow statement using api

Posted on by 2
I encountered with the Cash Flow Statement API. I expected the API to return values for each date within the specified range of 2024-01-01 to 2024-12-31. However, the response only provides values for the end date, 2024-12-31. For reference, I have been using the following API call:GET https://api.businesscentral.dynamics.com/v2.0/{settings.DYNAMICS_TENANT_ID}/{settings.DYNAMICS_ENVIORNMENT}/api/v2.0/companies({organization_id})/cashFlowStatements?$orderby=lineNumber&$filter=dateFilter ge 2024-01-01T00:00:00Z and dateFilter le 2024-12-31T23:59:59Z
{
    "1": {
        "@odata.etag": "W/\"JzIwOzEwMTI5MDMxMjU2NTA4Mjk2OTM1MTswMDsn\"",
        "id": "7a87816e-9123-ef11-840f-6045bdc8db8f",
        "lineNumber": 20000,
        "display": "Net Income",
        "netChange": 30182.36,
        "lineType": "detail",
        "indentation": 0,
        "dateFilter": "2024-12-31"
    },
    "2": {
        "@odata.etag": "W/\"JzIwOzE2MDg4MjQ0NTQ4MzY4MTc1NzIzMTswMDsn\"",
        "id": "7b87816e-9123-ef11-840f-6045bdc8db8f",
        "lineNumber": 30000,
        "display": "Adjustments to reconcile Net Income to net cash provided by operations:",
        "netChange": 0,
        "lineType": "detail",
        "indentation": 0,
        "dateFilter": "2024-12-31"
    }
}   ... Could you please guide me on how to retrieve the cash flow statement values for each date within the specified range using the api?

Thank you for your assistance.
 
  • gdrenteria Profile Picture
    gdrenteria 4,883 Super User on at
    please guide me on how to retrieve the daily cash flow statement using api
    Hi
    You could review this financial report from BC, and see if you experience the same thing.
    BR
    GR

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans