Thursday, November 5, 2009

Oracle India Localization Interview Questions - TDS

Below are some interview questions with respect of TDS  functionality of Oracle India Localization:

Question Can India Tax code be defined with a back-dated effective date?
Answer No. While defining India Tax codes, the start date cannot be less than System Date.

Question What are the steps for generation of TDS certificates?
Answer The following three programs need to be run to generate TDS certificates:
-> India - Process TDS Payments
-> India - Generate TDS Certificates
-> India - TDS Certificate

Question If for a particular supplier there is no need to deduct TDS, what are the options available to ensure this?
Answer If no TDS needs to be deducted for a supplier, do not define 'Supplier Additional Information' for that supplier. This will ensure that no TDS tax codes are available for selection.

Question Is TDS deducted on Debit Memo or Credit Memo?
Answer No! TDS cannot be deducted on Debit Memo or Credit Memo. This entails recovery of TDS amount from TDS Authority; hence this functionality is not supported by India Localization.

Question What are the accounting entries when TDS is deducted?
Answer When TDS is applied on an Invoice, it creates creates two invoices (one Standard Invoice and one Credit Memo). The accounting entries are as follows:
Credit Memo (in the name of Initial Invoice's Supplier)
DR AP Liability
CR TDS Clearing Account
Standard Invoice (in the name of TDS Authority)
DR TDS Clearing Account
CR AP Liabiltity

Question A seperate check needs to be given to TDS authority for all deductions under various sections. How can this be achieved?
Answer While defining India Tax codes ensure that the Vendor Site is different for different TDS Section related Tax codes. Since, AP requires each supplier site to be paid by separate check, the above requirement can be met.

Question What do we mean by Threshholds under India Localization? Explain the concept of 'Single' and 'Cumulative' threshold.
Answer Refer India Localiation User Guide.

Question What is the naming convention of Invoices automatically created when when TDS tax codes are applied?
Answer The naming convention of TDS Invoices is
<Intial Invoice Number >- TDS - < SI or CM > - < a unique running sequence number >


 For example, for the Standard Invoice with invoice number 'INV001' the TDS invoice numbers would be
 - TDS Authority's INV001-TDS-SI-1111
- Supplier's INV001-TDS-CM-1111
(Assuming that TDS amount is payable to TDS Authority and the sequence's next value is 1111)

Question While creating AP Invoices TDS tax code can be applied either at Invoice Header or Distribution level. Is this statement correct?
Answer No! TDS Tax code can be only applied at the Invoice Distribution Level's DFF.

Question At what point of time are the TDS invoice's are automatically created? When invoice is entered / validated / approved / accounted / paid?
Answer TDS invoices are automatically created when a TDS Tax is entered in Invoice distribution and Invoice is validated.

Question While entering an invoice user forgot to enter TDS tax code at the invoice distributions. What option does the user has if he doesnt want to cancel the invoice but apply TDS tax?
Answer I leave this scenario so that you can check yourself :)

1 comment: