Refund of Customer's Security Deposit

[hbabhu]

Hi,


Can anyone tell me the process of refunding customer's security deposit.

Thanks

[SIVAKUMAR_G]

Hi Guys

I suggest hereafter for every Positng you make follow certain norms like mentioning the application version also

Following is possible if you are in 11.5.10

There are two ways of doing this

a) You create Customer as a Supplier and make Payment in Payables and perform AP/AR netting functionality which create respective debit and credit memo and accounts get knocked off if you want to use an check printing

b) If you are willing to use Manual check then adopt the following

(i) You might have created an Invoice with Deposit Transaction Type

The entries will be
Receivables
To Revenue (You might have attached a Liability account)

(ii) When you receive cash for the deposit

Cash/Bank A/c Dr
To Receivables

(iii) Now to make the Payment
Create a Negative Miscellaneous Receipt and in the Distribution Line
attach the Liability account used in Invoice Creation Process

The entry will be
Revenue (liability A/c) Dr
To cash / Bank

Hope this helps

Regards
Sivakumar

[hbabhu]

Hi Karthikeyan,

Thanks for your contributions ......

i have one doubts, it is manual process or it automaticaly adjust the customer balances

[hbabhu]

HI,
thank you siva and karthick

I have one more doubts?.

How to create customer as supplier?

Every employee is considered as supplier, then only we are going to make a payment??

For that we are mention under classification tab type as employee?..

Then only payables allow to pay the money to employee for (reimbursement type of invoice )

My doubts is where I mention the customer and number?

I search all the tab,there is no customer name,numbers are not come the LOV.

I need to run any program for the same ?..

If ?Yes ? tell me the program name..


When i run the program?at which module?( Supplier Customer Netting Report )

Actually, this program is aviable at AR and AP

Share you are ideas ?? ASAP

[surya_prabha]

Hi

Friends,
I'm new to oracle and this ERP Stuff also.I'm searching for jobs in oracle finacials. Please help me to acheive my goal

I've some doubts
1.How can we set up - If a supplier as customer
Give me the detailed steps
2.What is the difference between EFT and a Wire?
3.When we enter a refund with prepayment by raising debit/credit memo,
what account should be take to raise a dummy invoice.

AR
1. How can we set a sales returns?
2. What are the detailed steps for Auto Invoice?
3.What are the interfaces available in AP,GL,AR?

I'll wait for ur early reply.
Surya[:)]MBA

[SIVAKUMAR_G]

Hi

Create a new supplier with the same name of the Customer and in the General Tab you find customer number as one of the field. In this field enter your Customer number. This way supplier and customer get linked

Now create the transactions mentioned above and and run the Supplier Customer netting report from Payables.

Hope this helps

Regards
Sivakumar

[surya_prabha]

Thanq Mr. Siva,

But I would like to know the complete steps and process of Auto Invoice in the case of
Invoices from Order Management,
Invoices from Legacy Systems

I need ur early reply

Thanks & Regards,
Surya

[hbabhu]

Hi Siva,

thanks for ur timely reply. i will do that and let u know the result....

whether it adjust the customer balance?

[abhgaur@gmail.com]

Hi,

I did saw couple of point , so thought would also share my thoughts around them.

I) I think , On creating AR Invoice and giving Liability Account in Revenue may not be a good idea for long term as it might have an

audit objects ... just a thought as audiors may have a question there and would also limit future ad-hoc reporting capabilities.

However just a thought ,,,, this is more of a business process related question as in an organization there should be proper

process laid out to handle such type of situations. This would not only able to satisfy Auditors but also ensure better book

keeping. As Approvals process (may be through Workflow or a document related manual process) would ensure in reducing

the changes of overpayment.

Also it might answer (may be indirectly) as how to ensure that he is not overpayed .... presence of Process & Approvals on that

front may help in ensuring that ...may be not on the system side fully but certainly on the audit side.

So in that case .. either the AP AR netting , or using some Intermediate Clearing account to transfer the amount from AR to

Clearing and creating Invoice in AP and knocking out balance of that Intermediate clearing ... or the option suggested by

Sivakumar ...any of them would be able to suffice the business needs.


II ) the following are my thoughts to Surya's points

1.How can we set up - If a supplier as customer

I Think :
======
a) Upto 11.5.10 .. i you dont links Suppliers to Customer
b) In R12 ... since Suppliers have been moved to TCA ... may be there could be some link

* I think the important point may ... the Tax Indentified number for Supplier and Customer in there setups should be some .

This seems more of a process Issue and proper process should be there on maintenance side otheriwise there may be an Issue

on TAX side .


2.What is the difference between EFT and a Wire?

I Think :
======
EFT is electronic file which is sent to bank and against that bank creates transaction. Example could be - a electronic file that

you send to bank and bank creates payment against that . Since it is directly sent to bank that is why if you notice on Oracle

Apps side Suplier Account number is mandatoty if your payment method is Electronic.

Wire basically is used whereever there is any third paty involved . Eg- You send the details of payment to a third party or

clearning agent and that further process the check on your behalf with the suppliers


3.When we enter a refund with prepayment by raising debit/credit memo,
what account should be take to raise a dummy invoice.

I Think :
======
a) When you have created Pre-Payment & Paid it
Debit Pre-Payment Expenses
To Cash
* [Prepay Inv- Pre-pay Exp to Liability , Payment Liability to Cash]



b) When you create a Refund, you would Create a Debit Memo . In this i would suggest you to Misc Expenses Account or Any

Expenses which is used to knocking out these transactions .. as after this net impact on that account would be Zero.

Debit Liability
To Expenses [Assume Misc Exp]

When you would create a Refund

Debit Cash
To Liability

c) Now when you create Dumy Invoice

Debit Expenses [Enter Misc Exp]
To Liability

>> Then , apply the orignal Prepayment to this Dummy Invoice ..otherwise that pre-payment would always be available
Thus , after Pre-payment Application

Debit Liability
To Pre-pay Expense

So , in this way you can can also close the Dummy as well as pre-payment Expenses.



AR
2. What are the detailed steps for Auto Invoice?

I Think :
======
Auto Invoice depends upon your data that you intend to Import
For Eg- If you intend to Import TAX , Freight lines - Then you need to configure DFF
Configre DFF
Configure Grouping Rules
Configure Line Orderring Rules
Configure System Options
Configure Transaction Types
Configure Transaction Sources
Incase if you want system to create accounting lines then Auto Accounting rules
If you want to Import data with Accounting rule and Invoicing rule , then you may need to create that also


3.What are the interfaces available in AP,GL,AR?

I Think :
======
AP - Invoice Interface , Interface for Importing Credit Card Related Transactions , Supplier Interface
AR - Invoice , Receipt , Tax Rates , Customer Interface
GL - GL Interface , Exchange Rate Interface

[surya_prabha]

Hi
Thanq for giving a detailed reply for my doubts.

I'll give u one case:

I sold 10 mobiles to my customer @ 4000/- each. After receiving the payment
I found:
1.if the customer wanted to return all the mobiles,
2.if the customer wanted to reurn 2 of them,
3.if the custmoer( is the supplier to me with other business deal for which I need to pay 4000/- for one trx)nwants to return 2 of them

Regards,
Surya

[hbabhu]

Hi Sive,

As per early discussion ?.

I did very thing but I run the report at Payables ?supplier/customer netting report?

I?m getting an print view message as ?No Data Found?

I can?t able to catch what is the problem for one?

The customer balance again show the same balance?..

I try so many time in test machine but getting same?.

Could you share ?..

[Upendra]

Dear Babu

To see the impact of Customer Supplier Netting off report, Customer and Supplier Tax Identification Number must be same.

Step 1. Update your Customer with the Tax Registration Number

Step 2. Update your Supplier with the Tax Registration Number which you have used in Customer defining

Step 3: Currency of the Supplier as well Customer must be one and same. Then only System nets off the balances.

Then, run and see the report output

Upendra DOnepudi

[anusha_rao]

hi
you define a supplier same as customer,and define a clearing account,generate a creditmemo to reduce the customer balance and generate a debit memo to pay the customer in ar.
then switch to ap to pay the supplier using the same clearing account in distributions to refund the security deposit
regards
rao
apps functional consultant

[Dibyajit]

Hi,

In R12, there is no need to create the supplier as a customer. Do a simple refund if you want to refund your customers. It would come to the Payables workbench as a Payment Request type of Invoice and then you can pay off the Invoice like a simple payment.

Go through the details in the user guide how to do it. Its fairly simple.

Regards,
Dibyajit