Small and medium business | Business Central, N...

Reporting: How to get grand total of a multiplication

(0) Share

Report

Posted on by Mr. W

Hi everyone,

I'm still struggling with C SIDE language.

I need to calculate the total stock value of the item table and already got the total stock for each product from the item ledger entry.

Now I need the grand total of all products, how I can sum all totals from each product to get the grand total?

This is my code.

//>> calculate total stock quantity per item no.
CLEAR(TotalStockQty);
ItemLedgerEntry.SETFILTER("Item No.",Item."No.");
ItemLedgerEntry.CALCSUMS(Quantity);
TotalStockQty:= ItemLedgerEntry.Quantity;
// << calculate total stock quantity per item no.

// now sum (TotalStockQty * ItemUnitCost."Unit Cost")

CLEAR(i);
CLEAR(TotalStockValue);
ItemUnitCost.SETRANGE("No.",Item."No.");
IF ItemUnitCost.FINDSET THEN BEGIN
REPEAT
TotalStockValue += (TotalStockQty * ItemUnitCost."Unit Cost");
UNTIL ItemUnitCost.NEXT =0;
END

Thanks for any advice.

All responses (2)

Answers (0)

Mr. W 5 on at

Like (0)

Report

RE: Reporting: How to get grand total of a multiplication

Thanks, I tried this code, it works for grand total but then the current value for each product will be showed as 0 in my report.

I guess it has something to do with the following reset statement "ItemLedgerEntry.Reset".
Suggested answer

YUN ZHU 81,534 Super User 2025 Season 1 on at

Like (0)

Report
RE: Reporting: How to get grand total of a multiplication

Hi, try this?

begin CLEAR(TotalStockValue); Item.Reset(); if Item.FindSet() then repeat //>> calculate total stock quantity per item no. CLEAR(TotalStockQty); ItemLedgerEntry.Reset(); ItemLedgerEntry.SETFILTER("Item No.", Item."No."); ItemLedgerEntry.CALCSUMS(Quantity); TotalStockQty := ItemLedgerEntry.Quantity; // << calculate total stock quantity per item no. // now sum (TotalStockQty * ItemUnitCost."Unit Cost") TotalStockValue = (TotalStockQty * Item."Unit Cost"); until Item.Next() = 0; end;

Hope this will help.

Thank.

ZHU