report extension for sum total quantity in sales invoice

(0) Share

Report

Posted on by Austin360_

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.

Categories:

Dynamics 365 Business Central

All responses (11)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: report extension for sum total quantity in sales invoice

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;

}
Austin360_ 10 on at

Like (0)

Report

RE: report extension for sum total quantity in sales invoice

Please I need help in summing total Quantity using report extension
Austin360_ 10 on at

Like (0)

Report

RE: report extension for sum total quantity in sales invoice

need assistances please.
Austin360_ 10 on at

Like (0)

Report

RE: report extension for sum total quantity in sales invoice

Am having error
Austin360_ 10 on at

Like (0)

Report

RE: report extension for sum total quantity in sales invoice

[quote user="Austin360_"]
Nice video ,

But I still dont have an idea how to sum all Quantity
[/quote]
Austin360_ 10 on at

Like (0)

Report

RE: report extension for sum total quantity in sales invoice

Nice video ,

But I still dont have an idea how to sum all Quantity
Austin360_ 10 on at

Like (0)

Report

RE: report extension for sum total quantity in sales invoice

Thanks . I will and revert.
Suggested answer

DAnny3211 9,272 Super User 2024 Season 1 on at

Like (0)

Report

RE: report extension for sum total quantity in sales invoice

hi

create a variable on the header where you sum the amounts so that you can retrieve it from the word

look this

www.youtube.com/watch

learn.microsoft.com/.../ui-how-add-fields-word-report-layout

learn.microsoft.com/.../devenv-howto-report-layout

DANiele
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: report extension for sum total quantity in sales invoice

In that case you have to write your custom code in Report extension to calculate the values and then show it in Report.

Thanks.
Austin360_ 10 on at

Like (0)

Report

RE: report extension for sum total quantity in sales invoice

Thanks for your quick response.

The report is on word.