Early Payment Discount In Account Receivable

The question:
customer order received for item A and we have scheme for item A if user order item A we will give him discount of 200 $ on each items but only in case if he pay in 3 days how it will be handled ?
The solution:
Payment Terms
Receivables lets you define standard payment terms
read more..

Export to CSV, Howto prevent loss of spaces

Very often i am working getting extracts from the EBS database and sent the information in an attachement to users. If you do this in Excel (CSV), it is easy for a user to open it. Excel opens defaults CSV. But when you sent it directly you will see that the leading zeros in the
read more..

What functions are attached to a responsibility

As next step on the previous post. Below a query to find out what functions are attached to a responsibility.

Query that shows all the repsonsibilities and what functions are attached to these responsibilities.
SELECT DISTINCT faa.application_name application, rtl.responsibility_name,
ffl.user_function_name, ff.function_name, ffl.description,
ff.TYPE
FROM fnd_compiled_menu_functions cmf,
fnd_form_functions ff,
fnd_form_functions_tl ffl,
fnd_responsibility r,
fnd_responsibility_vl rtl,
apps.fnd_application_all_view faa
WHERE cmf.function_id = ff.function_id
AND r.menu_id = cmf.menu_id
AND rtl.responsibility_id = r.responsibility_id
AND
read more..

Check to which set of books a responsibility belongs

Every tried to find a quick way which set of books has which responsibility attached to it. Below a quick query to get the information

SELECT fr.responsibility_name, fpov.profile_option_value set_of_books_name
FROM fnd_profile_options_vl fpo,
fnd_profile_option_values fpov,
applsys.fnd_responsibility_tl fr
WHERE fpo.user_profile_option_name = ‘GL Set of Books Name’
AND fpo.profile_option_id = fpov.profile_option_id
AND fpov.level_value = fr.responsibility_id

Advanced collections and Dunning in R12

The AR Dunning Letters is obsolete in R12.
The AR Collections Workbench is obsolete in Release 12.
 You will need to install the Oracle Advanced Collections application.
 The basic Collections functionality is available in Oracle Advanced Collections without any extra cost. However, if you wish to use the more complex functionality in the Oracle Advanced Collections, you will
read more..

Select customers and transaction with a total open amount between certain values

Ever had a question from your user / finance department. We want to have a list of all customers with an open amount between 1 cent and 5 euro. Or a list of transactions with an open amount below 1 euro.
Most of the time the user wants to book the transactions of because collection the
read more..