Wednesday, November 15, 2006

Exploring Oracle Self Billing (Payment on Receipt)

Last couple of weeks (and also weekends) have been quite hectic for me. Seems i have been clocking over 12 hrs a day, whew!!... Luckily, i have being doing some good work apart from the usual routine. One of them is testing the Oracle's Self Billing for our project. Self Billing is also known as Evaluated Receipt Settlement (ERS) or Payment on Receipt.
When Self Billing is enabled for a particular Supplier Site, standard invoices get created automatically for payment whenever the goods are received. One can automatically create invoices with multiple items and distribution lines that includes tax. We can select Payment method, "Pay On"as follows:
'Receipt'- used for material that is not consigned.
'Receipt and Use'- for material that can be either consigned or non-consigned material.
'Use'- employed for consigned material.One can assign 'Alternate Pay Site' in case we need to pay in that site an not the default supplier site. The supplier site is the default pay site. Invoices can be summarised based on the selection made in 'Invoice Summary Level'. Invoice summary level can be at:'Pay Site' - one invoice is created per supplier pay site.'Packing Slip' - one invoice is created per packing slip per supplier pay site.'Receipt' - one invoice is created per receipt per supplier pay site.
Also, enable the 'Create Debit Memo From RTS Transaction' option if you want the system to automatically create a debit memo in Payables when you enter a Return To Supplier (RTS) in Purchasing. The value for supplier defaults from the Purchasing Options window.
However, the invoice summary levels are dependent on the 'Pay On' method selected earlier. If 'Receipt and Use' has been selected, the invoice summary level available is 'Pay Site'. If 'Use' has been selected, the invoice summary level options are 'Packing Slip', and 'Pay Site'.The Invoice number that gets created is of the format "ERS-X-Seq#", where "ERS" defaults from the Profile Options "PO: ERS Invoice Number Prefix" which is by default set as "ERS" at Site level. X depends on the summary level:- if summary level = Pay Site then X = Invoice Date- if summary level = Packing Slip then X = Packing Slip Number- if summary level = Receipt then X = Receipt NumberAnd, Seq# is a unique system generated number.
Once Receiving is done, Run the Program 'Pay On Receipt AutoInvoice' individually or schedule it to run at discrete intervals.
(1) Choose Transaction Source as 'ERS'.
(2) Enter a Commit Interval. The Commit Interval is a numeric representation of the number of invoices evaluated before they are committed. For example, if you have a Commit Interval of 10, after 10 invoices have been processed, they are committed. If you then process another 5, and the process fails, only 5 will not be committed.
(3) Optionally enter a Receipt Number.
Note: If the Receipt Number is null, the program will try to process all the receipts that have not been invoiced successfully. If you enter a Receipt Number, only that receipt will be processed.
(4) Optionally enter an Aging Period.The Aging Period defaults from the PO: ERS Aging Period profile option, but you can change it here. For example, an Aging Period of 2 means that Payment on Receipt processes only those receipts that are 2 or more days old.
(5) Choose OK and then Submit Request to begin the process.
(6) Once the 'Pay On Receipt AutoInvoice' program is submitted the 'Payables Open Interface Import' program also starts running. Ensure that the 'Pay On Receipt AutoInvoice' process and the Payables Open Interface Import process complete successfully. View Output to check the 'Payables Open Interface Audit Report'. Check if there are any invoices rejected in the section 'Payables Open Interface Rejections Report' and accordingly one can go to the Payables Open Interface window and modify the invoice line / distribution and resubmit the Payables Open Interface Import process.

Reference:
(1) Oracle Applications Online Help
(2) Oracle Payables user Guide
(3) Oracle Purchasing user Guide

4 comments:

Unknown said...

Hi,

At which stage does the ERS creates an invoice? I mean at which stage is a receipt considered to be confirmed? Upon receipt into receiving subinventory or after completion of inspection ?

We have routing meathod as inspection required and would like to create invoice through ERS only for the accepted quantity and not the received quantity.

Please let me know how we can achieve this.

Many Thanks
Syed Basith

chinni said...

Hi

This is saritha am new of oracle apps i have one doubt any plz tell me interfaces in AP and AR module.plz send me the Interface code in AP and AR module.send me the code my email id sari4apps@gmail.com


Thanks & Regards
saritha

Unknown said...

I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. Your write up is a fine example of it.For more details about Oracle Fusion SCM training please check our website.


Oracle Fusion SCM Training

12345 said...

Nice blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
Workday Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad

About Me

My photo
India
Krishanu's Oracle Applications Blog - Oracle Apps consulting services scenario in India. Also, an inside view of Oracle Apps outsource services in India. Also the blog features new developments in Oracle Apps and my learning's in this field. The views expressed are my own only and not of my employer Wipro Technologies. The views and opinions expressed by visitors to this blog are theirs and do not necessarily reflect mine.