web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Identify Close Income ...
Small and medium business | Business Central, N...
Answered

Identify Close Income Statement Postings in OData Response

(1) ShareShare
ReportReport
Posted on by StAbNVX 15
Hello
 
we are using OData to extract information from Webservices created in Business Central such as glEntry. Now there is a specific requirement to identify records that have a posting date prefixed with the letter /C/ on the GUI indicating an income statement closing (German prefix /U/ for Ultimobuchung/GuV Nullstellung).
 
Previously in Navision when the postingDate still had a timestamp such records were identified by having a timestamp equal to /23:23:59/ but using OData calls the response exposed for the postingDate does not have a timestamp and is only a regular date without any prefix- no other fields in the response to the OData call indicate the fictitious date between the last day of the old fiscal year and the first day of the new year.
 
Please provide feedback on how to identify close income statement posting (shown with a letter prefix to the posting date on the GUI) in the OData response where only the date component for the posting date is returned.
 
Best regards
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,703 Super User 2025 Season 2 on at
    Identify Close Income Statement Postings in OData Response
    You can filter such entries by field Source Code: CLSINCOME. You can check if You have the same in "Source Code Setup" for Close Income Statement.
      Additionally add filter for Posting Date for 31st of December for the needed year.
  • StAbNVX Profile Picture
    StAbNVX 15 on at
    Identify Close Income Statement Postings in OData Response
    Thank you for your reply KasparsSemjonovs
     
     
    Unfortunately the filter by field Source Code: CLSINCOME only returns postings which have been created by the function however it would not include manual postings which are also relevant to evaluate. 
     
  • Suggested answer
    StAbNVX Profile Picture
    StAbNVX 15 on at
    Identify Close Income Statement Postings in OData Response
    Again, thank you KasparsSemjonovs for the hint that lead me to another post with the solution I was looking for https://www.dynamicsuser.net/t/closing-dates-and-odata-how-to-query-and-use-in-external-clients/76072
     
    Tl;dr: 
    to get all close income statement, which are postings on that fictitious date between the last day of the old fiscal year and the first day of the new year, append the following filter to the OData Request
     
    ?$filter=postingDate gt 2022-12-31 and postingDate lt 2023-01-01

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,267

#2
Sumit Singh Profile Picture

Sumit Singh 2,098

#3
YUN ZHU Profile Picture

YUN ZHU 1,766 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans