Tuesday, January 10, 2017

Oracle receivables Late charge report ended with "no data found"

Issue:

Oracle receivables Late charge report ended with "no data found"

Solution:

1. Go into the responsibility: Receivables.

2. Navigate to Customers -> Customer profiles

Query back the profile used on your customers

Click on the 'Late Charge Profile'

Check the 'Late Charge Type'

select 'Adjustment'



Ensure you update all customers when prompted.

If you have already done the above set up and still no invoices are picked up, please check the below.

Please select 'Charge Schedule Per Invoice' instead of 'Charge Schedule Per Tier'.In 'Charge Schedule Per Invoice' the 'Schedule Type' can be defined as 'Percentage' as well as 'Amount' Type.The set up for 'Charge schedule Per Invoice' is same as 'Charge Schedule per Tier' where we can define our own slabs.

Whereas In 'Charge Schedule Per Tier' the 'Schedule Type' can be defined only as 'Amount'.





Oracle receivables Late charge report ended with null output (not generating output)

Issue:

Late charge report not generating output

Solution:

Set the profile to Yes at the site level.

Profile Name: "AR: Use Statement, Dunning, and Late Charges"

Responsibility: System Administrator

Navigation: Profile > System

Query Profile : AR: Use Statement, Dunning, and Late Charges

Set the profile option to "Yes" at the site level.


Wednesday, January 4, 2017

How to Setup Oracle Payable Withholding Tax (AWT) in R12


Oracle Account Payable – Withholding Tax Setup & Flow - R12


1. Create Special Calendar for AWT

2. CIS Calendar Profile Option

3. Define Withholding Supplier (Tax Authority)

4. Create Withholding Code

5. Define Withholding Group

6. Configure Payable Options

7. Enable Withholding Tax applicability in the vendors

8. Perform AWT Transactions/Transaction flow



1. Create Special Calendar for WHT

Create Monthly Special Calendar

(N) Setup>Calendar>Special Calendar



2. Profile option for CIS calendar

Attach your SPL calendar in site level profile option

(N)System Admin>System Profile



3. Define withholding supplier (Tax Authority)

Create Tax Authority supplier to create withholding invoices

(N)Supplier > Entry



Select the supplier type as “Tax Authority”




4. Create withholding code

Create withholding tax code with attaching the tax authority, SPL calendar and withholding tax percentage.

(N) Setup>Tax>withholding>Code



5. Define withholding Group

Create withholding group and attach the withholding code to it.

(N) Setup>Tax>withholding>Group



6. Configure Payables Option

Setup payables option for withholding tax,

(N) Setup>Options>Payables Options



7. Enable withholding tax applicability in the vendors

Allow withholding tax in the supplier and supplier site level for withholding tax applicability

(N)Supplier > Entry




8. Perform withholding tax Transactions

Create AP invoice for withholding tax supplier to test your configuration.





Invoice deducted the withholding tax




Query the “Tax Authority” to find the withholding tax invoice



End the Process...