Purchase Register with VAT or CST
I'm new to CIN concept and I don't know much about the scencarios but now my client requirement is to have a purchase register for 'Excise duty + Vat or CST'.
Some how I've managed to find excise duties in table J_1IEXCDTL but how do I find VAT or CST for the same, please help me to achieve this since it is very critical.
Thanks & Regards,
VAT and CST value is in Tax procedure. You will never find it's value in KON* tables.
Only pricing condition types are stored in KONV table.
You may refer the below process:
a) If you want the VAT/ CST value after PO is placed and before MIRO is posted, the use FM :CALCULATE_TAX_FROM_NET_AMOUNT for calculating the same.
b) If you want actual values of VAT/ CST posted at the time of MIRO,then you can list out the same via standard report J1I2 .
There are some input selections for the report. But, the main input criteria in your case is the VAT/ CST condition type under the heading "GENERAL SELECTIONS".
The output of this report may be cross-referenced with table BSET.
You can differentiate whether PO has VAT or CST based on your condition types in tax procedure for VAT and CST or tax codes used in PO for VAT or CST.