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

I have the same question (0)

All responses (11)

Answers (0)

Community Member 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;

}

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No
Austin360_ 10 on at

Like (0)

Report

RE: report extension for sum total quantity in sales invoice

need assistances please.

Was this reply helpful? Yes No
Austin360_ 10 on at

Like (0)

Report

RE: report extension for sum total quantity in sales invoice

Am having error

Was this reply helpful? Yes No
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]

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No
Austin360_ 10 on at

Like (0)

Report

RE: report extension for sum total quantity in sales invoice

Thanks . I will and revert.

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,369 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

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,664 Moderator 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.

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No