# calculate Sales Line Amount including Sales Tax,Discounts and misc. charges. through code

**URL:** <https://www.dynamicsuser.net/t/calculate-sales-line-amount-including-sales-tax-discounts-and-misc-charges-through-code/23648>\
**Category:** Developer Forum\
**Created:** [November 26, 2009, 7:32am UTC](https://www.dynamicsuser.net/t/calculate-sales-line-amount-including-sales-tax-discounts-and-misc-charges-through-code/23648 "2009-11-26T07:32:19Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![giridharraj](https://avatars.discourse-cdn.com/v4/letter/g/5f8ce5/32.png) [@giridharraj](https://www.dynamicsuser.net/u/giridharraj)\
**Post date:** [November 26, 2009, 7:32am UTC](https://www.dynamicsuser.net/t/calculate-sales-line-amount-including-sales-tax-discounts-and-misc-charges-through-code/23648/1 "2009-11-26T07:32:19Z")

</div>

Hi, can anyone tell me how to get Sales Line Amount including Sales Tax,Discounts and misc. charges. through code. I have tried for sales order and i got the total invoice amount which includes sales tax etc., using salestotals class. But I couldn’t get for a sales line. Please give me a code snippet or an idea. Please reply immediately. Its urgent. Thanks and Regards, Giridhar Raj.

---

<div class="post-metadata">

**Author:** ![vijay\_g](https://avatars.discourse-cdn.com/v4/letter/v/54ee81/32.png) [@vijay\_g](https://www.dynamicsuser.net/u/vijay_g)\
**Post date:** [November 26, 2009, 8:01am UTC](https://www.dynamicsuser.net/t/calculate-sales-line-amount-including-sales-tax-discounts-and-misc-charges-through-code/23648/2 "2009-11-26T08:01:36Z")

</div>

hi,

just take a recvar of table sales line and has to filter it by document no(order no.) and afterward calculate all lines amt total which is( tax amt, charge amt,excise amt etc )

---

<div class="post-metadata">

**Author:** ![giridharraj](https://avatars.discourse-cdn.com/v4/letter/g/5f8ce5/32.png) [@giridharraj](https://www.dynamicsuser.net/u/giridharraj)\
**Post date:** [November 26, 2009, 8:41am UTC](https://www.dynamicsuser.net/t/calculate-sales-line-amount-including-sales-tax-discounts-and-misc-charges-through-code/23648/3 "2009-11-26T08:41:49Z")

</div>

Vijay, it gives us only line amount excluding sales tax. i need sales line amount including tax but not whole sales order amount including tax

---

<div class="post-metadata">

**Author:** ![vijay\_g](https://avatars.discourse-cdn.com/v4/letter/v/54ee81/32.png) [@vijay\_g](https://www.dynamicsuser.net/u/vijay_g)\
**Post date:** [November 26, 2009, 8:46am UTC](https://www.dynamicsuser.net/t/calculate-sales-line-amount-including-sales-tax-discounts-and-misc-charges-through-code/23648/4 "2009-11-26T08:46:03Z")

</div>

hi raj,

well you can total every field for amt so you after that you can add tax amt to line amt.

---

<div class="post-metadata">

**Author:** ![giridharraj](https://avatars.discourse-cdn.com/v4/letter/g/5f8ce5/32.png) [@giridharraj](https://www.dynamicsuser.net/u/giridharraj)\
**Post date:** [November 26, 2009, 9:28am UTC](https://www.dynamicsuser.net/t/calculate-sales-line-amount-including-sales-tax-discounts-and-misc-charges-through-code/23648/5 "2009-11-26T09:28:15Z")

</div>

I couldn\t get the tax amount for each sales line. I need that. Can you please tell where can i get the sales tax for each sales line.

---

<div class="post-metadata">

**Author:** ![vijay\_g](https://avatars.discourse-cdn.com/v4/letter/v/54ee81/32.png) [@vijay\_g](https://www.dynamicsuser.net/u/vijay_g)\
**Post date:** [November 26, 2009, 10:25am UTC](https://www.dynamicsuser.net/t/calculate-sales-line-amount-including-sales-tax-discounts-and-misc-charges-through-code/23648/6 "2009-11-26T10:25:35Z")

</div>

the tax amt field shows amt of tax to item wise( line wise)