FI fields problem amount without tax....

[SujeetMishra]

Hi,

I have to create one Finance module Report in which i am displaying gross value, the accounting department need to know the net value (without tax) now for reporting.

I tcode FB03 , if you see the document no then it will give all accounts, posting key wise amount, but this amount is gross amount. in this amount tax amount is added as per tax code. (you can see by clicking tax details tab).

i want net amount without adding tax amount. so please guide me table and fields from where and how i can calculate. in tax tab there is field base amount but its giving calculation against all total against document.

table i am using in my report is KNA1.KNKK, KNB1, BKPF. BSEG.

Give me some idea. how can i prepare report.

Have a Nice Day,

Regards,

Sujeet

[anuj_srivastava]

Hi ,

You can look for the table WITH_ITEM. In this table you can get the total tax amount according to different categories.

Once you get the tax amount you can deduct the gross amount to get the net amount and get it displayed in your report.

Regards,

Anuj

[Former Member]

find out the link with sales order (i.e with vbak,vbap) with the help of functional consultant and then fetch amount from vbap-netwr.