Query for Assessable Value

[Former Member]

Please help me with a query to show Invoice No., Invoice Date and Assessable Value

Regards,

Mitesh

[kothandaraman_nagarajan · Accepted solution]

Hi,

Are you looking for this:

SELECT  T0.[DocNum], T0.[DocDate], sum(T1.[AssblValue]) as Value FROM OINV T0  INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[DocDate] between [%0] and [%1] group by T0.[DocNum], T0.[DocDate]

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

No data found

As Assessable Value is not present in all the invoices. There are invoices with Excise or Without Excise and with Vat or CST.

Regards,

Mitesh

[kothandaraman_nagarajan · Accepted solution]

Hi,

Sorry. Not familiar with Assessable Value calculation and its definition.

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi,

Please check with this thread https://scn.sap.com/message/5819491 to get an idea to capture necessary values for assessable calculation.

Thanks & Regards,

Nagarajan

[Former Member]

Hello Sir,

My query is resolved by the first answer which you had given me.

Thank you

[Former Member]

Anyone else, please help...

[former_member197621]

Hi Mitesh,

For excisable items only field will be editable.

In Assessable field, system wont have the value automatically.

You have to input the value manually, to calculate the tax amount.

Above point is not helpful for you , explain your question with one example. Will help you to achieve it.

[Former Member]

I want three columns named Invoice Number, Invoice Date and Base Amount. The Base Amount column should show :

1. If VAT purchase, then Base Amount

2. If Excise purchase from manufacturer, total Assessable Value

3. If Excise purchase from Trader, only Assessable Value which is passed by the trader.

Regards,

Mitesh

[former_member197621]

Hi Mitesh,

Currently I don't have India localization database to write this query, lets see some one helping for you.