Page function SUM formula using calcsums

(0) Share

Report

Posted on by Samantha73

3,255

Hi Guys

I have created a page that displays each sales order line and want to display the on-hand quantity of the sales order line warehouse. So created a function but the SUM formula for quantity is not working - below try to lookup item Ledger Entry table and get on hand qty:

var

OnHandLineWH: Decimal;

begin

vItemLedger.Reset;

vItemLedger.SetRange("Item No.", Rec."No.");

vItemLedger.SetRange("Location Code",Rec."Location Code");

if vItemLedger.FindFirst() then

OnHandLineWH := vItemLedger.CalcSums(Quantity);

exit(OnHandLineWH);

end;

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

You have to do calcsums as a single line and then the field is set with the value so you can then assign it to a variable so like this:

vItemLedger.calcsums(quantity);

OnHandLineWH := vItemLedger.quantity;

Calcsums returns a Boolean value when used with a variable directly. Like above will get you the decimal

Was this reply helpful? Yes No