Sunday, March 19, 2017

Customizing Automatic Withholding Tax

If you are using Payables to automatically withhold tax, you may want to customize the AP_CUSTOM_WITHHOLDING_PKG to perform special behavior. This PL/SQL package contains two procedures that are called when you automatically withhold tax. Both procedures are empty (perform nothing), but can be modified.
AP_SPECIAL_RATE is called any time you automatically withhold tax. Modify this procedure if you want to use Penalty type AWT rates, or any other user-defined AWT Rate Type. For example, you may want to use a Penalty type rate for a specific supplier. The AP_SPECIAL_RATE procedure is located in the following directory and is called:

$AP_TOP/admin/plsql/apcmawtb.pls
After you modify this file, execute the following command:

$ sqlplus <APPS username>/<APPS password> @apcmawtb.pls
AP_SPECIAL_ROUNDING is called only when you automatically withhold tax during payment batch processing. Modify this procedure if you want to perform rounding of tax amounts during withholding. For example, you may want to round all withholding tax amounts up to the nearest dollar. The AP_SPECIAL_ROUNDING procedure is located in the following directory and is called:

$AP_TOP/admin/plsql/apcmawtb.pls
After you modify this file, execute the following command:

$ sqlplus <APPS username>/<APPS password> @apcmawtb.pls

No comments:

Post a Comment

Powered By Blogger