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.

P2P Accounting with GST - Recoverable Inventory Item (Tax Point Base - Invoice)

 

P2P Accounting with GST - Non Recoverable Inventory Item (Tax Point Base - Delivery)

 

P2P Accounting with GST - Recoverable Inventory Item (Tax Point Base - Delivery)

 

Query for Receipt Class and Receipt Method Form Data Extraction

SELECT 

ARC.NAME RECEIPT_CLASSES,

ARM.NAME ,

ARM.PRINTED_NAME,

ARM.START_DATE "EFFECTIVE DATES FROM",

HOA.NAME "OPERATING UNIT",

CEA.BANK_ACCOUNT_NAME,

CEA.BANK_ACCOUNT_NUM,

CEA.BANK_ACCOUNT_ID,

CEA.IBAN_NUMBER,

CEA.EFT_USER_NUM,

CBBV.BANK_NAME,

CBBV.BANK_BRANCH_NAME,

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=ARMAA.CASH_CCID)"CASH ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=ARMAA.ON_ACCOUNT_CCID)"ON ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=ARMAA.UNAPPLIED_CCID)"UNAPPLIED ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=ARMAA.UNEARNED_CCID) "UNEARNED ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=ARMAA.UNIDENTIFIED_CCID)"UNIDENTIFIED ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=ARMAA.FACTOR_CCID)"FACTORING",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=ARMAA.BANK_CHARGES_CCID) "BANK CHARGES ACCOUNT",

(SELECT CONCATENATED_SEGMENTS FROM GL_CODE_COMBINATIONS_KFV WHERE CODE_COMBINATION_ID=ARMAA.RECEIPT_CLEARING_CCID) "RECEIPT CLEARING ACCOUNT"

FROM

AR_RECEIPT_CLASSES ARC,

AR_RECEIPT_METHODS ARM,

AR_RECEIPT_METHOD_ACCOUNTS_ALL ARMAA,

HR_ORGANIZATION_UNITS HOA,

CE_BANK_ACCT_USES_ALL CBAUA,

CE_BANK_ACCOUNTS CEA,

CE_BANK_BRANCHES_V CBBV

WHERE

1 = 1

AND 

ARC.RECEIPT_CLASS_ID = ARM.RECEIPT_CLASS_ID

AND 

ARM.RECEIPT_METHOD_ID = ARMAA.RECEIPT_METHOD_ID

AND 

ARM.END_DATE IS NULL

AND 

ARMAA.ORG_ID = HOA.ORGANIZATION_ID

AND 

ARMAA.REMIT_BANK_ACCT_USE_ID = CBAUA.BANK_ACCT_USE_ID

AND 

CBAUA.BANK_ACCOUNT_ID = CEA.BANK_ACCOUNT_ID

AND 

CEA.BANK_BRANCH_ID = CBBV.BRANCH_PARTY_ID

ORDER BY RECEIPT_CLASSES;