# Report TotAmout incorrect

**URL:** <https://www.dynamicsuser.net/t/report-totamout-incorrect/45072>\
**Category:** Developers Forum\
**Created:** [April 3, 2013, 12:10pm UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072 "2013-04-03T12:10:48Z")\
**Posts on this page:** 17\
**Page:** 1

<div class="post-metadata">

**Author:** ![illo29081970](https://avatars.discourse-cdn.com/v4/letter/i/7ea924/32.png) [@illo29081970](https://www.dynamicsuser.net/u/illo29081970)\
**Post date:** [April 3, 2013, 12:10pm UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/1 "2013-04-03T12:10:48Z")

</div>

I make a little change on Report 202. Update a filter By Location Code and make a TotAmount Report By Location Code.

The report lines data is OK, and all lines amount are correct. But for some reason the TotAmount does not include the last report record. Why is that hapening?

MY Code

On DataItem RoundLoop add this code:

RoundLoop - OnAfterGetRecord()

// newcod (sn)

CLEAR(Localizacao);

IF SalesLine.“Location Code” \<\> ‘’ THEN BEGIN  
Localizacao.INIT;

Localizacao.SETFILTER(Localizacao.Code,“Sales Line”.“Location Code”);  
IF Localizacao.FINDSET THEN BEGIN  
IF (SalesLine.“Location Code” = CodLoc) AND (SalesLine.“Location Code” \<\> ‘’) THEN BEGIN

REPEAT  
NameE := Localizacao.Name;

TotAmount += SalesLine.Amount;

UNTIL SalesLine.NEXT=0;

END;

END;  
END;

// newcod (en)

IF Number = 1 THEN  
TempSalesLine.FIND(’-’)  
ELSE  
TempSalesLine.NEXT;  
“Sales Line” := TempSalesLine;

…

---

<div class="post-metadata">

**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\
**Post date:** [April 3, 2013, 12:31pm UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/2 "2013-04-03T12:31:49Z")

</div>

Not sure of complete logic but I found

UNTIL SalesLine.NEXT=0; should be UNTIL Localizacao.NEXT=0;

---

<div class="post-metadata">

**Author:** ![illo29081970](https://avatars.discourse-cdn.com/v4/letter/i/7ea924/32.png) [@illo29081970](https://www.dynamicsuser.net/u/illo29081970)\
**Post date:** [April 3, 2013, 1:45pm UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/3 "2013-04-03T13:45:01Z")

</div>

Thanks Mohana, but the last LineAmount value is not included on the Report TotalAmount.

I can not even read the last record, that’s the problem. He is printed but not calculated. Why?

---

<div class="post-metadata">

**Author:** ![illo29081970](https://avatars.discourse-cdn.com/v4/letter/i/7ea924/32.png) [@illo29081970](https://www.dynamicsuser.net/u/illo29081970)\
**Post date:** [April 4, 2013, 10:12am UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/4 "2013-04-04T10:12:07Z")

</div>

I can nor read the last record on a report.

With this function

UNTIL SalesLine.NEXT=0; the problem is not solved

---

<div class="post-metadata">

**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\
**Post date:** [April 4, 2013, 10:21am UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/5 "2013-04-04T10:21:58Z")

</div>

You need to use UNTIL Localizacao.NEXT=0; and not

UNTIL SalesLine.NEXT=0;

---

<div class="post-metadata">

**Author:** ![illo29081970](https://avatars.discourse-cdn.com/v4/letter/i/7ea924/32.png) [@illo29081970](https://www.dynamicsuser.net/u/illo29081970)\
**Post date:** [April 4, 2013, 10:26am UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/6 "2013-04-04T10:26:46Z")

</div>

Mohana

I tryed with UNTIL Localizacao.NEXT=0 but the resulkt is the same

---

<div class="post-metadata">

**Author:** ![manisharma31](https://avatars.discourse-cdn.com/v4/letter/m/ed655f/32.png) [@manisharma31](https://www.dynamicsuser.net/u/manisharma31)\
**Post date:** [April 4, 2013, 10:29am UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/7 "2013-04-04T10:29:09Z")

</div>

Did you tried UNTIL Localizacao.NEXT=0; as suggested by Mohana.

---

<div class="post-metadata">

**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\
**Post date:** [April 4, 2013, 10:32am UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/8 "2013-04-04T10:32:17Z")

</div>

Write your code after standard code please…not before the standard code…

---

<div class="post-metadata">

**Author:** ![illo29081970](https://avatars.discourse-cdn.com/v4/letter/i/7ea924/32.png) [@illo29081970](https://www.dynamicsuser.net/u/illo29081970)\
**Post date:** [April 4, 2013, 10:49am UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/9 "2013-04-04T10:49:43Z")

</div>

Yes I tried, but the problem is not solved.

---

<div class="post-metadata">

**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\
**Post date:** [April 4, 2013, 10:57am UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/10 "2013-04-04T10:57:11Z")

</div>

Can you show your whole code again and also lines in Sales Document.

---

<div class="post-metadata">

**Author:** ![manisharma31](https://avatars.discourse-cdn.com/v4/letter/m/ed655f/32.png) [@manisharma31](https://www.dynamicsuser.net/u/manisharma31)\
**Post date:** [April 4, 2013, 11:05am UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/11 "2013-04-04T11:05:29Z")

</div>

TotAmount += “Sales Line”.Amount;

try this.

---

<div class="post-metadata">

**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\
**Post date:** [April 4, 2013, 11:12am UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/12 "2013-04-04T11:12:17Z")

</div>

Use “Sales Line” in all places instead od SalesLine

---

<div class="post-metadata">

**Author:** ![illo29081970](https://avatars.discourse-cdn.com/v4/letter/i/7ea924/32.png) [@illo29081970](https://www.dynamicsuser.net/u/illo29081970)\
**Post date:** [April 4, 2013, 11:14am UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/13 "2013-04-04T11:14:13Z")

</div>

Here is my Report Code and a sales order line image.

I pretend to group my report My location Code. Ant the total amount must total all lines orinted on my report Location code selection.

Thansk  
[Sales\_Line.rar](https://www.dynamicsuser.net/uploads/short-url/ou4M1uwZBc4WaBQCmAkm56Gem69.rar) (64.1 KB)

---

<div class="post-metadata">

**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\
**Post date:** [April 4, 2013, 11:17am UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/14 "2013-04-04T11:17:30Z")

</div>

What value do you have in CodLoc variable?

You need to Sort Sales Line on Location Code first…

---

<div class="post-metadata">

**Author:** ![manisharma31](https://avatars.discourse-cdn.com/v4/letter/m/ed655f/32.png) [@manisharma31](https://www.dynamicsuser.net/u/manisharma31)\
**Post date:** [April 4, 2013, 11:17am UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/15 "2013-04-04T11:17:56Z")

</div>

Where’s the code ?

---

<div class="post-metadata">

**Author:** ![illo29081970](https://avatars.discourse-cdn.com/v4/letter/i/7ea924/32.png) [@illo29081970](https://www.dynamicsuser.net/u/illo29081970)\
**Post date:** [April 4, 2013, 11:23am UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/16 "2013-04-04T11:23:47Z")

</div>

Thanks to all, with change SalesLine to “Sales Line” and put all my code after standard code the problem was solved.~

Thanks a lot

---

<div class="post-metadata">

**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\
**Post date:** [April 4, 2013, 11:26am UTC](https://www.dynamicsuser.net/t/report-totamout-incorrect/45072/17 "2013-04-04T11:26:23Z")

</div>

Welcome [:)]