Query 141 "EU VAT Entries" with columns for Posting Groups

[JesperAtGitHub]

Describe the request

Please also add these columns/fields in query 141 "EU VAT Entries":

    column(EU_Service; "EU Service")
    {
    }
    // ->
    column(GenBusPostingGroup; "Gen. Bus. Posting Group")
    {
    }
    column(GenProdPostingGroup; "Gen. Prod. Posting Group")
    {
    }
    column(VATBusPostingGroup; "VAT Bus. Posting Group")
    {
    }
    column(VATProdPostingGroup; "VAT Prod. Posting Group")
    {
    }
    // <-
    column(Entry_No; "Entry No.")
    {
    }

Additional context

We need to be able to narrow down the VAT Entries included in a given VAT Report by filtering on the Posting Groups.

In Codeunit 140 "EC Sales List Suggest Lines" the event publisher:

OnPopulateVatEntryLinesOnAfterEUVATEntriesSetFilters(var VATReportHeader: Record "VAT Report Header"; var EUVATEntries: Query "EU VAT Entries")

is triggered right before the query is opened, allowing one to set additional filters on columns defined in the query.

Adding the Posting Groups to the query definition enables the use of filters on those columns also.

It will also improve the extendability when subscribing to the event publisher:

OnBeforeAddOrUpdateECLLine(EUVATEntries: Query "EU VAT Entries"; var ECSLVATReportLine: Record "ECSL VAT Report Line"; var IsHandled: Boolean)
Internal work item: AB#542094

[JesperAtGitHub]

Hi Nikola Kukrika (@nikolakukrika) - what is the status on this request?

This request is actually a repetition of a part of an earlier request (#26183 -> AB#522690) that has now been implemented in BC - but only partly. Without this missing part the main purpose of the request (being able to set filters on the postinggroups) can not been achived.

P.s. For some reason, when posting this comment, I can only choose "Close as completed" or "Close as not planned" - but clearly it is not my intent to close the request.

[JesperAtGitHub]

Hi again,

Would someone at MS please respond to this request/issue? (I have not heard anything since July)

The request is actually quite simple, in short:
Adding the posting group columns to query 141 is essential/required* to enable setting filters on those fields.

*) As queries, understandably, do not have a method like SetTabelView(VATEntry) and the method SetFilter only takes column names (as oppose to table field names) as reference for the "field" to filter on. (the methods signature is: procedure SetFilter(Column: Joker, String: Text, [Value: Joker ,...]))

Looking forward to hearing from you!

[AndersLarsenMicrosoft]

looks like a dead request