GST Transactions Queries For PO and Invoices

GST Transactions Queries For PO and Invoices

In this post , I will share the Import GST queries , which help to extract the GST information's associated with the Transactions for the Payables Invoices and the Purchase Order . This will gives you detail about GST Transactions Information's and help to find the GST HSS,SAC information's  for the Purchase Orders.

 

To Calculate GST Tax Amount for PO

 

(SELECT SUM (UNROUND_TAX_AMT_TAX_CURR)

FROM jai_tax_lines_all jtl1, jai_tax_types jtt1

WHERE pha.po_header_id = jtl1.TRX_ID

AND pla.po_line_id = jtl1.TRX_LINE_ID

and jtl1.ENTITY_CODE = 'PURCHASE_ORDER'

AND jtl1.tax_type_id = jtt1.tax_type_id(+)

AND jtt1.TAX_TYPE_NAME LIKE '%CGST%')

To find the GST Tax Category for the Purchase Orders.

(select TAX_CATEGORY_NAME from JAI_TAX_CATEGORIES
where tax_category_id in ( select nvl(default_TAX_CATEGORY_ID,OVERRIDE_TAX_CATEGORY_ID) from jai_tax_det_factors

where org_id=:p_org_id

and ENTITY_CODE = 'PURCHASE_ORDER'
and TRX_LOC_LINE_ID=plla.po_line_location_id))

To find the GST HSS,SAC information's  for the Purchase Orders.

select HSN_CODE,SAC_CODE from JAI_TAX_DET_FCT_LINES_V

WHERE TRX_LOC_LINE_ID=plla.po_line_location_id