Dynamics Community Forum Thread Details

When executing a call to the business central api (whether it being custom endpoints or business central native ones), there is a difference in output based on using SCHEMAVERSION2.1

both calls are exactly the same (in the normal use case the itemNo had an IN() statement, but for testing purposes we backtracked this to just on EQ statement.
We see that the call with the 2.1 just ignored the date filtering, when the second call (without schemaversion) does not

apicall/itemTaxes?$schemaversion=2.1&$filter=transactionType eq 'Sales' and (startDate eq null or startDate le 2026-04-16) and (endDate eq null or endDate eq 0001-01-01 or endDate ge 2026-04-16) and itemNo eq 'SAMA256-128GB-YLW' and postingGroup eq 'DOMESTIC'

{
    "@odata.context": "apicall/itemTaxes",
    "value": [
        {
            "itemNo": "SAMA256-128GB-YLW",
            "quantity": 1,
            "taxContributionGroup": "AUVIBELGSM1",
            "taxPostingGroup": "AUVIBEL",
            "percentage": 0,
            "unitPriceExclVAT": 4,
            "startDate": "2022-04-01",
            "endDate": "2026-02-28",
            "postingGroup": "DOMESTIC",
            "transactionType": "Sales",
            "postingGroupType": "VAT_x0020_Bus_x002E__x0020_Posting_x0020_Group",
            "auxiliaryIndex1": "AUVIBEL",
            "auxiliaryIndex2": "AUVIBELGSM1"
        },
        {
            "itemNo": "SAMA256-128GB-YLW",
            "quantity": 1,
            "taxContributionGroup": "AUVIBELGSM1",
            "taxPostingGroup": "AUVIBEL",
            "percentage": 0,
            "unitPriceExclVAT": 4.3,
            "startDate": "2026-03-01",
            "endDate": "2099-12-31",
            "postingGroup": "DOMESTIC",
            "transactionType": "Sales",
            "postingGroupType": "VAT_x0020_Bus_x002E__x0020_Posting_x0020_Group",
            "auxiliaryIndex1": "AUVIBEL",
            "auxiliaryIndex2": "AUVIBELGSM1"
        },
        {
            "itemNo": "SAMA256-128GB-YLW",
            "quantity": 1,
            "taxContributionGroup": "BEBAT1",
            "taxPostingGroup": "BEBAT",
            "percentage": 0,
            "unitPriceExclVAT": 0.18,
            "startDate": "2026-01-01",
            "endDate": "2099-12-31",
            "postingGroup": "DOMESTIC",
            "transactionType": "Sales",
            "postingGroupType": "VAT_x0020_Bus_x002E__x0020_Posting_x0020_Group",
            "auxiliaryIndex1": "BEBAT",
            "auxiliaryIndex2": "BEBAT1"
        },
        {
            "itemNo": "SAMA256-128GB-YLW",
            "quantity": 1,
            "taxContributionGroup": "RECUPEL6.1",
            "taxPostingGroup": "RECUPEL",
            "percentage": 0,
            "unitPriceExclVAT": 0.124,
            "startDate": "2022-01-01",
            "endDate": "2099-12-31",
            "postingGroup": "DOMESTIC",
            "transactionType": "Sales",
            "postingGroupType": "VAT_x0020_Bus_x002E__x0020_Posting_x0020_Group",
            "auxiliaryIndex1": "RECUPEL",
            "auxiliaryIndex2": "RECUPEL6.1"
        }
    ]
}

apicall/itemTaxes?$filter=transactionType eq 'Sales' and (startDate eq null or startDate le 2026-04-16) and (endDate eq null or endDate eq 0001-01-01 or endDate ge 2026-04-16) and itemNo eq 'SAMA256-128GB-YLW' and postingGroup eq 'DOMESTIC'

{
    "@odata.context": "apicall/itemTaxes",
    "value": [
        {
            "itemNo": "SAMA256-128GB-YLW",
            "quantity": 1,
            "taxContributionGroup": "AUVIBELGSM1",
            "taxPostingGroup": "AUVIBEL",
            "percentage": 0,
            "unitPriceExclVAT": 4.3,
            "startDate": "2026-03-01",
            "endDate": "2099-12-31",
            "postingGroup": "DOMESTIC",
            "transactionType": "Sales",
            "postingGroupType": "VAT_x0020_Bus_x002E__x0020_Posting_x0020_Group",
            "auxiliaryIndex1": "AUVIBEL",
            "auxiliaryIndex2": "AUVIBELGSM1"
        },
        {
            "itemNo": "SAMA256-128GB-YLW",
            "quantity": 1,
            "taxContributionGroup": "BEBAT1",
            "taxPostingGroup": "BEBAT",
            "percentage": 0,
            "unitPriceExclVAT": 0.18,
            "startDate": "2026-01-01",
            "endDate": "2099-12-31",
            "postingGroup": "DOMESTIC",
            "transactionType": "Sales",
            "postingGroupType": "VAT_x0020_Bus_x002E__x0020_Posting_x0020_Group",
            "auxiliaryIndex1": "BEBAT",
            "auxiliaryIndex2": "BEBAT1"
        },
        {
            "itemNo": "SAMA256-128GB-YLW",
            "quantity": 1,
            "taxContributionGroup": "RECUPEL6.1",
            "taxPostingGroup": "RECUPEL",
            "percentage": 0,
            "unitPriceExclVAT": 0.124,
            "startDate": "2022-01-01",
            "endDate": "2099-12-31",
            "postingGroup": "DOMESTIC",
            "transactionType": "Sales",
            "postingGroupType": "VAT_x0020_Bus_x002E__x0020_Posting_x0020_Group",
            "auxiliaryIndex1": "RECUPEL",
            "auxiliaryIndex2": "RECUPEL6.1"
        }
    ]
}

Categories:

Dynamics 365 Business Central

Community site session details

Schemaversion 2.1 breaks filtering based on dates

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the March Top 10 Community Leaders

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

Featured topics

Product updates