Total Before Discount

[Former Member]

Hi

In A/R Invoice I have 5 Items with differen Discount.

I need to know in Which Table and Field *Total Before Discount * is Stored

Regards

Srinivas

[Former Member · Accepted solution]

Adding 6% to all total before discounts sounds like a tax. Why not do you create a tax code and the solution will be easy.

Thanks,

Gordon

[mk3]

Hii,

It depends on which total before discount you mean. If you mean the total before the discount that is applied to the whole document then the field is [TotalSumSy] in INV1 table. But If by the total before discount you mean the price before discount is applied to each line item, then this a calculated field as pointed out by the seniors.

You may wish to check out the below thread.

https://answers.sap.com/questions/8515864/query-that-show-total-discount-on-ar-invoice.html?childToV...

Regards

[Former Member]

Suda is correct. Total before discount is not stored anywhere in OINV but calculated through SUM(Linetotal) from INV1. If it is in FC, exchange rate will take document date rate as the base to calculate LC total.

Thanks,

Gordon

[Former Member]

Hi Sura,

Total Before Discount is a calculated field.

The formula you require is:

DocTotal + DiscSum - VatSum

I hope this answers your question.

Regards

Tanveer

Edited by: Tanveer Waseem on Sep 8, 2008 4:04 PM

[former_member187989]

sura,

SELECT T0.[DocNum],T0.[DiscSum] FROM [dbo].[OINV]  T0 WHERE T0.[DocNum] ='[%0]'

Jeyakanthan

[jitin_chawla]

Hi,

You can check table OINV and INV1 regarding the field details.

Regards,

Jitin

[Former Member]

Hi

I can get row vise , but i need total

Regards

srinu

[jitin_chawla]

Hi,

check foloowing thread is it helps :

To calculate the total before discount :

Total document - rounding - Tax + discount.

(DocTotal - TotalExpns - VatSum + DiscSum --> SQL fields)

Regards,

Jitin

[former_member583013]

At the document level, the Total Before discount is not stored in a field.

It could be calculated as SUM( line total before discount)

Suda

[Former Member]

Hi Suda,

During Posting A/R Invoice System PostOne JE , In that

sales revenue value is "total before discount' . i need to write

procedure in Sp_transaction , that will is 6%value from 'Total before discount"

then this value need to add in JE

How it is Possible

Regards

Srinu

[former_member583013]

I hope you understand that you do not have control on what posts to the JE and manipulate the same using the SBO_SP_TN

The TN stored Proc can be used for validation and not much more.

So doing a 6% calc on your totals and posting to JE would NOT BE POSSIBLE