Table or FM for fetching Tax value posted in GR

[Former Member]

Hallo Experts,

We are developing purchase register report company code in India. This report also needs tax values posted in GR and IR. Tax rpocedure is TAXINN for country India.

Tax values are posted to inventory G/L account at the time of GR (non-deductible taxes).

Tax values in IR can be fetched from table BSET for particular tax condition types.

But tax values posted in GR are not stored in any particular table for tax condition type. Table BSEG has entry for Inventory account and GR/IR clearing account. But here in BSEG it is not segregated as material cost and tax value.

Example: PO line item quantity 100ea and price 100INR, Sales Tax (JIP1-NVV 2%) 200 INR.

GR posted for 30EA and IR is also posted. Purchase register has to display GR details with tax value as 60 INR.

Please let me know how can we get the tax posted to inventory in GR document. Is there any FM or tables?

[Former Member]

Please reply. I just want to know whether we can get the tax value posted in GR with reference to PO. How to get it in a report?

[jpfriends079]

As this query is specific to CIN. The discussion will be moved to Internationalization and Unicode space.