Charge Service Tax in AP Standalone Invoice:
Standalone AP Invoices will be raised for non-item based expense or service activities. As Item information is not available for such invoices, regimes like Excise, Customs and VAT that are Item-based tax regimes will not be associated with Standalone AP Invoices. Similarly other tax types such as Octroi, Insurance, and Entry Tax etc. are all Item movement related and hence not applicable to Standalone AP Invoices. Hence the only Indirect Tax regime applicable on Stand-alone invoices will be the Service Tax Regime (Direct Tax regimes such as Tax Deduction at Source shall continue to be supported with the existing Global Flex field basis approach for standalone invoices also).
Value Added Tax (VAT) recovery requirements of India Localization VAT recovery process is currently linked to receipt of goods and also on Item attributes. As AP Standalone Invoice does not carry the Item information, VAT recovery is kept out of scope of this project. User should use the VAT Manual recovery entry mechanism for handling exceptional scenarios where a stand-alone invoice is carrying recoverable VAT taxes.
Check the Balance of India Service Tax Credit Register Report
1. Create a Standalone Payable Invoice
2. Attach the Service Tax Category
3. Validate, Approve, Account the Invoice
4. Pay and Account the Payment
5. Run the India Service Tax processing Concurrent.
6. Check the India Service Tax Credit Register Report
(1)Create a package named, APPS.OE_DEFAULT_TEST_PKG and a function named, Get_CUST_PROFILE_CURRENCY(p_database_object_name IN VARCHAR2,
p_attribute_code IN VARCHAR2) RETURN VARCHAR2;
(2)description of the function,
FUNCTION Get_CUST_PROFILE_CURRENCY
(p_database_object_name IN VARCHAR2
,p_attribute_code IN VARCHAR2)
RETURN VARCHAR2
IS
l_cust_org_id NUMBER;
l_cust_account_profile_id NUMBER;
l_currency_code VARCHAR2(3) := NULL;
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
BEGIN
IF ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id IS NOT NULL
AND ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id <> FND_API.G_MISS_NUM
THEN
l_cust_org_id := ONT_HEADER_DEF_HDLR.g_record.sold_to_org_id;
BEGIN
SELECT CUST_ACCOUNT_PROFILE_ID
INTO l_cust_account_profile_id
from HZ_CUSTOMER_PROFILES
where CUST_ACCOUNT_ID = l_cust_org_id
and site_use_id is null;
SELECT CURRENCY_CODE
INTO l_currency_code
FROM
(SELECT CURRENCY_CODE
FROM HZ_CUST_PROFILE_AMTS
WHERE site_use_id is null and (CUST_ACCOUNT_ID= l_cust_org_id)
and (CUST_ACCOUNT_PROFILE_ID=l_cust_account_profile_id)
ORDER BY currency_code)
WHERE rownum = 1;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN NULL;
END;
END IF;
RETURN l_currency_code;
EXCEPTION
WHEN OTHERS THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add('Error in Get_CUST_PROFILE_CURRENCY') ;
oe_debug_pub.add('Error :'||substr(sqlerrm,1,200)) ;
END IF;
RETURN NULL;
END Get_CUST_PROFILE_CURRENCY;
(3)Go to ,Order Management responsibility > setup > Rules > Defaulting
(4)Make query.It will show the results.
(5)Select,
Application-Order Management
Entity - Order Header
Nextly select the attribute "currency" and press the "Defaulting Rules.." tab.
(6)This will open the Attribute Defaulting Rule window.
(7)Disable the seeded defaulting rule and add the customize rule in default condition section.
Nextly create the default sourcing rule,
(I)Source type - Related Record , Default Source value-Price List(Related Object).Currency(Related Attribute).
(II) Source Type -PL/SQL API , Default Source value -OE_DEFAULT_TEST_PKG(Related Object), Get_CUST_PROFILE_CURRENCY(Related Attribute).
(8)Save the work.
Select Poh.SEGMENT1 Purchase_Order_Number,Pol.QUANTITY, Pol.UNIT_PRICE,
jpt.TAX_RATE, Jpt.TAX_TYPE,Jpt.TAX_AMOUNT, Jct.TAX_DESCR
