Skip navigation.

Feed aggregator

Oracle R12 Payables Discount

V.J. Jain - Thu, 2009-09-24 13:54

One user posted a question on OTN forums for Payables –

Hi all,

I have a scenario involving discount on the purchase of an Item. My invoice, as received as the supplier is as follows:

Item xxx 100
Discount (10)

Total 90
VAT(15%) 15.50

Net 103.50

When I create an invoice in AP, I add a line with amount $100 and assign a tax of 15%
The above create a total of $115 and i add this total as header amount in the invoice.
AND in the Scheduled Payment tab at line level, I add a discount amount of $10 for the “First Discount” Info.

When I make payment for the above invoice, a pop-up appears indicating discount will be applied. But the Payment amount is $105 (Invoice header amount minus discount).

Is this the only way to treat discount in AP?
I need the payment amount to be $103.50 after applying discount.

My response was:

If I understand correctly, it seems like you are manually calculating the tax and entering it to the invoice amount. If you configure your taxes in Oracle, and then enter the invoice for the actual amount, then Oracle will know the true invoice amount which is the discount basis and create the tax line according to the configurations (the way you want it). What you are doing now is adding the tax outside Apps configuration and then expecting Apps to calculate the appropriate discount. If you want to use the standard functionality, you need to set up all dependent parts of that functionality. If tax calculation is a dependency of the discount basis, which is certainly a dependency of discount payment terms, then you need to set it up properly.

This really demonstrates one major theme that I consistently encounter with Oracle Apps consultants.  There is a lack of true understanding of the fundamentals behind the applications.  I’m not saying that is the case for this particular user because I don’t know him/her but it is the case for the majority of consultants that are staffed into most projects.

Everything in the ERP system is part of a business flow.  For a company that sells products, it is something similar to
- Leads to Quotes to Sales to [PO|Manufacturing to] Shipping to Invoice to Receipt to Cash to Financials

For Payables it is something like
- Purchasing to Receipt to Accrual to Invoice to Payment

For Discount Payment Term it is going to be
- Invoice /w Discount Terms to Payment with Discount Taken

Most vendors are going to exclude tax and freight from the discount allowed by prompt payment of the invoice.  So obviously if you want Oracle to calculate the amount to take on an invoice with discount terms, it is going to need to know what portion of the Invoice is for freight and tax.  Expecting the discount to be applied to only the $100 of a $115 ($15 from tax) invoice when the invoice is entered as $115 invoice is not going to work.  Have you ever heard of a tax line?

R12 does complicate the management of taxes with the E-Business Tax module.  I know of several consultants who are “experts” in R12 E-Tax and are getting great bill rates as they help setup the new module.

I learned R12 EBTax but not without several weeks of continuous headaches.  I won’t take projects to setup the R12 EBTax because it is tedious.  Regardless, it is important for Oracle apps consultants to be aware of how taxes work in R12 or you run into situations where things are not working the way you want and you don’t know why.  To someone who understands the applications, it jus seems like you lack common sense.

Starting my blog, finally

V.J. Jain - Mon, 2009-09-21 15:06

I’ve been wanting to create a blog for a long time now and I’m finally getting around to it.  Originally, I was hoping that the Oracle Forums would be an interactive resource but with almost 20,000 registered members, it is too difficult to moderate.

So here it is, my new blog.  Feel free to join and comment!

- V.J. Jain

Siebel EAI Roadmap - Part 4 of 4

Graham Doe - Mon, 2009-06-01 13:58
However, as a final point I should stress the optional aspect of these evolutions. All new EAI functionality will be delivered via the SOA Suite architecture but if the existing Siebel EAI stack meets a customer’s needs there is no requirement for them to upgrade today. The same is true for UCM, or any other Oracle application that Siebel integrates with... BI Publisher is a special case however, as Oracle have elected not to continue the relationship with Actuate BI Publisher will become the reporting solution delivered with the Siebel product. In fact, given how long it's taken me... Graham

Siebel EAI Roadmap - Part 3 of 4

Graham Doe - Mon, 2009-06-01 03:56
One of the key technology stacks that had “stagnated” in recent years was the Siebel EAI stack. With a small number of notable exceptions the standards support that Siebel EAI provided was firmly rooted in earlier versions of the standards. On examination this stack would require a huge investment in time in order to bring it up to current standards, and by then the market would, no doubt, have moved on again. Again, looking at the premis that the Siebel EAI Stack (which is effectively a very small C++ middleware) was written because it needed to be it quickly... Graham

Ask the Experts - 90

Nitin Pai - Fri, 2009-02-20 09:37
Hi My client is upgrading from FO 8.4 FS 8.4 HRMS 8.3 to FS 8.9 HRMS 8.9. Current FO 8.4 is going to be part of FS & HRMS 8.9. How do I get a list of current FO 8.4... Nitin Pai

Ask the Experts - 89

Nitin Pai - Fri, 2009-02-20 09:14
Hi,I have a strange situation in our TEST environment.In HRMS - Workforce Administration > Job Information > Job Data.We are terminating some IDs. But, the SAVE is NOT happening. Its page shows the message "Saved".But the 'TER' action row does... Nitin Pai

Ask the Experts - 88

Nitin Pai - Fri, 2009-02-20 07:54
I am very new to PeopleSoft but it has been running for about two years in my company. I have the task of loading new employee information. I have the information in a database and currently people are re-entering all... Nitin Pai

Ask the Experts - 87

Nitin Pai - Mon, 2009-02-16 14:21
I have created a permission list and included 4 components from the Menu into it. After assigning role to user, user can access all 4 components and its pages. After sometime I marked one more component as "Authorized" in the... Nitin Pai

Ask the Experts - 86

Nitin Pai - Mon, 2009-02-16 14:16
we've been experiencing problem in Absence Approve/Deny Process. we're encountering the error message "1 No Rows exist for specified keys. {GP_ABSENCE_EVENT} (91,50) No rows exist on the database with the specified keys. (0,0)". we cant find a permanent solution on... Nitin Pai

Ask the Experts - 85

Nitin Pai - Mon, 2009-02-16 09:29
We are working on the Billing -> Maintain Bills -> Adjust Entire Bill Page. The page is designed in such a way that once the user selects the credit & rebill option and clicks save both credit and rebill invoices... Nitin Pai

Ask the Experts - 84

Nitin Pai - Fri, 2009-02-13 09:57
Hi, I want to implement a discussion page as we use in ICE. Please provide me an info on that. Thanks in advance. Thanks for posting your question! Consider using Sharepoint or Oracle Beehive portals instead of building a custom... Nitin Pai

Ask the Experts - 83

Nitin Pai - Fri, 2009-02-13 09:36
Hi, I have a Field "Country" on a page, actually on a subpage. Main Table: A, Subrecord: CM_ADDRESS_SBR, Subrecord: ADDRESS_SBR -> A contains CM_ADDRESS_SBR-> CM_ADDRESS_SBR contains ADDRESS_SBR It has COUNTRY_TBL as the prompt table in the subrecord. It gives the... Nitin Pai

Ask the Experts - 82

Nitin Pai - Fri, 2009-02-13 09:26
Hi, Can we create a View in App Designer, which accesses tables from another link server?eg:select EMPLID from [psserv6].[HRUAT].dbo.PS_JOB Also I have an uppercase problem with the following View. %NoUppercase SELECT EMPLID , GRADE FROM [HRSTAG].dbo.PS_JOB the owner "dbo" should... Nitin Pai

Ask the Experts - 81

Nitin Pai - Mon, 2009-02-09 15:28
I need some help from anyone who has faced/resolve the issue: We had an AE (EPM 8.9)which runs in DEV & UAT in less than 30 min. But we ran the same AE in PROD it gets hanged forever. Its... Nitin Pai

Ask the Experts - 80

Nitin Pai - Mon, 2009-02-09 15:19
If we have a client who is multi-companies and each company have different standard hours, how can we achieve this since 1 user profile can only be tied to only 1 Primary permission list? (in Peoplesoft HCM 9.0 & Tools... Nitin Pai

Ask the Experts - 79

Nitin Pai - Fri, 2009-02-06 09:05
I would like to know if there's a kind of functionality in PSGL where we can run allocation ONLY if the balance of the pool is negative. If the balance of the pool is positive, then no additional journals will... Nitin Pai

Ask the Experts - 78

Nitin Pai - Thu, 2009-02-05 12:59
Hi PeopleSoft Teams,To let us know the feasibility of invoking a CI present in X instance from another instance Y either with or without any links. Also how to pass the parameters for the same. Thanks for posting your question!... Nitin Pai

Ask the Experts - 77

Nitin Pai - Wed, 2009-02-04 13:29
We have a PRD1 PS enviroment and PRD2(copy of PRD1) PS environment.PRD2 gets refreshed every month from PRD1. I would like to create a userid(like PS) in PRD1 with Display Only access to everything and when the PRD2 gets refreshed... Nitin Pai

Ask the Experts - 76

Nitin Pai - Wed, 2009-02-04 12:53
Hi,We are implementing CRM for a Bank. For that we are importing all the Customers, account details and different relationships between them through various AE's. The AE programs are required to be executed in following sequence;1. Import Personal Customer Details.2.... Nitin Pai

Ask the Experts - 75

Nitin Pai - Mon, 2009-02-02 15:26
Hi, I'm having trouble with my PS Process Scheduler in Version 7.5. Sometimes it starts without any problems but sometimes it goes a little something like this: STARTTING PROCESS SCHEDULER PSNT ON DATABASE XXXXXXX. PROCESS SCHEDULER WILL BE RESTARTED UP... Nitin Pai