Query for GST Document Sequence Form Data Extraction

 

SELECT
JTDS.DOC_SEQ_NAME SEQUENCE_NAME,
JTDS.START_NUMBER,
JTDS.CURRENT_NUMBER,
JTDS.PREFIX,
JTDS.END_NUMBER LAST_NUMBER,
TO_CHAR(JTDS.EFFECTIVE_FROM, 'DD-MON-YYYY') START_DATE,
TO_CHAR(JTDS.EFFECTIVE_TO, 'DD-MON-YYYY') END_DATE,
JTDA.REGIME_NAME,
JTDA.REGISTRATION_NUMBER,
JTDA.ORGANIZATION_TYPE_NAME,
JTDA.ORGANIZATION_NAME,
JTDA.LOCATION_NAME,
JTDA.DOCUMENT_TYPE_CODE,
JTDA.DOCUMENT_CATEGORY_NAME,
JTDA.INTENDED_USE_NAME,
JTDA.RCM_SUPPLY_DAYS,
TO_CHAR(JTDA.EFFECTIVE_FROM, 'DD-MON-YYYY') START_DATE,
TO_CHAR(JTDA.EFFECTIVE_TO, 'DD-MON-YYYY') END_DATE
FROM
APPS.JAI_TAX_DOC_SEQS JTDS,
APPS.JAI_TAX_DOC_SEQ_ASGMT_V JTDA
WHERE
JTDS.DOC_SEQ_ID=JTDA.DOC_SEQ_ID
AND
JTDS.EFFECTIVE_FROM>='01-APR-22'

Recoverable Checkbox not Ticked at PO or Receipt Level ??

For Recoverable Checkbox to be enabled at PO and Receipt Level, we need to ensure all the below pre-requisites to be done from setup level point of view.

1. First Party Should be registered in 'First Party Registration' form for the Inventory Organization for which Ship To & Bill To is selected at Purchase Order Level.

2. Third Party of Supplier should be registered in 'Third Party Registration' form.

3. Classification of Item should be done.

4. 'Recoverable' Check Box should be enabled at Tax Type Form Level.

5. 'Recovery Rate' should be 100% at Tax Rate Level.

6. 'Claim Terms' Should be defined for the Tax Type and Inventory Organization with Location.

Query for Tax Type Form Data Extraction

SELECT

JR.REGIME_CODE "TAX REGIME CODE",

JR.REGIME_NAME "TAX REGIME NAME",

JTT.TAX_TYPE_CODE "TAX TYPE CODE",

JTT.TAX_TYPE_NAME "TAX TYPE NAME",

TO_CHAR(JTT.EFFECTIVE_FROM, 'DD-MON-RRRR') "START DATE",

TO_CHAR(JTT.EFFECTIVE_TO, 'DD-MON-RRRR') "END DATE",

JTT.RECOVERABLE_FLAG "RECOVERABLE",

JTT.ALLOW_ABATEMENT "ALLOW ABATEMENT",

JTT.OFFSET_FLAG "APPLICABLE FOR OFSET",

JTT.SELF_ASSESSED_FLAG "SELF ASSESSED / REVERSE CHARGE",

JTT.REPORTING_ONLY_FLAG "SET TAX TYPE FOR REPORTING PURPOSE ONLY",

JTT.UPDATE_VENDOR_ON_TRANSACTION "UPDATE VENDOR ON TRANSACTION",

JTT.WTHLD_TRX_APPLICABLE_FLAG "WITHHOLDING TAX APPLICABLE",

JTT.TAX_POINT_BASIS "TAX POINT BASIS",

GLL.NAME "LEDGER",

HOU.NAME "OPERATING UNIT",

HOU1.NAME "INVENTORY ORGANIZATION",

HRL.LOCATION_CODE "LOCATION",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID = JTA.INTERIM_RECOVERY_CCID) "INTERIM RECOVERY ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID = JTA.RECOVERY_CCID) "RECOVERY ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID = JTA.INTERIM_LIABILITY_CCID) "INTERIM LIABILITY ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID = JTA.LIABILITY_CCID) "LIABILITY ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID = JTA.EXPENSE_CCID) "EXPENSE ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID = JTA.ROUNDING_CCID) "ROUNDING ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID = JTA.SUSPENSE_CCID) "SUSPENSE ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID = JTA.ADVRCPT_SUSPENSE_CCID) "ADVANCE SUSPENSE ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID = JTA.ISO_SUSPENSE_CCID) "ISO SUSPENSE ACCOUNT"

FROM

APPS.JAI_TAX_TYPES JTT,

APPS.JAI_REGIMES JR,

APPS.JAI_TAX_ACCOUNTS JTA,

HR_ALL_ORGANIZATION_UNITS HOU,

HR_ALL_ORGANIZATION_UNITS HOU1,

HR_LOCATIONS HRL,

GL_LEDGERS GLL

WHERE

JR.REGIME_ID=JTT.REGIME_ID

AND

JTT.TAX_TYPE_ID=JTA.TAX_ACCOUNT_ENTITY_ID

AND

JTA.ORG_ID=HOU.ORGANIZATION_ID(+)

AND

JTA.ORGANIZATION_ID=HOU1.ORGANIZATION_ID(+)

AND

JTA.LOCATION_ID=HRL.LOCATION_ID(+)

AND

JTA.LEDGER_ID=GLL.LEDGER_ID(+)

AND

JTA.LEDGER_ID=114                           -------(Pass Ledger ID)

ORDER BY JR.REGIME_CODE, JTT.TAX_TYPE_CODE;

TDS Sec. 194(Q) Setup-EBS

Govt. Notification - Finance Act, 2021 inserted a new section 194Q in the Income-tax Act 1961 (hereinafter referred to as "the Act") which takes effect from I st day of July, 202 I. It applies to any buyer who is responsible for paying any sum to any resident seller for purchase of any goods of the value or aggregate of value exceeding fifty lakh rupees in any previous year. The buyer, at the time of credit of such sum to the account of the seller or at the time of payment, whichever is earlier, is required to deduct an amount equal to 0.1 % of such sum exceeding fifty lakh rupees as income tax.