Hello Professional.
I use business central 18.0 version.
am currently have some challenges summing up quantity numbers on by invoice.
I intend doing this via report extension .
Kindly need an assistance.
Best regards.
Hello Professional.
I use business central 18.0 version.
am currently have some challenges summing up quantity numbers on by invoice.
I intend doing this via report extension .
Kindly need an assistance.
Best regards.
it will be something like this,
reportextension 50000 "MyExtension" extends "Standard Sales - Invoice"
{
dataset
{
modify(Line)
{
trigger OnAfterAfterGetRecord()
var
myInt: Integer;
begin
CalcFields(Amount);
quantity += Amount
end;
}
add(Header)
{
column(quantity; quantity) { }
}
}
var
quantity: Decimal;
}
Please I need help in summing total Quantity using report extension
need assistances please.
Am having error
Nice video ,
But I still dont have an idea how to sum all Quantity
[/quote]Nice video ,
But I still dont have an idea how to sum all Quantity
Thanks . I will and revert.
hi
create a variable on the header where you sum the amounts so that you can retrieve it from the word
look this
learn.microsoft.com/.../ui-how-add-fields-word-report-layout
learn.microsoft.com/.../devenv-howto-report-layout
DANiele
In that case you have to write your custom code in Report extension to calculate the values and then show it in Report.
Thanks.
Thanks for your quick response.
The report is on word.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,564 Super User 2024 Season 2
Martin Dráb 228,651 Most Valuable Professional
nmaenpaa 101,148