JA India GSTR-3B Return

➜ Back to Library
Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
Source: India GSTR-3B Return Report
Short Name: JAIGSTR3B
DB package: 
            SELECT SUM(line_amt) taxable_value,
              SUM(tax_dtls.cgst) cgst,
              SUM(tax_dtls.sgst) sgst,
              SUM(tax_dtls.igst) igst,
              SUM(tax_dtls.cess) cess
            FROM jai_tax_det_factors det_fact,
              (SELECT DISTINCT tax.det_factor_id,
                SUM ( DECODE (tax_assc.REPORTING_CODE, 'IGST', (tax_lines.ROUNDED_TAX_AMT_FUN_CURR))) igst,
                SUM ( DECODE (tax_assc.REPORTING_CODE, 'CGST', (tax_lines.ROUNDED_TAX_AMT_FUN_CURR))) cgst,
                SUM ( DECODE (tax_assc.REPORTING_CODE, 'SGST', (tax_lines.ROUNDED_TAX_AMT_FUN_CURR))) sgst,
                SUM ( DECODE (tax_assc.REPORTING_CODE, 'CESS', (tax_lines.ROUNDED_TAX_AMT_FUN_CURR))) cess
              FROM jai_tax_det_factors tax,
                jai_tax_lines_v tax_lines,
                jai_reporting_associations_v tax_assc,
                jai_rgm_recovery_lines tax_rec
              WHERE to_char(trunc(tax.tax_invoice_date),'MONYYYY') like :P_PERIOD
              AND tax.det_factor_id                     = tax_lines.det_factor_id
              AND tax_assc.ENTITY_CODE                  = 'TAX_TYPE'
              AND tax_assc.REPORTING_TYPE_CODE          = 'TAX_TYPES_CLASSIFICATION'
              AND tax_lines.first_party_primary_reg_num = :P_REGN_NUMBER
                --AND tax_lines.tax_regime_code = 'GST'
              AND tax_rec.tax_line_id        = tax_lines.tax_line_id
              AND tax_lines.tax_type_id      = tax_assc.entity_id
              AND tax_lines.actual_tax_rate <> 0
              AND tax_lines.actual_tax_rate IS NOT NULL
              AND tax_lines.exemption_type  IS NULL
              AND tax.ship_to_country        = 'IN'
              AND tax_rec.liability_amount  <> 0
              AND tax_rec.status             = 'CONFIRMED'
              AND NOT EXISTS
                (SELECT 1
                FROM JAI_PARTY_REGS jpr,
                  JAI_REPORTING_ASSOCIATIONS_V jrav_party
                WHERE UPPER (jrav_party.reporting_code) IN (UPPER ('Deemed Exports EOU'), UPPER ('SEZ'))
                AND jrav_party.ENTITY_CODE               = 'THIRD_PARTY'
                AND jrav_party.REPORTING_TYPE_CODE       = 'THIRD_PARTY_CLASSIFICATION'
                AND jpr.PARTY_REG_ID                     = jrav_party.entity_id
                AND jpr.party_id                         = tax.party_id
                )
              GROUP BY tax.det_factor_id
              ) tax_dtls
            WHERE det_fact.det_factor_id=tax_dtls.det_factor_id
Parameter Name SQL text Validation
Legal Name 
 
Return Period(MONYYYY) 
 
GST Registration Number 
 
 LOV Oracle
Tax Regime 
 
 LOV Oracle
Ask a question
Download
Related Blitz Reports
JA India - Open Transactions Report for Prior-GST (XML Publisher) JA India - VAT Returns Report(1) - draft JA India - TDS at Lower Rates - draft JA India - Total Sales - draft JA India - Service Tax Credit Register - draft JA India - TDS Prescribed Rate - draft JA India GSTR-3 Return JA India GSTR-3 Return (1) JA India - Tax Recovery Register Report(XML Publisher)
Related Topics
FA Japanese Depreciable Assets Tax SummaryJA Cash Flow Statement Program - Cash Flow DetailJA India - Open Transactions Report for Prior-GST (XML Publisher)JA India - Cenvat Monthly Returns - draftJA India - RG 23 D - draftJA Third Party Detail Trial Balance with Contra AccountsJA India - Tax Liability Register Report(XML Publisher)FA Japanese Detail by Asset Type (Addition/All Assets) Report 180 CharactersJA India - TDS at Lower Rates - draftJA India - TDS Prescribed Rate - draft
Blitz Report In Action