sum all amount in a range

Dynamics 365 Business Central/NAV Developers Forum
1

I created a report to get all sales amounts with and without VAT value:

Customer - OnAfterGetRecord()

CLEAR(VatEntry);

VatEntry.SETCURRENTKEY(Type,“Posting Date”,“Document Type”,“Document No.”,“Bill-to/Pay-to No.”);
VatEntry.SETRANGE(“Bill-to/Pay-to No.”,Customer.“No.”);

IF VatEntry.FIND(’-’) THEN BEGIN

IF VatEntry.Amount <> 0 THEN;

TotAmount := VatEntry.Amount + TotAmount;

END;

With this I have the range I need, but know, I don’t know how do SUM all amont in this range.

With FIND(’-’) and FIND(’+’) I only get the first and the last amount.

But I need all amounts on this range???

Thanks

2

Hi Luana,

try to change your code like this:
…

VATEntry.SETRANGE(“bill-to/Pay-to No.”,Customer.“no.”);

IF VatEntry.FIND(’-’) THEN repeat

TotAmount := VatEntry.Amount + TotAmount;

until VatEntry.next = 0;

Regards Jan

3

they try FINDSET .

4

Thanks Jan

your solution help a lot.

Regards