JA India GSTR-3 Return

➜ Back to Library
Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
Source: India GSTR-3 Return Report
Short Name: JAIGSTR3
DB package:
Run JA India GSTR-3 Return and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT NULL pdcash,
                        TAX_LIABILITY_AMT tax_val,
                        NULL txpd,
                        lines.CREDIT_TO_BE_ADJUSTED itc
                 FROM JAI_STL_TRX_HDRS_V hdr, JAI_STL_TRX_LINES_V lines
                 WHERE hdr.STL_HDR_ID = lines.STL_HDR_ID
                 AND TO_CHAR (TRUNC (hdr.settlement_date), 'MONYYYY') LIKE :P_PERIOD_NAME
				 AND REGISTRATION_NUM = :P_FIRST_PTY_REG_NUM
Parameter Name SQL text Validation
Tax Regime 
 
 LOV Oracle
Registration Number 
 
 LOV Oracle
Return Period(MONYYYY) 
 
 Char
IGST Interest Paid 
 
 Number
SGST Interest Paid 
 
 Number
CGST Interest Paid 
 
 Number
CESS Interest Paid 
 
 Number
SGST LateFee Paid 
 
 Number
CGST LateFee Paid 
 
 Number
Download
Related Blitz Reports
JA India - ST Forms Customer - draft JA India - ARE1 Report- Not Supported: Reserved For Future Use JA India - Total Sales - draft JA India - Open Transactions Report for Prior-GST (XML Publisher) JA India - TDS at Lower Rates - draft JA India - Generate Suggestive Supplementary Transactions - draft JA India - Supplementary Transaction Details - draft JA India - TDS Prescribed Rate - draft OKL Print Consolidated Invoices
Blitz Report™

Blitz Report™ provides multiple benefits: