Query 1302 Sales Outstd. Amount On VAT
src/Layers/W1/BaseApp/Sales/Customer/SalesOutstdAmountOnVat.Query.al35 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Sales.Customer;using Microsoft.Sales.Document;/// <summary>/// Calculates outstanding sales amounts grouped by document type, customer, and VAT percentage./// </summary>query 1302 "Sales Outstd. Amount On VAT"{ QueryType = Normal; elements { dataitem(DataItemName; "Sales Line") { column(Document_Type; "Document Type") { } column(Bill_to_Customer_No_; "Bill-to Customer No.") { } column(VAT__; "VAT %") { } column(Sum_Outstanding_Amount__LCY_; "Outstanding Amount (LCY)") { Method = Sum; } } } trigger OnBeforeOpen() begin end;}